Summary
In this chapter, you have had an insight into the features offered by SQL Developer Data Modeler. The Data Modeler provides a number of graphical and textual modeling tools for Logical, Relational, and Multidimensional models. We looked at how to create Logical and Relational models, and how you can import models form the data dictionary or create models from scratch. We looked at forward and reverse engineering, how to build a physical model, and generate the DDL.
The subject of data modeling is vast, and this chapter only introduced some of the many and varied features available in SQL Developer Data Modeler. Whether you are a data architect, or updating an existing design, you can use SQL Developer Data Modeler for building full Entity Relationship Diagram or update schema models and generate the DDL scripts.
In the next chapter, we'll discuss SQL Developer's extensible framework, and look at how you can create user-defined extensions, using XML with embedded SQL and PL/SQL to add...