| Data Warehouse Glossary |
|
If you do not see a particular word or phrase that you would like to know the definition of, please let us know by email and indicate the term you would like to be added to the Glossary. |
|
| |
| |
A
B
C
D
E
F
G
H
I
J
K
L
M
N O
P
Q
R
S
T
U
V
W
X
Y
Z |
|
| |
| Efficiency |
| |
The creation of the biggest possible profit with the smallest possible costs |
| |
| EIS |
| |
|
| |
| Element |
| |
A thing of significance about which information is recorded; a component at the most useful, basic level. |
| |
| Element Type |
| |
Any element held in the repository is classified as a particular type. Examples of element type are entity, attribute, program module, process, table, diagram, text, softbox. Occurrences or instances of these are called elements. |
| |
| End User Data |
| |
Data formatted for end-user query processing; data created by end users; data provided by a data warehouse. |
| |
| End-User Layer |
| |
The user interface and layout of the multidimensional structures designed for the data access tools. This includes the customization of the tools for the users. |
| |
| Enterprise |
| |
A group of departments, divisions, or companies which make up an entire business. |
| |
| Enterprise Data |
| |
Data that is defined for use across a corporate environment. |
| |
| Enterprise Data Model |
| |
A blueprint for all of the data used by all departments in the enterprise. An Enterprise Data Model has resolved all of the potential inconsistencies and parochial interpretations of the data used and presents a consistent and commonly understood and accepted view and definition of the enterprise data. |
| |
| Enterprise Data Warehouse |
| |
An Enterprise data warehouse is a Centralized Warehouse which services the entire enterprise. |
| |
| Enterprise Storage |
| |
A shared central repository for information, connected to disparate computer systems, that provides common management, protection and information sharing capabilities. |
| |
| Enterprise Support Systems |
| |
The set of all computer-based systems, documents, and procedures used in support of business enterprise operations. |
| |
| Enterprise System Connection Architecture (ESCON) |
| |
An IBM mainframe channel architecture commonly used to attach storage devices. |
| |
| Enterprise Technical Architecture (ETA) |
| |
A series of rules, guidelines, and principles used by an organization to direct the process of acquiring, building, modifying, delivering, and integrating Information Technology resources throughout the enterprise. These resources can include equipment, software, business processors, protocols, standards, methodologies, IT organizational structures and more. |
| |
| Entity |
| |
A thing of significance, whether real or imagined, about which information eeds to be known or held. It is implemented in a database as one or more tables. |
| |
| Entity Relationship Diagram (ERD) |
| |
A diagram that pictorially represents entities, the relationships between them and the attributes used to describe them. |
| |
| Entity Relationship Model |
| |
A type of data model. Part of the business model that consists of many Entity Relationship Diagrams. |
| |
| Entity Structure Chart |
| |
A chart that shows the existence and structure of data attributes and data entities in the common data structure. It directly supports the entity relation diagram to provide a complete representation of the logical data structure. |
| |
| ETL |
| |
Stands for Extraction, Tansformation, and Loading. The movement of data from one area to another. |
| |
| Event |
| |
An occurrence in a business’s environment to which that business must respond; see also BUSINESS SYSTEM and EVENT RESPONSE . |
| |
| Event Frequency |
| |
The frequency at which an event occurs or an object changes in the real world. |
| |
| Executive Information System (EIS) |
| |
A reporting application targeted for use by executives. Usually such applications have extremely user-friendly, graphical interfaces with a small local data store derived from connection to a data warehouse. It is often used synonymously with decision support system. |
| |
| Existing Data Quality Criteria |
| |
The criteria documenting the data quality that currently exists in the data resource. |
| |
| Extensibility |
| |
The ability to add new components, technology, and increments to the data warehouse solution. This is a critical capability for the data warehouse architecture and technical architecture. |
| |
| External Data Source |
| |
A system or data file provided by an organization external to the client. This includes parent companies or subsidiaries, alliances, partners, and data brokers. |
| |
| External Schema |
| |
A schema representing the structure of data used by applications. |
| |
| Extract |
| |
A set of data which resides normally on the operational systems which is uploaded into the data warehouse. |
| |
| Extract Date |
| |
The date data was extracted. |
| |
| Extract Frequency |
| |
The latency of data extracts, such as daily versus weekly, monthly, quarterly, etc. The frequency that data extracts are needed in the data warehouse is determined by the shortest frequency requested through an order, or by the frequency required to maintain consistency of the other associated data types in the source data warehouse. |
| |
| Extract Specification |
| |
The standard expectations of a particular source data warehouse for data extracts from the operational database system-of-record. A system-of-record uses an extract specification to retrieve a snapshot of shared data, and formats the data in the way specified for updating the data in the source data warehouse. An extract specification also contains extract frequency rules for use by the Data Access environment. |
| |
|
|
|
|