Glossary

·          

·         DDL (Data Definition Language): DDL code groups together SQL database schema creation and modification instructions (for example, create TABLE).

·         Generation work product: (Objecteering terminology) This indicates a source file generated by Objecteering. A DDL generation work product is an SQL file.

·         Logical model: This is an analysis model created by you and annotated so as to allow the physical model to be deduced.

·         Physical model: This is a relational model corresponding to a logical model. A physical model is made up of schemas, tables, views and utility classes containing stored procedures. These elements are represented by packages stereotyped <<schema>> and classes stereotyped <<table>>, <<sqlView>> and <<procedureClass>>.

·         Primary key: The primary key of a relational table is composed of one or more attributes (the table's columns). It is used to clearly identify instances (in other words, an ordered list of values).

·         RDBMS: Relational Database Management System. The RDBMS supported are Oracle, Sybase and SQL Server.

·         Type project: This is a project that contains the mapping of Objecteering types to the target RDBMS SQL types.