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. XW

    A symbol used to signify that a security is trading ex-warrant. XW is one of many alphabetic qualifiers that act as a shorthand to tell investors key information about a specific security in a stock quote. These qualifiers should not be confused with ticker symbols, some of which, like qualifiers, are just one or two letters.
  2. Quanto Swap

    A swap with varying combinations of interest rate, currency and equity swap features, where payments are based on the movement of two different countries' interest rates. This is also referred to as a differential or "diff" swap.
  3. Genuine Progress Indicator - GPI

    A metric used to measure the economic growth of a country. It is often considered as a replacement to the more well known gross domestic product (GDP) economic indicator. The GPI indicator takes everything the GDP uses into account, but also adds other figures that represent the cost of the negative effects related to economic activity (such as the cost of crime, cost of ozone depletion and cost of resource depletion, among others).
  4. Accelerated Share Repurchase - ASR

    A specific method by which corporations can repurchase outstanding shares of their stock. The accelerated share repurchase (ASR) is usually accomplished by the corporation purchasing shares of its stock from an investment bank. The investment bank borrows the shares from clients or share lenders and sells them to the company.
  5. Microeconomic Pricing Model

    A model of the way prices are set within a market for a given good. According to this model, prices are set based on the balance of supply and demand in the market. In general, profit incentives are said to resemble an "invisible hand" that guides competing participants to an equilibrium price. The demand curve in this model is determined by consumers attempting to maximize their utility, given their budget.
  6. Centralized Market

    A financial market structure that consists of having all orders routed to one central exchange with no other competing market. The quoted prices of the various securities listed on the exchange represent the only price that is available to investors seeking to buy or sell the specific asset.
Trading Center