Data Management

Introduction to Oracle SQL Developer Data Modeler

Date Added: Jul 2009
Format: HTML

Oracle SQL Developer is a graphical tool that is designed for database environment. This solution is used to browse database objects, run SQL statements and scripts, write and run PL/SQL programs. It can also be utilized to run supplied database reports, and to create and save queries as reports. Entity Relationship Diagrams (ERDs) are used to characterize the design of a set of database tables and their relationships in a compact manner. Oracle SQL Developer Data Modeler is introduced by Oracle to provide various data and database modeling tools and utilities. Various features related to designing and implementing databases are included in Oracle SQL Developer Data Modeler. The modeler is designed to modernize the development process to support strong, complete, well-designed databases. Oracle SQL Developer Data Modeler has a range of capabilities including code generation, import and export to various destinations, formatting functionality, and rule-based validation of models. Discussed in this paper are the methods required to install and configure Oracle SQL Developer, generate an ERD based upon the supplied HT demonstration schema, and export a SQL Data Definition Language (DDL) creation script for the schema. Oracle SQL Developer Data Modeler provides the data developers with the capacity to control, examine, and execute data models in an organized and integrated manner. It provides tools for data management and architecture tasks.