| Description | The physical implementation format of the Logical Data Model entities, e.g., message formats, file structures, physical schema. In DoDAF V1.5, this was the SV-11. |
|---|---|
| Dictionary |
SysFEAT - DoDAF 2 |
| Parent Domain |
DODAF2 - Data and Information Viewpoint |
| Concept | Description |
|---|---|
Column Type |
An Column Type is specification of the content of a Column such as "customer name", "order date", "address". |
Enterprise |
An Enterprise is a macro Enduring Initiative that delivers added-value Products (goods & services) to its target Customers. It requires a formal organization of groups of people and resources to achieve its purposes. |
Relational Data Map |
|
Relational Schema |
A Relational Schema is a set of relational Table , keys, indexes and associated items that represent the structure of a relational database. A relational database can have multiple schemas. |
Table |
A Table is a relational data structure, used as the reference for the switch to production. The Table is the central element of the relational databases. A table is accessible by means of a primary key, and if necessary foreign keys; it is described by an ordered sequence of Columns. A Table is generally derived from a Logical Data Entity or asssociation.
|
Table View |
A Table View is a virtual table based on the result-set of an SQL statement. A Table View contains rows and columns, just like a real Table. |
| Concept | Description |
|---|---|
Physical Data Map |
A Physical Data Map is a top level grouping of Physical Data Domains. |
Relational Data bLOCK |
A Relational Data bLOCK is a Data Asset used for description of relational data consumed and produced by Business Software Systems. Relational Data bLOCKs range from Relational Schemas to Column Types. They are defined in Relational Dictionary(ies) and managed in Data Catalogs. |
Relational Entity |
A Relational Entity is a relational data structure that is either a Table or a Table View. A Relational Entity is accessible by means of a primary key, and if necessary foreign keys; it is described by an ordered sequence of Columns.
|