Terminologies keep changing, particularly within this industry. Business Intelligence may be what the modern term is, but in the past we have gone through a number of terms including Data Warehousing, which has beendefined:
The Data Warehouse has been defined by Bill Inmon as:
A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process .
A copy of transaction data specifically structured for query and analysis.
It was also defined by Ralf Kimball as:
An orderly and accessible repository of known facts…that is used as the basis for making better management decisions.
Defining a class of to information-centric applications that are business focussed and provide analytical information to senior managers. Applications are intended to be structured in order to represent the way in which an organisation functions.
I am interested in how you would define it today.
References:
Bill Inmon, Building the Data Warehouse – Originally published in 1990 by John Wiley & Sons Inc.
Ralph Kimball, The Data Warehouse Toolkit – 1996 John Wiley & Sons Inc.
Peter B.Giblett.
A few years ago (2001) I defined Business Intelligence as
Price Waterhouse, Data Warehousing (an overview of the benefits and the system management methodology – 1997.
There can be little disagreement that a Data Warehouse acts as the foundation for Business Intelligence, but do any of the definitions require radical change?
The Data Warehouse takes a copy of transactional data and structures it specifically to allow efficient query and analysis to take place throughout the warehouse in a uniform manner. There are many ways, of course, to copy a transactional database.
And by Price Waterhouse as:
It is Subject Oriented because it is classified and organised around subjects meaningful to an organisation. It has collected all data available about a subject from all the operational systems. E.g. all sales, not just those captured via the e-business channel. The data from various systems is integratedinto the Data Warehouse. It holds time-variant information and all facts/measurements will be time stamped either through their source transaction, or upon entry to the warehouse. Data can be bothhistorical (e.g. 6 to 12 years old) or nearly current (e.g. yesterday, last week, last month). Data is non-volatile because it does not change in response to current operational activities and is based on a controlled data collection process. The data has not changed as soon as the report is created.
Terminologies keep changing, particularly within this industry. Business Intelligence may be what the modern term is, but in the past we have gone through a number of terms including Data Warehousing, which has been defined:
The Data Warehouse has been defined by Bill Inmon as:
A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process .
A copy of transaction data specifically structured for query and analysis .
It was also defined by Ralf Kimball as:
An orderly and accessible repository of known facts…that is used as the basis for making better management decisions .
Defining a class of to information-centric applications that are business focussed and provide analytical information to senior managers. Applications are intended to be structured in order to represent the way in which an organisation functions.
I am interested in how you would define it today.
Bill Inmon, Building the Data Warehouse – Originally published in 1990 by John Wiley & Sons Inc.
Ralph Kimball, The Data Warehouse Toolkit – 1996 John Wiley & Sons Inc.
Peter B.Giblett.
A few years ago (2001) I defined Business Intelligence as
Price Waterhouse, Data Warehousing (an overview of the benefits and the system management methodology – 1997.
There can be little disagreement that a Data Warehouse acts as the foundation for Business Intelligence, but do any of the definitions require radical change?
The Data Warehouse takes a copy of transactional data and structures it specifically to allow efficient query and analysis to take place throughout the warehouse in a uniform manner. There are many ways, of course, to copy a transactional database.
And by Price Waterhouse as:
It is Subject Oriented because it is classified and organised around subjects meaningful to an organisation. It has collected all data available about a subject from all the operational systems. E.g. all sales, not just those captured via the e-business channel. The data from various systems is integrated into the Data Warehouse. It holds time-variant information and all facts/measurements will be time stamped either through their source transaction, or upon entry to the warehouse. Data can be both historical (e.g. 6 to 12 years old) or nearly current (e.g. yesterday, last week, last month). Data is non-volatile because it does not change in response to current operational activities and is based on a controlled data collection process. The data has not changed as soon as the report is created.