Oracle SQL Developer - Data modeler

Prophet SQL Developer Data Modeler is a free graphical device that upgrades efficiency and streamlines information demonstrating undertakings. Utilizing Oracle SQL Developer Data Modeler clients can make, peruse and alter, consistent, social, physical, multi-dimensional, and information type models. The Data Modeler gives forward and figuring out abilities and supports collective improvement through coordinated source code control. The Data Modeler can be utilized in both customary and in Cloud situations.

Features of Oracle SQL Developer Data Modeler :

In this article, We will attempt to make reference to just those highlights which can be important to our work.

 

1) Logical Model bolstered highlights :

• ER charting.
• Entity pecking orders with systems for building to social models
• Box-in-box introduction for pecking orders (supertypes and subtypes)
• Support for fundamentally unrelated connections (circular segments)
• Engineering to and from social models (make, analyze and synchronize changes)
• Compare and converge with coherent model in another structure

 

2) Relational Model upheld highlights :

• Define touchy and by and by recognizable data
• Mutually restrictive (circular segments), obligatory (discretionary) and transferable remote keys
• Automatic proliferation and synchronization of remote key segments
• Import DDL contents or import from database word reference
• Compare and additionally converge to models in different plans, a status of database word reference or status in DDL contents.

 

3) Naming Standards bolstered highlights :

• Glossary for allowed prime, class, modifier and qualifier words
• Name structure for components in Logical and Relational models
• Model level limitations for – name length, potential characters, utilized letter case
• Name interpretation during designing among legitimate and social models
• Naming layouts for table imperatives and lists
• Prefix the board

 

4) Design Rules bolstered highlights :

Sets of predefined configuration rules can be utilized to approve the accuracy of data in all models.

• Create client characterized Design Rules.
• Group assortments of configuration governs in Design Rule sets.
• Build libraries of Design Rules.