Enabling superior business decisions
Glossary of Terms
"...a collection of powerful analysis techniques for making sense out of very large datasets." - R. Kimball
The process of changing the format of production data to make it useable for heuristic business reporting. It also serves as a road map for the integration of data sources into the data warehouse.
"The data staging area is the data warehouse workbench. It is the place where raw data is brought in, cleaned, combined, archived, and eventually exported to one or more data marts." -
Performed when data is extracted from the operational systems, and may include integrating dissimilar data types, cleansing, summarising and processing calculations.
An architected solution for making data available for business intelligence systems. This is data from a production (legacy) systems and external data that now resides in a different environment (often a different database of a separate machine), to be used strictly for business analysis and querying, allowing the production machines to continue their work which is traditionally transaction processing.
The process of navigating from a top level view of overall sales down through the sales territories, down to the individual sales person level. This is a more intuitive way to obtain information at the detail level.
Business intelligence tools that utilise data to form the systems that support the business decision making process of the organisation.
These are business intelligence tools that are aimed at less sophisticated users, who want to look at complex information without the need to have complete manipulative control of the information presented.
Select and copy data from a source database or file
Process to check data for adherence to standards, consistency, valid domain; then either clean or reject invalid data
Add or replace data in a designed database(s)
Data describing other data, for example the column headers in a table. Sometimes referred to as 'data about data'.
Combine two or more data sets; values or structures. See Abstract
Software designed to establish a permanent relationship (including filtering and transformation) between source systems and a logical model. The logical model is then available as a virtual database to end-user query tools or a data migration product
Describes the systems used not for application delivery, but for analysing the business, e.g., sales forecasting, market trends analysis, etc. These systems are also move conducive to heuristic reporting and often involves multi-dimensional data analysis capabilities.
Describes the activities and systems associated with a company's day-to-day operational processing and data (order entry, invoicing, general ledger, etc.).
A list or database or information that controls a process, for example check boxes or values. Contrast to "script" or "program"
A data pump extracts data from several mainframe and client server platforms, performs some filtering and transformation, and distributes and loads to another database(s). Usually the term pump is used rather than "replicator" to connote its applicability in a cross-platform environment
An application that sends native database commands, usually SQL, to extract information from a database server. Queries can either browse the contents of a single table or using the database's SQL engine perform join conditioned queries, that produce result sets involving data from multiple tables that meet certain selection criterion.
Extract data from several platforms, perform some filtering and transformation, and distribute and load to another database or databases. Usually the term replication implies limited or no transformation, and moves within a homogeneous environment. See Pump
Reverse engineering derives a consistent set of metadata from several potential source system's metadata
A method of database design used by relational databases to model multidimensional data. A Star Schema usually contains two types of tables: fact and dimension. The fact table contains the measurement data, for example, the salary paid, vacation earned, etc. The dimensions hold descriptive data, for example, name, address, etc.
Extract data from source, interface with destination environment, load data to destination
A database(s) containing an architected collection of subject-oriented data originating from both the companies' transactions systems and external data