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.

BREAKING DOWN '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.

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

    The degree to which an asset or security can be quickly bought ...
  6. Operating Cost

    Expenses associated with the maintenance and administration of ...
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 Basics

    Should You Get A Six Sigma Black Belt? Average Salary: 98K

    Interested in the Six Sigma Black Belt but unsure whether you need one? Here's a guide to it and how it differs from other belts.
  7. Investing Basics

    What is Equity?

    Think of equity as ownership in any asset after all debts stemming from that asset are paid.
  8. Economics

    What's a Horizontal Merger?

    A horizontal merger occurs when companies within the same industry merge.
  9. Economics

    Explaining Quality Control

    Businesses use quality control to ensure their products and services meet a certain standard, as well as any industry regulations.
  10. Professionals

    What is Backward Integration?

    What is backward integration, and how can it affect industries?
  1. Do working capital funds expire?

    While working capital funds do not expire, the working capital figure does change over time. This is because it is calculated ... Read Full Answer >>
  2. Does working capital include inventory?

    A company's working capital includes inventory, and increases in inventory make working capital increase. Working capital ... Read Full Answer >>
  3. How can I calculate funds from operation in Excel?

    In general, the terms "work in progress" and "work in process" are used interchangeably to refer to products midway through ... Read Full Answer >>
  4. When does Q4 start and finish?

    Most companies such as Facebook have financial years that end on December 31st. For these companies, the fourth quarter begins ... Read Full Answer >>
  5. When is it useful to look at a company's fixed asset turnover ratio?

    It is useful to look at a company's fixed asset turnover ratio when an outside observer, such as an investor, wants to know ... Read Full Answer >>
  6. What is the difference between perfect and imperfect competition?

    Perfect competition is a microeconomics concept that describes a market structure controlled entirely by market forces. In ... Read Full Answer >>

You May Also Like

Hot Definitions
  1. Bar Chart

    A style of chart used by some technical analysts, on which, as illustrated below, the top of the vertical line indicates ...
  2. Bullish Engulfing Pattern

    A chart pattern that forms when a small black candlestick is followed by a large white candlestick that completely eclipses ...
  3. Cyber Monday

    An expression used in online retailing to describe the Monday following U.S. Thanksgiving weekend. Cyber Monday is generally ...
  4. Take A Bath

    A slang term referring to the situation of an investor who has experienced a large loss from an investment or speculative ...
Trading Center