Home > BI Solutions > Data Warehouse Glossary About Aexis Contact Us Careers
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
 
 
 
Activity
 
A set of tasks related either by topic, dependencies, data, common skills, or deliverables. The next level of organization below a phase.
 
 
Access Path
 
The path chosen by a database management system to retrieve the requested data.
 
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.
 
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.
 
Attribute
 
Schedule of depreciation rates allowed for tax purposes.
 
Aggregate Data
 
Data that is the result of applying a process to combine data elements. Data that is taken collectively or in summary form.
 
Alerts
 
A notification from an event that has exceeded a pre-defined threshold.
 
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.
 
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.