| 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 |
|
| |
| Access Path |
| |
The path chosen by a database management system to retrieve the requested data. |
| |
| Active Data Warehouse |
| |
Active Data Warehouse is repository of any form of captured transactional data so that they can be used for the purpose of finding trends and patterns to be used for future decision making |
| |
| Active Metadata Warehouse |
| |
Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse. This metadata ware-house is automatically updated when new data enter the data resource. |
| |
| Activity |
| |
A set of tasks related either by topic, dependencies, data, common skills, or deliverables. The next level of organization below a phase. |
| |
| Ad-Hoc Query |
| |
Any query that cannot be determined prior to the moment the query is issued. A query that consists of dynamically constructed SQL, which is usually constructed by desktop-resident query tools. |
| |
| Ad-Hoc Query Tool |
| |
An end-user tool that accepts an English-like or point-and-click request for data and constructs an ad-hoc query to retrieve the desired result. |
| |
| Administrative Data |
| |
In a data warehouse, the data that helps a warehouse administrator manage the warehouse. Examples of administrative data are user profiles and order history data. |
| |
| Aggregate Data |
| |
Data that is the result of applying a process to combine data elements. Data that is taken collectively or in summary form. |
| |
| Aggregation |
| |
Used in the broad sense to mean aggregating data horizontally, vertically, and chronologically. |
| |
| Alerts |
| |
A notification from an event that has exceeded a pre-defined threshold. |
| |
| Application Gap |
| |
A recorded variance between some aspect of a business requirement and the capability or features of the application system that are necessary to satisfy the requirement. |
| |
| Application System |
| |
An automated collection of business functions, entities, modules, technology platforms, and documentation that performs a specified set of business functions. |
|
| Approach |
| |
A particular way of putting a method or task to use, including risk factors, tips from experience, recommendations, and additional advice. |
| |
| Architecture |
| |
A definition and preliminary design which describes the components of a solution and their interactions. An architecture is the blueprint by which implementers construct a solution which meets the users’ needs |
| |
| Atomic Data |
| |
Data elements that represent the lowest level of detail. For example, in a daily sales report, the individual items sold would be atomic data, while rollups such as invoice and summary totals from invoices are aggregate data. |
| |
| Attribute |
| |
Schedule of depreciation rates allowed for tax purposes. |
| |
| Authorization Request |
| |
A request initiated by a consumer to access data for which the consumer does not presently have access privileges. |
| |
| Authorization Rules |
| |
Criteria used to determine whether or not an individual, group, or application may access reference data or a process. |
| |
| Automatic Data Partitioning |
| |
The process of automatically breaking down large chunks of data and metadata based on a client’s request for data at a specific data site. |
| |
| Automatic Data Replication |
| |
The process of wherein created data and metadata automatically replicates, creating data and metadata replicates based on a client’s request for data at a specific data site. |
| |
| Availability |
| |
Criteria used to determine whether or not an individual, group, or application may access reference data or a process. |
| |
| |
| |
|
|
|
|