Oracle Introduces Oracle SQL Developer Data Modeler

REDWOOD SHORES, CA -- (MARKET WIRE) -- Jul 07, 2009 -- Oracle (NASDAQ: ORCL)

News Facts

  • To help developers quickly and easily design data models for the Oracle® Database, Oracle today introduced the Oracle SQL Developer Data Modeler.
  • This comprehensive, standalone 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. Users can build, extend and modify a model as well as compare with existing designs.
  • Oracle SQL Developer Data Modeler is generally available today and is downloadable from the Oracle Technology Network (OTN).

Delivering Comprehensive Capabilities to Ease Data Model Development

  • Data models are powerful communication aids that are used when initiating projects and consolidating or updating existing projects.
  • Oracle SQL Developer Data Modeler delivers a spectrum of data and database modeling capabilities 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; and,
    • 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 - Oracle's popular graphical tool for database development - to let developers open and view previously developed designs as well as query, run and write reports against the reporting repository.
  • Oracle SQL Developer Data Modeler 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.

Supporting Quotes
"Every successful application starts with a strong data model," said Mike Hichwa, vice president of Software Development, Oracle. "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."

"There are many data modeling tools available to the development community," said Maggie Tompkins, Civilian Marine with the United States Marine Corps, and long-standing member of Oracle Development Tools User Group (ODTUG). "The idea is to select one that does data models plus adds value to your products or organization. We've been using the early adopter release of Oracle SQL Developer Data Modeler, and have found it feature rich and easy to use. Having taught data modeling to others for many years, most class time is spent learning a tool. It's just the opposite with Oracle SQL Developer Data Modeler. It's so intuitive to use that we can focus class time on the actual data model, its content and meaning, and not the 'how to' of the tool."

Supporting Resources

About Oracle SQL Developer

Oracle SQL Developer Data Modeler Data Sheet

Oracle SQL Developer Data Modeler Whitepaper

Oracle Expert Blog: Sue Harper

Oracle Forum: Oracle SQL Developer

Download a free, evaluation version of Oracle SQL Developer Data Modeler. Terms, conditions and restrictions apply.

About Oracle
Oracle (NASDAQ: ORCL) is the world's largest business software company. For more information about Oracle, please visit our Web site at

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.


Eloy Ontiveros

Email Contact

Kristin Reeves
Blanc & Otus for Oracle

Email Contact

Review Article Be the first to review this article

Featured Video
System Designer/Engineer for Bluewater at Southfield, Michigan
Mechanical Engineer for Allen & Shariff Corporation at Pittsburgh, Pennsylvania
Mid-Level Mechanical Engineer for Kiewit at lenexa, Kansas
Geospatial Analyst/Programmer for LANDIQ at Sacramento, California
Product Manager for CHA Consulting, Inc. at Boston, Massachusetts
Software Developer for CHA Consulting, Inc. at Norwell, Massachusetts
Upcoming Events
ESPRIT World 2018 at Indianapolis Marriott Downtown 350 West Maryland Street Indianapolis IN - Jun 11 - 15, 2018
HxGN LIVE 2018 at The Venetian Las Vegas NV - Jun 12 - 15, 2018
IMTS2018 International Manufacturing Tech Show at McCormick Place Chicago IL - Sep 10 - 15, 2018
4th International Conference on Sensors and Electronic Instrumentation Advances (SEIA' 2018) at Movenpick Hotel Amsterdam City Centre Amsterdam Netherlands - Sep 19 - 21, 2018
Kenesto: 30 day trial

Internet Business Systems © 2018 Internet Business Systems, Inc.
25 North 14th Steet, Suite 710, San Jose, CA 95112
+1 (408) 882-6554 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation GISCafe - Geographical Information Services TechJobsCafe - Technical Jobs and Resumes ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise