* Download and install the Oracle SQL Developer Data Modeler software. More information about installing, configuring, and maintaining Oracle Database XE is available in the online documentation. * Download and install Oracle Database 10g Express Edition (XE). The demonstration provided in this article runs on a Windows OS machine and uses the freely available Oracle Database Express EditionIf you have not done so already, do the following: Currently it is available as a standalone product, but there are plans in the works to make it available as an extension to Oracle SQL Developer. Oracle SQL Developer Data Modeler is platform independent and is compatible with Oracle Database version 9.2.0.1 and later. This article will show you how to install and configure Oracle SQL Developer, generate an ERD based upon the supplied HR demonstration schema, and export a SQL Data Definition Language (DDL) creation script for the schema. Its many capabilities include code generation, import and export to a variety of destinations, formatting functionality, and rule-based validation of models. As such, it streamlines the development process to promote robust, complete, and well-designed databases. It is based on standards including the Zachman Framework, as well as the Object Management Group's MetaObject Facility (MOF) and Common Warehouse Metamodel (CMW) specifications. Oracle SQL Developer Data Modeler has many features related to designing and implementing databases. Oracle recognizes this need and has introduced Oracle SQL Developer Data Modeler to provide a variety of data and database modeling tools and utilities. In particular, entity relationship diagrams (ERDs) are a popular way to represent the design of a set of database tables and their relationships in a compact, expressive manner. However, one feature not included is the ability to create database diagrams. You can also run supplied database reports and even create and save your own queries as reports. With Oracle SQL Developer, you can browse database objects, run SQL statements and scripts, and write and run PL/SQL programs. New features have been added in each release, demonstrating Oracle's commitment to continuing to enhance this product. Oracle SQL Developer has quickly become a popular graphical tool for database development.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |