What do you know about Data Warehouse (DW or DWH) and Enterprise Data Warehouse (EDW)?

Data Warehouse is the centralized data repository which is being used to store the data from the different sources. Data Warehouse is used to store the data for the current and history data for the higher management to represent the reports and data analysis. We can create the annual and quarterly comparison of the progress and profit.

Operational systems like Marketing, Sales, ERP, SAP, Finance and OLTP is used to represent the exact data and figure to show the upper management. Data may have to pass through the operational data storage to store into the data warehouse for reporting and data analysis. The Extract, Transferring and Loading (ETL) is used to store the data in the staging and then it goes to the data warehousing. Then we can create the Cubes based on the analysis, OLAP and Reporting for showing the customer numbers, sales of the product, marketing strategy and planning of the new strategy and process. The layer is transferring the data from the staging to operational data stores (ODS) in the database.

In simple way we can get the information in the form of data or records from the different types of the sources like Marketing, Sales, ERP, Production, CRM and OLTP and then we clean and modify the data in our database and then we transfer into the OLAP, Reporting and Data Mining and Data Analysis. The data warehouse deals with the integrated data, which changes from the one database to another. This data warehouse is always arranged into the hierarchical groups with the dimensional and facts tables. This combined form of arrangement of the dimensional and fact data in the database is called the star schema.

Data Warehouse is defined as the storage of the data accessible by the manager and other business experts or professional after cleaning, transferring, data mining and data analysis. Data Warehouse can also be divided into small portions called the marts to store the data at the more integrated level. Marts store the subset of the database in the data warehouse.

We have a great tool for data warehousing is called Extract, Transfer and load it into the data base. This is also known as ETL process to get the data from the different sources and then got cleaned and transformed and modified into well representation of the data for analyzing for the business level and easy to understand for customers and partners.

As per the Architect and Developer point of view we should understand the concept of the Data Warehouse and On-Line Transaction Processing. Otherwise we will not be able to distinguish between the Online Transaction and Data Warehousing. In the next article we will discuss the OLTP system in the database world. I will try to understand about the concept of the OLTP system and the OLAP system which will be helpful to create the crystal reports to understand the graph or the cubes related the data and records.

We should know “How it works for us?” Data Warehouse is really good tool to store the current data and historical data for as long as we want. They we can clean the raw data and transfer into different form and we can also store it into the data warehouse and marts. We can create then reports and analysis based on the data we received from the OLTP system and then we can send it to OLAP system.

Please share more information on this data warehousing topic to understand about the difference between OLTP and OLAP system for the database. I would like to get more information on this topic.