Data Warehousing

AAA

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.



RELATED TERMS
  1. Data Smoothing

    The use of an algorithm to remove noise from a data set, allowing ...
  2. Certified Data Processor - CDP

    An information technology (IT) certification. The certificate ...
  3. Longitudinal Data

    The process of collecting sample observations from a larger population ...
  4. Data Mining

    A process used by companies to turn raw data into useful information. ...
  5. Occupational Safety And Health ...

    Law passed in 1970 to encourage safer workplace conditions in ...
  6. Administrative Order On Consent ...

    An agreement between an individual or business and a regulatory ...
Related Articles
  1. Charts & Patterns

    Advantages Of Data-Based Intraday Charts

    We take a look at these chart intervals and how we can use them to our advantage.
  2. Active Trading

    Data Mining For Investors

    Being an informed investor is extremely important, but where and how do you get the data for your research?
  3. Active Trading

    The Importance Of Segment Data

    Key financials often fail to provide insight into large cap companies.
  4. Personal Finance

    Tips For Keeping Your Financial Data Safe Online

    Find out how to protect your personal information from phishers, scammers and thieves.
  5. Retirement

    Sources Of Evaluative Fund Data

    Eight key items determine the investment quality of a mutual fund. Learn where to find them.
  6. Investing

    What's a Distribution Channel?

    A distribution channel is a chain of businesses through which a manufacturer sends his products to get them to a final buyer. It may involve wholesalers, distributors, agents and retailers. Companies ...
  7. Investing

    What's a Transfer Price?

    A transfer price is what one unit of a business charges another unit of the same business for a good or service. The transfer price is usually close to the prevailing market rate when different ...
  8. Investing

    What does Large Cap mean?

    The “cap” in large cap refers to a company’s capitalization as determined by the total market value of its publicly traded shares. Large cap is short for “large market capitalization.”
  9. Investing

    The Production Possibility Frontier (PPF)

    A production possibility frontier (PPF) is a range of answers to the question, “What is our maximum production capacity?”
  10. Investing

    What's a Debit Note?

    A debit note is a document used by a seller to inform a purchaser of a dollar amount owed. As the name indicates, it is a note from the seller that a debit has been made to the purchaser’s account. ...

You May Also Like

Hot Definitions
  1. Risk Averse

    A description of an investor who, when faced with two investments with a similar expected return (but different risks), will ...
  2. Fixed-Charge Coverage Ratio

    A ratio that indicates a firm's ability to satisfy fixed financing expenses, such as interest and leases. It is calculated ...
  3. Efficiency Ratio

    Ratios that are typically used to analyze how well a company uses its assets and liabilities internally. Efficiency Ratios ...
  4. Fixed Cost

    A cost that does not change with an increase or decrease in the amount of goods or services produced. Fixed costs are expenses ...
  5. Subsidy

    A benefit given by the government to groups or individuals usually in the form of a cash payment or tax reduction. The subsidy ...
  6. Sunk Cost

    A cost that has already been incurred and thus cannot be recovered. A sunk cost differs from other, future costs that a business ...
Trading Center