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. Treasury Inflation Protected Securities - TIPS

    A treasury security that is indexed to inflation in order to protect investors from the negative effects of inflation. TIPS are considered an extremely low-risk investment since they are backed by the U.S. government and since their par value rises with inflation, as measured by the Consumer Price Index, while their interest rate remains fixed.
  2. Gilt-Edged Switching

    The selling and repurchasing of certain high-grade stocks or bonds to capture profits. Gilt-edged switching involves gilt-edged security, which can be high-grade stock or bond issued by a financially stable company such as the Blue Chip companies or by certain governments.
  3. Master Limited Partnership - MLP

    A type of limited partnership that is publicly traded. There are two types of partners in this type of partnership: The limited partner is the person or group that provides the capital to the MLP and receives periodic income distributions from the MLP's cash flow, whereas the general partner is the party responsible for managing the MLP's affairs and receives compensation that is linked to the performance of the venture.
  4. Class Action

    An action where an individual represents a group in a court claim. The judgment from the suit is for all the members of the group (class).
  5. Retail Sales

    An aggregated measure of the sales of retail goods over a stated time period, typically based on a data sampling that is extrapolated to model an entire country. In the U.S., the retail sales report is a monthly economic indicator compiled and released by the Census Bureau and the Department of Commerce.
  6. Okun's Law

    The relationship between an economy's unemployment rate and its gross national product (GNP). Twentieth-century economist Arthur Okun developed this idea, which states that when unemployment falls by 1%, GNP rises by 3%. However, the law only holds true for the U.S.
Trading Center