Updated Oracle SQL Developer Data Modeler Supports Collaborative Development

Oracle SQL Developer Data Modeler Release 3.0 integrates with subversion to enable team development, supports user-defined design rules.

Note: ESJ's editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

To further assist data modelers, developers, and IT architects to quickly and easily design data models for Oracle Database and other databases, Oracle has created Oracle SQL Developer Data Modeler Release 3.0.

The update supports collaborative development through integration with the popular Subversion open-source version control software, as well as the incorporation of user-defined design rules and transformation scripts.

Oracle SQL Developer Data Modeler supports logical, relational, multi-dimensional, and data-type modeling and features multi-layered design and generation capabilities to produce conceptual entity relationship diagrams (ERDs) and transform them to relational models. Users -- including data modelers, developers, and architects -- can build, extend, and modify a model as well as compare it to existing designs.

Integration with Subversion enables Oracle SQL Developer Data Modeler users to maintain current and historical versions of designs, support multi-user access to allow teams to develop the same model, and notify users of changes to models as well as allow users to accept and merge changes.

This latest release offers greater flexibility by enabling users to write rules based on corporate standards or design-specific criteria. Oracle SQL Developer Data Modeler includes a large set of pre-defined design rules for use during the development process to help identify any errors on inconsistencies in the design.

New support for user-defined transformation scripts enables developers to make global changes or updates to a design such as adding a set of standard columns to all tables or adding or removing prefixes to tables or columns in a model.

The tool integrates with Oracle SQL Developer -- the popular graphical tool for database development -- so developers can open and view (and now update) previously developed designs as well as query, run, and write reports against the reporting repository.

Oracle SQL Developer Data Modeler 3.0 helps users design and develop for Oracle Database 11g, IBM DB2 for Linux, UNIX and Windows (V7 and V8), IBM DB2 for OS/390 and z/OS, and Microsoft SQL Server 2000 and 2005. The tool also imports data models from Oracle and non-Oracle products such as Oracle Designer and CA Erwin (Data Modeler 4.x and 7.x).

Oracle SQL Developer Data Modeler is a feature of the Oracle Database and is supported through My Oracle Support with any Oracle Database license and runs on Windows, Linux, and Mac OS X.

More information is available at www.oracle.com

Must Read Articles