BROWSE

Data Warehousing

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.

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]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

Towards a framework for evaluating investments in data warehousingTowards a framework for evaluating investments in data warehousing
onlinelibrary.wiley.com [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

A modelling environment based on data warehousing to manage and to optimize the running of international companyA modelling environment based on data warehousing to manage and to optimize the running of international company
www.sciencedirect.com [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

Outsourcing opportunities for data warehousing business usageOutsourcing opportunities for data warehousing business usage
www.emerald.com [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

The dimensional fact model: A conceptual model for data warehousesThe dimensional fact model: A conceptual model for data warehouses
www.worldscientific.com [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

Exploring the value of using data: a case study of continuous improvement through data warehousingExploring the value of using data: a case study of continuous improvement through data warehousing
www.tandfonline.com [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

Academic data warehouse design using a hybrid methodologyAcademic data warehouse design using a hybrid methodology
www.doiserbia.nb.rs [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …

Analysis of business intelligence and its derivative-financial intelligenceAnalysis of business intelligence and its derivative-financial intelligence
ieeexplore.ieee.org [PDF]
… Views. 6. CrossRef citations to date. Altmetric. Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions … Original Articles. Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions …



Q&A About Data Warehousing


What is data warehousing?

Data warehousing is the electronic storage of a large amount of information by a business.

Why did data warehousing originate?

The concept of data warehousing originated as computer systems became more complex and handled increasing amounts of data.

What makes things like making travel reservations and using automated teller machines possible?

Effective storage and management are what make things like making travel reservations and using automated teller machines possible.

Leave a Reply

Your email address will not be published. Required fields are marked *