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. 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.
  4. 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.
  5. 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.
  6. 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 ...
  7. 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.
  8. 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.
  9. Economics

    Introduction To Accounting Information Systems

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

    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. Physical Capital

    Physical capital is one of the three main factors of production in economic theory. It consists of manmade goods that assist ...
  2. Labor Market

    The labor market refers to the supply and demand for labor, in which employees provide the supply and employers the demand. ...
  3. Demand Curve

    The demand curve is a graphical representation of the relationship between the price of a good or service and the quantity ...
  4. Goldilocks Economy

    An economy that is not so hot that it causes inflation, and not so cold that it causes a recession. This term is used to ...
  5. White Squire

    Very similar to a "white knight", but instead of purchasing a majority interest, the squire purchases a lesser interest in ...
Trading Center