| Description | |
|---|---|
| Dictionary |
Dictionary of SysFEAT concepts |
| Parent Domain | |
| Domain dependencies |
Architecture Packages
EA Pattern - Physical Data Domain
Logical Application Architecture |
| Consuming Method |
Analyze data lineage |
| 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. |
NoSQL Data Schema |
A NoSQL Data Schema represents a set of data stored in a NOSQL database management system and used in Application Deployment Architectures. |
NoSQL Dataset |
A NoSQL Dataset is a Physical Data Entity that represents the structure of a collection of related data held in a data source. The represented data structure can be relational (Table) or NoSQL (triple store, document store, flat files, etc.). A NoSQL Dataset consists of three types of NoSQL Field: 1) An Identification MetaField, sometimes called "primary key". 2) Relationship MetaFields used to represent relationships with other NoSQL Datasets. 3) Value MetaFields used to store values in the NoSQL Dataset. NoSQL Datasets can be defined at design time in the context of data architecture activities. They can also be imported automatically through data discovery.
|
NoSQL Dictionary |
|
NoSQL Library |
|
Primitive Type |
A Primitive Type is a NoSQL Field that represents a data format such as "string", "integer". |
Relational Data Map |
|
Relational Dictionary |
A Relational Dictionary is a Physical Data Dictionary of relational entities (Tables, Keys, Indexes, etc.) and of Relational Schema referencing theses entites. |
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. |
Simple Field |
A Simple Field is a NoSQL Field that represent a single piece of data. A Simple Field cannot be decomposed. Simple Fields are often described by their name, primitive type and length. For instance, "customer name", "customer id" and "stree number" are usually considered as Simple Fields. |
Stored Procedure |
A Stored Procedure is a is a subroutine available to applications that access a relational database management system (RDBMS). It is a kind of Resource Process handled by RDBMS. |
Structured Field |
A Structured Field is a NoSQL Field which is a combination of other NoSQL Fields. For instance, an address in composed of a street field, a city field and a country field. |
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 |
|---|---|
NoSQL Data Asset |
A NoSQL Data Asset is a Physical Data Asset used for the physical description of data consumed and produced by Software Systems. NoSQL Data Assets range from NoSQL Data Schemas to NoSQL Fields. They are defined in MetaData Dictionary(ies) and managed in Data Catalogs. |
NoSQL Element |
A NoSQL Element is Physical Data Asset that represents an element of a physical schema as it will be stored in relational or non relational DBMS (NoSQL, triple store, document store, flat files, etc.). A NoSQL Element is either a NoSQL Dataset or a NoSQL Field. |
NoSQL Field |
A NoSQL Field is a Physical Data Property that is the specification of the content of a NoSQL Dataset. NoSQL Fields can be "reused" by multiple NoSQL Datasets where they play the role of Identification MetaField, Relationship MetaField or Value MetaField. A NoSQL Field can be : 1) a Primitive Type that defines the data type of a field, such as "string" or "integer". 2) a Simple Field that defines a simple value such as "customer name" or "delivery date". Simple Fields are often described by their name, primitive type and length. 3) a Structured Field that defines complex values such as "address". |
Physical Data Dictionary |
A Physical Data Dictionary is Physical Data Dictionary that holds the definition of Physical Data Blocks such as Physical Data Domain definitions, Table definitions, Column Type definitions. |
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.
|