Jul 17

Written by: Karen Lopez
Thursday, July 17, 2008 2:10 PM

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

Tags: