Definition
In computing, a data warehouse, also known as an enterprise data warehouse, is a system used for reporting and data analysis, and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.
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.
Explaining ‘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.
Further Reading
- Web-based data warehousing: Fundamentals, challenges, and solutions – www.tandfonline.com [PDF]
- Towards a framework for evaluating investments in data warehousing – onlinelibrary.wiley.com [PDF]
- A modelling environment based on data warehousing to manage and to optimize the running of international company – www.sciencedirect.com [PDF]
- Outsourcing opportunities for data warehousing business usage – www.emerald.com [PDF]
- The dimensional fact model: A conceptual model for data warehouses – www.worldscientific.com [PDF]
- Exploring the value of using data: a case study of continuous improvement through data warehousing – www.tandfonline.com [PDF]
- Academic data warehouse design using a hybrid methodology – www.doiserbia.nb.rs [PDF]
- Analysis of business intelligence and its derivative-financial intelligence – ieeexplore.ieee.org [PDF]
