SQL Developer Statement of Direction - Oracle Designer is [almost] alive...,

website@infoadvisors.com — Thu, 17 Jul 2008 19:10:01 GMT

Is Oracle Designer going to rise from the ashes? Recently Oracle issued a statement of direction for their SQL Developer toolset that includes support for logical and physical data modeling via an add-on product. There is no information about pricing for this add-on.

Oracle SQL Developer Statement of Direction

Updated June 2008

Oracle SQL Developer

Oracle SQL Developer enhances productivity and simplifies database development tasks by providing a graphical interface for browsing database objects, creating and updating objects and running SQL statements and scripts. Using SQL Developer you can create, edit and debug PL/SQL statements, and create and run reports. SQL Developer supports connections to and migrations from third-party databases; MySQL, Microsoft SQL Server, Microsoft Access and Sybase Adaptive Server, and users can work with files using the integrated Subversion and CVS version control support. SQL Developer connects to any Oracle Database version 9.2.0.1 and later and supports a variety of platforms including Windows, Linux and Mac OSX.

SQL Developer was initially released as an early adopter on the 28th of December 2005. Since initial production in March 2006, SQL Developer has maintained a position of the second most downloaded product on OTN after the database, and by May 2008 had passed 1 million downloads, with over 1.2 million users. Oracle SQL Developer ships Oracle Database 11gR1 and is included in the Oracle JDeveloper 11g (Beta).

Future Releases

The next release of Oracle SQL Developer focuses on providing complete graphical logical and physical data modeling functionality delivered as an optional extension to SQL Developer. Customers who do not select the data modeling option will be able to continue to use the base SQL Developer product. The base product will continue to benefit from further updates, with new features added gathered from the user community requirements.

Plans for the next release of Oracle SQL Developer and beyond include the following:

Database Data Modeling to support:

Designing logical Entity Relation Diagrams

Building physical schema designs

Generating and executing DDL scripts

Reverse and forward engineering of existing relational data structures

Data domain administration

Naming standardization

Model formatting (font, colors)

Importing data models from CA Erwin and Oracle Designer

Compare and merge facilities

Multiple database support

Oracle Database

DB2 (Mainframe & UDB)

Microsoft SQL Server

Logical and physical multi-dimensional modeling

Object relational Data Types

Spatial Modeling

Multi-level logical and physical design environments

Model validation rules

Offline (file based) and Repository based modeling

SQL Developer Statement of Direction

Karen Lopez: Musings on Data, Process, and Architecture

SQL Developer Statement of Direction - Oracle Designer is [almost] alive...,