Data Warehousing

What is 'Data Warehousing'

Data warehousing is 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.



RELATED TERMS
  1. Warehousing

    1. A procedure whereby a company gradually builds up a holding ...
  2. Data Mining

    A process used by companies to turn raw data into useful information. ...
  3. Distribution Management

    Overseeing the movement of goods from supplier or manufacturer ...
  4. Warehouser's Liability Form

    A document that describes the obligations of a storage facility ...
  5. Export Trading Company - ETC

    An independent company that provides support services for firms ...
  6. Warehouse Bond

    A type of financial protection that assures an individual or ...
Related Articles
  1. Managing Wealth

    Data Integrity Analyst: Job Description & Average Salary

    Learn about the average salary of a data integrity analyst and the required skills, education and previous experience needed to fill this role.
  2. Managing Wealth

    Data Analyst: Job Description & Average Salary

    Learn about a data analyst career and how much money you can expect to make. Understand the skills and education needed to become a data analyst.
  3. Trading

    How Big Data Has Changed Finance

    The vast proliferation of data and increasing technological complexities continues to transform the way industries operate and compete.
  4. Managing Wealth

    Financial Data Analyst: Job Description & Average Salary

    Learn about the average salary for a financial data analyst position and the skills, education and experience employers require of candidates.
  5. Markets

    Explaining the Value Chain

    A model of how businesses receive raw materials as input, add value to the raw materials, and sell finished products to customers.
  6. Financial Advisor

    Predictive Analytics Drives Return for Investors

    A new industry of predictive analysis has developed to make sense of big data and give investors real-time buy and sell recommendations based on the patterns forming in the data long before traditional ...
  7. Insights

    The Big Disconnect With Big Data and Advisors

    Financial planning firms that undertake big data projects need to clearly define their goals so they can glean more insight from the data.
  8. Financial Advisor

    Financial Advisors' Next Big Tech Tool: Big Data

    Here's how big data is playing a crucial role in the work life of financial advisors and some strategies on how to take advantage of the technology.
  9. Investing

    Introduction To Accounting Information Systems

    An accounting information system is a way of tracking all accounting activity in a business.
  10. Investing

    8 Best Cloud Storage Solutions for Small Business

    An unbiased list of the top cloud storage solutions for small businesses.
RELATED FAQS
  1. What types of data are mined for business intelligence?

    Learn about data mining and how businesses use data analysis in business intelligence to improve their operational efficiency ... Read Answer >>
  2. What is the most important type of data used in business analytics?

    Consider what makes data useful in business analytics, and why companies should search for the types of data that provide ... Read Answer >>
  3. What does the book-to-bill ratio in the electronics sector refer to?

    Understand the purpose of operations management and learn specific ways that businesses use data collection and analysis ... Read Answer >>
  4. When should I use seasonally adjusted data from the consumer price index (CPI)?

    Learn what seasonally adjusted data is, how it is determined and when it should be used to evaluate the information gathered ... Read Answer >>
  5. How do I import QuickBooks Pro Account trial balances for the first time?

    Import your data for the first time from Intuit's QuickBooks Pro to an Excel spreadsheet as easily as one, two, three with ... Read Answer >>
  6. How can a company control its holding costs?

    Learn about the specific costs that go into a company's overall inventory holding costs, and understand how a company can ... Read Answer >>
Hot Definitions
  1. Glass-Steagall Act

    An act the U.S. Congress passed in 1933 as the Banking Act, which prohibited commercial banks from participating in the investment ...
  2. Quantitative Trading

    Trading strategies based on quantitative analysis which rely on mathematical computations and number crunching to identify ...
  3. Bond Ladder

    A portfolio of fixed-income securities in which each security has a significantly different maturity date. The purpose of ...
  4. Duration

    A measure of the sensitivity of the price (the value of principal) of a fixed-income investment to a change in interest rates. ...
  5. Dove

    An economic policy advisor who promotes monetary policies that involve the maintenance of low interest rates, believing that ...
  6. Cyclical Stock

    An equity security whose price is affected by ups and downs in the overall economy. Cyclical stocks typically relate to companies ...
Trading Center