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. Big Data

    The growth in the volume of structured and unstructured data, ...
Related Articles
  1. Professionals

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

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

    Sam Walton

    We'll look at ten entrepreneurs who not only succeeded, but built vast business empires.
  4. Active Trading Fundamentals

    How Big Data Has Changed Finance

    The vast proliferation of data and increasing technological complexities continues to transform the way industries operate and compete.
  5. Professionals

    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.
  6. Economics

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

    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 ...
  8. Financial Advisor Technology

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

    Data Analyst: Career Path & Qualifications

    Explore becoming a data analyst, one of the hottest careers in the current economy; learn about the career paths and the qualifications you need to get hired.
  10. Economics

    Introduction To Accounting Information Systems

    An accounting information system is a way of tracking all accounting activity in a business.
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. Return On Invested Capital - ROIC

    A calculation used to assess a company's efficiency at allocating the capital under its control to profitable investments. ...
  2. Law Of Demand

    A microeconomic law that states that, all other factors being equal, as the price of a good or service increases, consumer ...
  3. Cost Of Debt

    The effective rate that a company pays on its current debt. This can be measured in either before- or after-tax returns; ...
  4. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  5. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  6. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
Trading Center