SettingsData warehousing
Aggregate (Data Warehouse)
Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data.
Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data.
Aggregate (data warehouse)
Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data.
Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data.
Anchor Modeling
Anchor Modeling is an agile database modeling technique suited for information that change over time both in structure and content.
Anchor Modeling is an agile database modeling technique suited for information that change over time both in structure and content.
Bill Inmon
William Harvey Bill Inmon (born 1945) is an American computer scientist, recognized by many as the father of the data warehouse.
William Harvey Bill Inmon (born 1945) is an American computer scientist, recognized by many as the father of the data warehouse.
Bitemporal Modeling
Bitemporal Modeling is an information modeling technique designed to handle historical data along two different timelines.
Bitemporal Modeling is an information modeling technique designed to handle historical data along two different timelines.
Business analytics
Business analytics refers to the skills, technologies, applications and practices for continuous iterative exploration and investigation of past business performance to gain insight and drive bu...
Business analytics refers to the skills, technologies, applications and practices for continuous iterative exploration and investigation of past business performance to gain insight and drive bu...
Dashboard (business)
In management information systems, a dashboard is "An easy to read, often single page, real-time user interface, showing a graphical presentation of the current status and historical trends of...
In management information systems, a dashboard is "An easy to read, often single page, real-time user interface, showing a graphical presentation of the current status and historical trends of...
Data extraction
Data extraction is the act or process of retrieving (binary) data out of (usually unstructured or poorly structured) data sources for further data processing or data storage (data migration).
Data extraction is the act or process of retrieving (binary) data out of (usually unstructured or poorly structured) data sources for further data processing or data storage (data migration).
Data mart
A data mart is the access layer of the data warehouse environment that is used to get data out to the users.
A data mart is the access layer of the data warehouse environment that is used to get data out to the users.
Data Vault Modeling
Data Vault Modeling is a database modeling method that is designed to provide historical storage of data coming in from multiple operational systems.
Data Vault Modeling is a database modeling method that is designed to provide historical storage of data coming in from multiple operational systems.
Data warehouse appliance
In computing, a data warehouse appliance consists of an integrated set of servers, storage, operating system(s), DBMS and software specifically pre-installed and pre-optimized for data warehousi...
In computing, a data warehouse appliance consists of an integrated set of servers, storage, operating system(s), DBMS and software specifically pre-installed and pre-optimized for data warehousi...
Degenerate dimension
According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key in the fact table that does not have its own dimension table, because all the interesting attributes ha...
According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key in the fact table that does not have its own dimension table, because all the interesting attributes ha...
Dimension (data warehouse)
In a data warehouse, a dimension is a data element that categorizes each item.
In a data warehouse, a dimension is a data element that categorizes each item.
Dimension table
In data warehousing, a dimension table is one of the set of companion tables to a fact table.
In data warehousing, a dimension table is one of the set of companion tables to a fact table.
Dimensional Fact Model
The Dimensional Fact Model (DFM) is an ad-hoc formalism specifically devised to support the conceptual modeling phase in a DW project.
The Dimensional Fact Model (DFM) is an ad-hoc formalism specifically devised to support the conceptual modeling phase in a DW project.
Dimensional modeling
Dimensional modeling (DM) is the name of a set of techniques and concepts used in data warehouse design.
Dimensional modeling (DM) is the name of a set of techniques and concepts used in data warehouse design.
DIRKS
DIRKS is an acronym for Design and Implementation of Recordkeeping System.
DIRKS is an acronym for Design and Implementation of Recordkeeping System.
Document warehouse
In the field of data warehouses, a document warehouse is a software framework for analysis, sharing, and reuse of unstructured data, such as textual or multimedia documents.
In the field of data warehouses, a document warehouse is a software framework for analysis, sharing, and reuse of unstructured data, such as textual or multimedia documents.
Early-arriving fact
In the Data Warehouse practice of ETL, an early fact or early-arriving fact denotes the detection of a dimensional natural key during fact table source loading, prior to the assignment of...
In the Data Warehouse practice of ETL, an early fact or early-arriving fact denotes the detection of a dimensional natural key during fact table source loading, prior to the assignment of...
Enterprise bus matrix
The Enterprise Bus Matrix is a Data Warehouse planning tool and model created by Ralph Kimball, and is part of the Data Warehouse Bus Architecture.
The Enterprise Bus Matrix is a Data Warehouse planning tool and model created by Ralph Kimball, and is part of the Data Warehouse Bus Architecture.
Expense and Cost Recovery System (ECRS)
An expense and cost recovery system (ECRS) is a specialized subset of “Extract – Transform – Load” (ETL) functioning as a powerful and flexible set of applications, including programs, scripts a...
An expense and cost recovery system (ECRS) is a specialized subset of “Extract – Transform – Load” (ETL) functioning as a powerful and flexible set of applications, including programs, scripts a...
Fact (data warehouse)
Facts as reported by the reporting entity are said to be at raw level.
Facts as reported by the reporting entity are said to be at raw level.
Fact table
In data warehousing, a fact table consists of the measurements, metrics or facts of a business process.
In data warehousing, a fact table consists of the measurements, metrics or facts of a business process.
Integration warehouse
An Integration warehouse is a data warehouse specifically geared to the purpose of integrating information from various sources or systems.
An Integration warehouse is a data warehouse specifically geared to the purpose of integrating information from various sources or systems.
Log trigger
The Log Trigger works writing the changes (INSERT, UPDATE and DELETE operations) on the TableX in another, "parallel" table, named here as LogTable and defined as following: CREATE TABLE LogTab...
The Log Trigger works writing the changes (INSERT, UPDATE and DELETE operations) on the TableX in another, "parallel" table, named here as LogTable and defined as following: CREATE TABLE LogTab...
Master data management
In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the master data (i.e.
In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the master data (i.e.
Measure (data warehouse)
In a data warehouse, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using precomputed aggregates.
In a data warehouse, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using precomputed aggregates.
Noetix Corp.
Noetix is a privately held business intelligence software company founded in 1994 that assists customers in simplifying access to data from their enterprise applications.
Noetix is a privately held business intelligence software company founded in 1994 that assists customers in simplifying access to data from their enterprise applications.
OLAP cube
An OLAP cube is a set of data, organized in a way that facilitates non-predetermined queries for aggregated information, or in other words, online analytical processing.
An OLAP cube is a set of data, organized in a way that facilitates non-predetermined queries for aggregated information, or in other words, online analytical processing.
Operational data store
An operational data store (or "ODS") is a database designed to integrate data from multiple sources for additional operations on the data.
An operational data store (or "ODS") is a database designed to integrate data from multiple sources for additional operations on the data.
Operational database
In Data Warehousing, the Operational Database is one which is accessed by an Operational System to carry out regular operations of an organization.
In Data Warehousing, the Operational Database is one which is accessed by an Operational System to carry out regular operations of an organization.
Operational system
An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization.
An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization.
Ralph Kimball
Ralph Kimball is an author on the subject of data warehousing and business intelligence.
Ralph Kimball is an author on the subject of data warehousing and business intelligence.
Slowly changing dimension
Dimension is a term in data management and data warehousing that refers to logical groupings of data such as geographical location, customer information, or product information.
Dimension is a term in data management and data warehousing that refers to logical groupings of data such as geographical location, customer information, or product information.
Snowflake schema
A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake in shape.
A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake in shape.
Spreadmart
A spreadmart is a concept describing the tendency that spreadsheets have to "run amok" in organizations.
A spreadmart is a concept describing the tendency that spreadsheets have to "run amok" in organizations.
Staging (data)
In Data warehouse terms, a data staging area is an intermediate storage area between the sources of information and the data warehouse or Data mart.
In Data warehouse terms, a data staging area is an intermediate storage area between the sources of information and the data warehouse or Data mart.
Star schema
In computing, the star schema (also called star-join schema, data cube, or multi-dimensional schema) is the simplest style of data warehouse schema.
In computing, the star schema (also called star-join schema, data cube, or multi-dimensional schema) is the simplest style of data warehouse schema.
The Kimball Lifecycle
The Kimball Lifecycle is a methodology for developing data warehouses, and has been developed over many years by Ralph Kimball and a variety of colleagues.
The Kimball Lifecycle is a methodology for developing data warehouses, and has been developed over many years by Ralph Kimball and a variety of colleagues.
Time variance
Time variance is the ability to remember historic perspectives.
Time variance is the ability to remember historic perspectives.