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. Authorization Only

    A type of sale transaction that creates a pending transaction ...
  6. Transaction Identifier

    A unique identifier assigned by a business to each transaction ...
RELATED FAQS
  1. 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 >>
  2. 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 >>
  3. 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 >>
  4. How difficult is it to understand business analytics?

    In the abstract, business analytics is the study of financial, economic, consumer and production data through statistical ... Read Full Answer >>
  5. At what levels are core competencies required for businesses operating in the primary ...

    Core competencies help businesses understand their best abilities to perform in the market. Primary sector businesses mine ... Read Full Answer >>
  6. What are the variables in variable costs?

    Variable cost is an economic term that refers to an expense a company is facing that varies based on factors that are inconsistent ... Read Full Answer >>
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. Economics

    What is a Management Buyout?

    A management buyout, or MBO, is a transaction where a company's management team purchases the assets and operations of the business they manage.
  7. Economics

    Explaining Cash On Delivery

    Cash on delivery, also referred to as COD, is a method of shipping goods to buyers who do not have credit terms with the seller.
  8. Fundamental Analysis

    Understanding the Simple Random Sample

    A simple random sample is a subset of a statistical population in which each member of the subset has an equal probability of being chosen.
  9. Economics

    International Financial Reporting Standards (IFRS)

    International Financial Reporting Standards are accounting rules and guidelines governing the reporting of different types of accounting transactions.
  10. Economics

    Understanding Economic Order Quantity

    Economic order quantity is an inventory-related equation that determines the optimum order quantity that a company should hold in its inventory.

You May Also Like

Hot Definitions
  1. Fisher Effect

    An economic theory proposed by economist Irving Fisher that describes the relationship between inflation and both real and ...
  2. Fiduciary

    1. A person legally appointed and authorized to hold assets in trust for another person. The fiduciary manages the assets ...
  3. Expected Return

    The amount one would anticipate receiving on an investment that has various known or expected rates of return. For example, ...
  4. Carrying Value

    An accounting measure of value, where the value of an asset or a company is based on the figures in the company's balance ...
  5. Capital Account

    A national account that shows the net change in asset ownership for a nation. The capital account is the net result of public ...
  6. Brand Equity

    The value premium that a company realizes from a product with a recognizable name as compared to its generic equivalent. ...
Trading Center