How to use Oracle SQL Developer Data Modeler
Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle SQL Developer Data Modeler is a data modeling and design tool used to increase developer productivity by providing the means to develop logical, multi-dimensional, user defined data types, relational and physical data models.
Features of Oracle SQL Developer Data Modeler:
Logical Models
Subject Area Management
Impact Analysis
Data Types Models
Naming Standards
Relational Models
Design Rules
Dimensional Models
Importing
Data Flow Diagrams Reporting
Physical Models (Database specific)
Integrated Version Support
Domains
Wizards
Uses of Oracle SQL Developer Data Modeler:
Oracle SQL Developer Data Modeler is a tool that enables you to diagrammatically display your database objects, make changes, and update the schema based on the changes quickly and easily. It is a standalone, independent product available for download and evaluation from OTN.
Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer, which allows users to open previously created data models and to create read-only models of their database schemas.
The Oracle SQL Developer Data Modeler tool provides full forward engineering, including engineering from Logical ERD models to Relational models and the reverse, importing from the Data Dictionary and DDL script generation.
The Oracle SQL Developer Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules.
Oracle SQL Developer Data Modeler provides a model driven approach for database design and generation, implemented by integrated set of models – Logical, Data types, Dimensional, Relational, Data
When you model a table in your relational model using Oracle SQL Developer Data Modeler, you are probably very curious as to the code that is being generated to represent that object.
Oracle SQL Developer Data Modeling can also export it to DDL.