Data warehousing
Data warehousing is a collection of data that is collected, categorized and stored from various information sources of the organization.
01. Introduction
Data warehousing is a collection of data that is collected, categorized and stored from various information sources of the organization.
Data Warehouse is a database that is used for reporting and data analysis and is the core of a BI system. In other words, the data warehouse is a central data repository of aggregated data collected from different systems and resources of the organization.
A data warehouse is an abnormal relational database that aggregates current and past data into a single location, and its primary purpose is to cover the reporting and analytical needs of an organization.
From the mid-1980s, the need for data warehousing arose, along with information systems (OLTP) and analytical systems (OLAP, DW / BI).
02. Benefits
Preparation of reports
One of the most important benefits of such systems is reporting. In the data warehouse, you can accurately perform the types of queries that require input and output operations
Data models
The second advantage of the data warehouse is the use of data models or a series of server technologies that speed up reporting operations as well as queries.
03. Refined data warehouse
Refined data warehouse is a category of transaction processing systems that allows a series of reports to be generated continuously. In such a data warehouse, there will be no need for fixed transaction processing systems.
In fact, the data warehouse allows you to purify the data without changing the transaction systems. There are a number of data warehouses that allow you to make corrections to the data warehouse and send the correct feedback to the transaction systems. Sometimes such behaviors make more sense by changing the data.
In order to be based on a series of reporting rules as well as research on different data, data warehousing causes tangible acceleration. In the old days, when companies needed a series of reports based on different data, they had to extract each data separately and sort it out, but despite the data warehouse, such options are no longer available.
04. FAQ
- Enterprise Data Warehouse (EDW) An enterprise data warehouse (EDW) is a centralized warehouse that provides decision support services across the enterprise. …
- Operational Data Store (ODS) …
- Data Mart.
05. Partners
