Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer that allows users to open previously created data models and create read-only models of their database schemas. SQL Developer Data Modeler is a vast tool, supporting the design of logical entity relationship diagrams and relational models, with forward and reverse engineering capabilities between the two. It supports multi-dimensional, data flow, data type, and physical models and allows files to be imported from a variety of sources and exported to a variety of destinations.
It allows users to set naming conventions and verify designs using a set of predefined design rules. Each of these topics is extensive. So, in this chapter, we'll review a few areas, illustrating how you can use them and highlight a few key features using the...