Summary

In this chapter, you had an insight into the features offered by SQL Developer Data Modeler. 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 we can import models from 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 to build an entire Entity Relationship Diagram or update schema models and generate DDL scripts.

In the next chapter, we'll discuss SQL Developer's extensible framework and look at how we can create user-defined extensions and use XML with embedded SQL and PL/SQL to add features...