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. Harvest Strategy

    A strategy in which investment in a particular line of business is reduced or eliminated because the revenue brought in by additional investment would not warrant the expense. A harvest strategy is employed when a line of business is considered to be a cash cow, meaning that the brand is mature and is unlikely to grow if more investment is added.
  2. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will be executed at a specified price (or better) after a given stop price has been reached. Once the stop price is reached, the stop-limit order becomes a limit order to buy (or sell) at the limit price or better.
  3. Pareto Principle

    A principle, named after economist Vilfredo Pareto, that specifies an unequal relationship between inputs and outputs. The principle states that, for many phenomena, 20% of invested input is responsible for 80% of the results obtained. Put another way, 80% of consequences stem from 20% of the causes.
  4. Pareto Principle

    A principle, named after economist Vilfredo Pareto, that specifies an unequal relationship between inputs and outputs. The principle states that, for many phenomena, 20% of invested input is responsible for 80% of the results obtained. Put another way, 80% of consequences stem from 20% of the causes.
  5. Budget Deficit

    A status of financial health in which expenditures exceed revenue. The term "budget deficit" is most commonly used to refer to government spending rather than business or individual spending. When referring to accrued federal government deficits, the term "national debt” is used.
  6. Floating Exchange Rate

    A country's exchange rate regime where its currency is set by the foreign-exchange market through supply and demand for that particular currency relative to other currencies. Thus, floating exchange rates change freely and are determined by trading in the forex market.
Trading Center