advertisement

Oracle SQL Developer Data Modeler - Version Control Your Designs

50 %
50 %
advertisement
Information about Oracle SQL Developer Data Modeler - Version Control Your Designs
Technology

Published on March 3, 2014

Author: hillbillyToad

Source: slideshare.net

Description

A brief overview of SQL Developer Data Modeler and step-by-step guide to adding your design to Subversion, generating DDL Alter Scripts, and more.
advertisement

1 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Collaborative Design with Oracle SQL Developer Data Modeler Jeff Smith, Product Manager Jeff.d.smith@oracle.com @thatjeffsmith

Legal The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. 3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Agenda  Brief functional overview  Using Subversion to Version Your Designs – Team collaboration  Resources Hint: Click on the blue text for more info 4 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Oracle SQL Developer Data Modeler Overview  No cost diagramming and data modeling tool – standalone or within SQL Developer  Single tool for design and review  Modeling across platforms within one integrated system  Business rule and process flow documentation and verification 5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer Data Modeling Strategy and Analysis Import Models Data Type Domains DFD ERD Logical Multidimensional Reporting Database Design Relational 6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Star Schema Physical Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Logical Modeling  Model entities, attributes, relations and entity type hierarchies  Transform logical to many relational and multidimensional models  Configurable forward and reverse engineering  Provide different modeling notations and displays of same model  Use subviews to work on subset of model 7 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Relational Modeling  Model tables, columns and foreign keys  Map one logical data model to one or more relational models  Configurable forward and reverse engineering  Use subviews to work on subset of model 8 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Physical Modeling  Storage, Security, Stored Procedures  Compression, Partitioning, Encryption, Redaction  One or more physical models per relational model for different deployments  Data warehouse  OLTP  11g vs 12c 9 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Working with Diagrams  Adjust Content  Adjust Anchor Points  Subviews  Multiple Displays 10 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Working with Objects Properties Dialog 11 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Forward and Reverse Engineering  Engineering options: General, compare/copy, and synch  Include design glossary and naming standards 12 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Collaborative Design Overview 13 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Collaborative Design  Use Team > Versions to connect to Subversion repository  Add Design using Data Modeler  1 or more users check out designs  Pending Changes dialog provides feedback to all users  Commit changes to repository  Manage conflicts  Review/Manage Version History 14 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Let’s Talk Subversion and SQL Developer  1 model → many files  Each entity/table gets it’s own file  You deal with model entities, not files  File tagging allows us to Compare/Merge/Commit models at the object level  Use existing Subversion Repository or deploy w/ SQL Developer 15 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Adding an Existing Model to Subversion  New Remote Directory  Check out directory  Create local directory/copy  Open existing model  Save to local folder 16 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Now Watch SVN Add the Model files in the BG 17 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Save Model to See Outgoing Changes 18 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Compare Model to Last Repository Revision  See differences side-by-side  Highlighted in red  Merge if you agree 19 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Bonus Feature: Track Diagram Changes Too 20 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Compare Model to Data Dictionary Generate DDL Synch Scripts  Diffs & Alter Scripts  Compare 2 versions of the same model 21 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Thanks! Download SQL Developer Data Modeler Product Forums YouTube Channel 22 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Graphic Section Divider 23 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

SQL Developer Data Modeler - Oracle

Oracle SQL Developer Data Modeler is a free ... integrated source code control. The Data Modeler can be used ... SQL Developer; SQL Developer Data Modeler;
Read more

» How To Version Control Your SQL Developer Data Modeler ...

Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free.
Read more

- Oracle

Oracle SQL Developer ... SQL Developer Data Modeler 3.0 •Integrated version control ... •Open multiple designs in single Data ...
Read more

Oracle SQL Developer Data Modeler - Version Control Your ...

Reverse Engineering an Existing Database Using Oracle SQL Developer Data Modeler
Read more

Querying Your Oracle SQL Developer Data Modeler Designs

... in our Oracle SQL Developer Data Modeler ... Oracle SQL Developer Data Modeler Designs. ... very easy to control and version changes to your data ...
Read more

Collaborative Design with Oracle SQL Developer Data Modeler

Collaborative Design with Oracle SQL Developer Data Modeler ... and control of your designs. ... future version, however the nature of modeler ...
Read more

Oracle SQL Developer - docs.oracle.com

Oracle® SQL Developer Data Modeler User's Guide ... Batik Version 1.7 ... 1.1 Installing and Getting Started with SQL Developer Data Modeler ...
Read more

Collaborative Design with Oracle SQL Developer Data Modeler

Product Manager for Oracle SQL Developer and SQL Developer Data ... for version control, ... to have as your working directory (Data Modeler will ...
Read more

Data Modeler Concepts and Usage - Oracle

SQL Developer Data Modeler is a data ... however, that Oracle strongly recommends that you run your ... metadata and data about Data Modeler designs.
Read more