print Printer View e-mail E-mail this page Bookmark Bookmark


Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is the latest product offering from the Oracle Database Tools group. SQL Developer Data Modeler is an independent, standalone product with a full spectrum of data and database modeling tools and utilities, including modeling for Entity Relationship Diagrams (ERD), Relational (database design), Data Type and Multi-dimensional modeling, full forward and reverse engineering and DDL code generation. The 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 can connect to any supported Oracle Database and is platform independent. A read-only SQL Developer Data Modeler Viewer is also available for download. The viewer allows users to open models created in the Data Modeler.

News

The SQL Developer team is pleased to announce the first production release of Oracle SQL Developer Data Modeler. (1 July 2009)
Getting Started Data Sheets, White Papers and Articles
Release Notes
Feature List

Documentation

Frequently Asked Questions

Statement of Direction
Data Sheet (pdf)
Data Modeler Overview (Technical white paper - pdf)

General Overview (Presentation - pdf)

Naming Standards (Technical white paper - pdf)

 
Tutorials Online Demonstrations
Adding a Table to an Existing Database
Modifying a Logical Model Using Inheritance and Object Types
Generating a Multi-Dimensional Model
Reviewing your Oracle SQL Developer Data Modeler Design
Creating a Basic Relational Model (Learn about Name Templates)
Import DDL to Create a Relational Model (See the Merge Swap Dialog)
Import from the Data Dictionary (Review Logical and Physical Models)
 

Sample Schema Scripts and Models

You don't need a database to try these scripts and view these models.
Sample DDL Scripts
For each of the scripts below, download and extract the *.sql from the zip file. Select File > Import > DDL File to import the script.
Import the HR sample - Download
Import the OE sample - Download
Import the PM sample - Download
Import the SH sample - Download
Sample Data Models
For each of the scripts below, download and extract the zip file. Select File > Open and browse to the directory. There is an xml file and folder of the same name. In each case select the top level xml file.
HR data model - Download , open hr.xml
SH data model - Download, open sh.xml
OE data model - Download, open oe.xml
PM data model - Download, open pm.xml
Multi-schema model - Download, open all_schemas.xml
(this includes an ERD, Multi-dimensional and Relational model)
 

SQL Developer Data Modeler with ERD
(Click for larger view)

Oracle Designer repository import dialog
(Click for larger view)
Add Domains with Valid Values
(Click for larger view)


SQL Developer Data Modeler with relational model
(Click for larger view)


Set Naming Standard Templates for Keys and Constraints
(Click for larger view)
Generate DDL Script
(Click for larger view)
 
 
Free Download
Download (1 July '09)
Oracle SQL Developer Data Modeler

Left Curve
Oracle Store
 Right Curve

Buy Oracle SQL Developer Data Modeler online at the Oracle Store

Left Curve
Related Technologies
 Right Curve
 · Oracle SQL Developer
 · Oracle Database 11g
· Oracle Database 10g Express Edition
 · Oracle Application Express
 · Oracle JDeveloper

Left Curve
Related Technologies
 Right Curve
 · OTN Forum
 · SQL Developer Exchange (Log new feature requests)

Left Curve
Related Blogs
 Right Curve
 · Sue Harper

Left Curve
Podcasts and Video Interviews
 Right Curve
 · US Marine Corps Simplifies Data Modeling (MP3)
· Sue Harper talks to Justin Kestelyn: Download Video

 

 

 

 
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy