System Form | Database Design | Teradata Vantage - System Form - Advanced SQL Engine - Teradata Database

Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval
dita:id
B035-1094
lifecycle
previous
Product Category
Teradata Vantage™

A system is a set of application programs, or applications, grouped by business function. Applications are grouped into systems because each cluster of applications typically serves a different user community within the enterprise.

In terms of ATM, an application is a major business function. Each application is implemented by a set of transactions (see Application Form).

Ensuring that applications are clustered into the appropriate systems is the most important activity undertaken during this stage of the ATM process. The information described by the System form is generic and applies irrespective of the eventual physical implementation of the database.

The System form has two purposes:
  • Identify all applications, grouping them by their business system.
  • Provide input to the Application and Table forms.

This form supports the third step in the ATM process (see Goals of the ATM Process).

Information Recorded

Information Recorded Description
ELDM Page Page of the Extended Logical Data Model to which this system pertains.
System Name Name of the business system in which the applications using this constraint are defined.
System Description Brief description of the function of the system.
Application ID Unique identifier for the application being documented.
Application Name Full text name of the application being documented.
User Contacts Names and other useful information pertaining to principal users of the application.

Example: System Form

System ELDM Page: 1

Page: ___of ___

System: PTS
System Name:          Part Tracking System (PTS)                                                       
System Description:      Tracks current status and history of each part over its lifetime.              
     
Application ID Application Name User Contacts
Cust Customer tracking Joy Calder X829
PCat Part categories Bill Alpert
Rpt Parts reporting Hall Werts