Data Warehousing

Definition of 'Data Warehousing'


The electronic storage of a large amount of information by a business. Warehoused data must be stored in a manner that is secure, reliable, easy to retrieve and easy to manage. The concept of data warehousing originated in 1988 with the work of IBM researchers Barry Devlin and Paul Murphy. The need to warehouse data evolved as computer systems became more complex and handled increasing amounts of data.

Investopedia explains 'Data Warehousing'


Businesses might warehouse data for use in exploration and data mining, looking for patterns of information that will help them improve their businesses. A good data warehousing system can also make it easier for different departments within a company to access each other's data. For example, a data warehouse might allow a company's CEO to easily exame the sales team's data and help him to make decisions about how to improve sales or streamline the department. Effective data storage and management are also what make things like making travel reservations and using automated teller machines possible.

A key book on data warehousing is W. H. Inmon's "Building the Data Warehouse", which was first published in 1990 and has been reprinted several times since.


Filed Under:

comments powered by Disqus
Hot Definitions
  1. Federal Reserve Note

    The most accurate term used to describe the paper currency (dollar bills) circulated in the United States. These Federal Reserve Notes are printed by the U.S. Treasury at the instruction of the Federal Reserve member banks, who also act as the clearinghouse for local banks that need to increase or reduce their supply of cash on hand.
  2. Benchmark Bond

    A bond that provides a standard against which the performance of other bonds can be measured. Government bonds are almost always used as benchmark bonds. Also referred to as "benchmark issue" or "bellwether issue".
  3. Market Capitalization

    The total dollar market value of all of a company's outstanding shares. Market capitalization is calculated by multiplying a company's shares outstanding by the current market price of one share. The investment community uses this figure to determine a company's size, as opposed to sales or total asset figures.
  4. Oil Reserves

    An estimate of the amount of crude oil located in a particular economic region. Oil reserves must have the potential of being extracted under current technological constraints. For example, if oil pools are located at unattainable depths, they would not be considered part of the nation's reserves.
  5. Joint Venture - JV

    A business arrangement in which two or more parties agree to pool their resources for the purpose of accomplishing a specific task. This task can be a new project or any other business activity. In a joint venture (JV), each of the participants is responsible for profits, losses and costs associated with it.
  6. Aggregate Risk

    The exposure of a bank, financial institution, or any type of major investor to foreign exchange contracts - both spot and forward - from a single counterparty or client. Aggregate risk in forex may also be defined as the total exposure of an entity to changes or fluctuations in currency rates.
Trading Center