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. Cash and Carry Transaction

    A type of transaction in the futures market in which the cash or spot price of a commodity is below the futures contract price. Cash and carry transactions are considered arbitrage transactions.
  2. Amplitude

    The difference in price from the midpoint of a trough to the midpoint of a peak of a security. Amplitude is positive when calculating a bullish retracement (when calculating from trough to peak) and negative when calculating a bearish retracement (when calculating from peak to trough).
  3. Ascending Triangle

    A bullish chart pattern used in technical analysis that is easily recognizable by the distinct shape created by two trendlines. In an ascending triangle, one trendline is drawn horizontally at a level that has historically prevented the price from heading higher, while the second trendline connects a series of increasing troughs.
  4. National Best Bid and Offer - NBBO

    A term applying to the SEC requirement that brokers must guarantee customers the best available ask price when they buy securities and the best available bid price when they sell securities.
  5. Maintenance Margin

    The minimum amount of equity that must be maintained in a margin account. In the context of the NYSE and FINRA, after an investor has bought securities on margin, the minimum required level of margin is 25% of the total market value of the securities in the margin account.
  6. Leased Bank Guarantee

    A bank guarantee that is leased to a third party for a specific fee. The issuing bank will conduct due diligence on the creditworthiness of the customer looking to secure a bank guarantee, then lease a guarantee to that customer for a set amount of money and over a set period of time, typically less than two years.
Trading Center