Oracle intros SQL developer data modeler

BANGALORE, INDIA: Oracle on Tuesday announced that it has introduced  Oracle SQL developer data modeler, to help developers quickly and easily design data models for the Oracle Database.

This new tool supports logical, relational, multi-dimensional and data type modeling while featuring multi-layered design and generation capabilities to produce conceptual entity relationship diagrams (ERDs) and transform them to relational models, said a press release.

Mike Hichwa, vice president of Software Development, Oracle said, “Every successful application starts with a strong data model. Oracle SQL Developer Data Modeler not only provides a graphical way to develop data models, but an effective way to communicate existing data models to application developers.”

The Oracle SQL developer data modeler features include :-

Spanning: visual entity relationship modeling – Supports both Barker and Bachman notations so developers can switch between models to suit the audience’s needs or create and save different visual displays;

Forward engineering ERDs to relational models – Transforms all rules and decisions made at the conceptual level to the relational model, where details are further refined and updated;

Separate relational and physical models – Enables developers to develop a single relational model for different database versions or different databases such as Oracle Database, IBM DB2 V7 and V8 for Linux, UNIX and Windows and OS/390 mainframe, and Microsoft SQL Server 2000 and 2005;

Full spectrum of physical database definitions – Supports physical definitions such as partitions, roles, and tablespaces for specific database versions for multi-database, multi-vendor support leading to improved developer consistency and productivity.

The new tool integrates seamlessly with Oracle SQL developer, to let developers open and view previously developed designs as well as query, run and write reports against the reporting repository.

This platform is available for all editions of Oracle Database 11g and runs on Windows, Linux and Mac OS X. The tool is also available for Oracle Database 10g, said the release.

Oracle SQL developer data modeler is generally available now and can be downloaded from the Oracle Technology Network (OTN).