| PHYSICAL MODEL |
Architecture | |||||
| The Physical Model determines how the logical information objects in the Business Model will be implemented in the physical database. The Physical Model captures all information concerning tables, indices, foreign key references, sequences, triggers, super-entity and shared table references, referential constraints, and domains. |
|
|||||
| Prototyping | During prototyping, OmniBuilder ensures that the Physical Model corresponds to the Business Model. Modifications to the Business Model automatically result (if the development team so wishes) in changes to the Physical Model. For example, if a relationship is added to an entity, an index and a foreign key are automatically added to the table in the Physical Model and the database. If the relationship is later removed in the Business Model, the Physical Model will be returned to its original state. | |||||
 Reverse-Engineering |
In certain circumstances, it may be desirable to derive the Physical and Business Models from an existing database to establish the foundation for future development or to document an existing application. OmniBuilder’s Reverse Engineering Wizard provides a point-and-click interface that allows the user to easily create both Business and Physical Models from an existing database. In the Business Model, it will then be possible to hide implementation details, rename columns, and provide documentation for entities. | |||||
| Development Environment |
OmniBuilder produces SQL scripts that automatically establish a new database environment or bring an existing environment up-to-date. This feature greatly reduces the configuration management tasks associated with maintaining development, test, and production environments. | |||||
 |
||||||
< SQL script for Position>
Create table Position (Primary key ..
Create index BK_Position on …\
Create sequence Position_S …
< alter script for Position> Alter table Position modify (Maximum_Salary … Alter table Position modify (Oid_Reporting_Dept … Add constraint fk_423573 Foreign key (oid_Position) References Position (oid)
|
||||||
