my favorite oracle sql developer data modeler features
DESCRIPTION
These are the features you need to know about when designing your Oracle data models in Oracle SQL Developer Data Modeler.TRANSCRIPT
![Page 1: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/1.jpg)
![Page 2: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/2.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle SQL Developer Data ModelerMy Favorite Features
Jeff [email protected] || @thatjeffsmithSenior Principal Product ManagerDatabase Development Tools Group
Oracle Confidential – Internal/Restricted/Highly Restricted
Presented with
![Page 3: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/3.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Agenda
A Little History
Talk the Tip
Show the Tip
Questions As We Go!
Take notes or borrow mine at the end…
Improve application developers experience
![Page 4: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/4.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle SQL Developer Data Modeler Overview
FREE Oracle Database Design Tool
Windows, OS X, *NIX
Available in SQL Developer or as a Standalone Application
MOS via DB license
![Page 5: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/5.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
SQL Developer Data ModelerIncluded for free, also available as a separate download/program
Strategy and Analysis
Relational
Database Design
Data Type
Star Schema Physical
Multidimensional
ERD DFD
Logical
Reporting
Import Models
Domains
![Page 6: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/6.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Find stuff
Change stuff
Report on findings
My favorite’ist feature
1. Search
![Page 7: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/7.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
2. SubViews
![Page 8: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/8.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
2 (Bonus). Displays
![Page 9: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/9.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
2 (Bonus+). Comments/Notes
![Page 10: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/10.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
3. Reports
![Page 11: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/11.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Pick your favorite
dozen or data types VS
All however-many
hundred there are
available
Defined in the
Preferences
4. Preferred Data Types
![Page 12: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/12.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Take 1+ properties and
apply them 1+
tables/entities
Example: change
LOGGING storage
property for all tables
5. Propagating Properties
![Page 13: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/13.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
5a. Query Builder for Defining/Testing Views
![Page 14: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/14.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Select table, right-
click, DDL updates as
table focus changes
Physical Design open
– gives you the physical
(storage, security,
PL/SQL, etc.) type
clauses
6. DDL Previews
![Page 15: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/15.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Shift, Select, Drag, Drop
OR Ctrl+Select, Drag..
Ctrl walks thedependency tree
Preview DDL, save, export, etc
7. Drag and Drop Tables to a Model
![Page 16: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/16.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Example, reorder columns for
my tables, PKs, then FKs, then
Not Nulls, then Alpha ASC…
JavaScript
Many ‘out-of-the-box’
Often devs will help you build
new ones via OTN forum
8. Transformations
![Page 17: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/17.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Quickly zoom about your
diagrams
Don’t forget the search &
navigate trick!
9. Navigating Diagrams
![Page 18: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/18.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
10. Design Collaboration via Excel
![Page 19: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/19.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
OTN – SDDM
– Forums
–Modeler Video Demonstrations
–My Data Modeler Tips
SQL Developer Data Modeler Resources
![Page 20: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/20.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
BONUS CONTENT:Oracle SQL Developer Data Modeler 4.1
![Page 21: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/21.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Brand Your Models
Insert your corp. logoor any picture toyour diagrams
![Page 22: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/22.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Support for Constraints on Views
Tables to Views Wizard, new option – create
constraints
![Page 23: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/23.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Support for Constraints on Views
![Page 24: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/24.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Custom DDL Generation via Transformation Scripts
Dynamically generate DDL toprefix/append your objects,or replace entirely
Example: immediately aftergenerating Table Creates, add journaling tables
![Page 25: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/25.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Versioning Status Indicators in the Design Tree
![Page 26: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/26.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Search
SubViews
Reports
Preferred Data Types
Drag ‘n’ Drop Tables to Model
Propagate Properties
DDL Preview
Transformation Scripts
Model Navigator
Excel Collaboration
All of my #SQLDev Posts :)
More Information – in Blog Format
![Page 27: My Favorite Oracle SQL Developer Data Modeler Features](https://reader034.vdocuments.us/reader034/viewer/2022052622/5594452a1a28abf32f8b4821/html5/thumbnails/27.jpg)