| If you are licensing a meta data repository product, your deliverable is an installed and tested product. If you are designing your own meta data repository, you should produce the following design deliverables: -
Physical meta model The physical meta model is a diagram of the physical database structures for the meta data repository. Depending on the selected database design schema, this diagram can be an E-R model or an OO model. It shows tables, columns , primary keys, foreign keys, cardinality, and referential integrity rules. -
Data definition language for the meta data repository The data definition language (DDL) is a set of SQL instructions that tells the DBMS what types of physical database structures to create for the meta data repository, such as databases, table spaces, tables, columns, and indices. -
Data control language for the meta data repository The data control language (DCL) is a set of SQL instructions that tells the DBMS what type of read/write access to the meta data repository to grant. Access can be granted to a person, a group of persons, a program, or a tool. -
Meta data repository programming specifications For the meta data migration process, these programming specifications should define the programming logic for meta data extract, transformation, and load programs, as well as tool interfaces. For the meta data application, these program specifications should define the programming logic for meta data reports and queries, access interfaces, and an online help function.  |
