Data Warehouse Environment or commonly called the work environment of a Data Warehouse is a set of systems that make up the environment for each process being run by the components on a Data Warehouse to achieve the goal of The Data Warehouse implementations in organizations that implement it. For example help in decision making based on data analysis. In the Data Warehouse Environment, there are four parts that relate to Data Warehouse Environment i.e. Operational And Staging Area, Cube and Data marts, ETL, and Interfaces.
Operational Application and Staging Area is a part that is associated with the data source be it internally or externally. The source of this data is in the form of applications that are in the operational organization. For example, information system ERP applications, databases, Files, documents, and more. The data in various formats from the source of this data is collected into a Staging Area on the Data Warehouse.
Cube and Data Mart is part of the Data Warehouse Environment process-related data analysis conducted by Cube multidimensional data. Data that has been likened in format will be analyzed from different points of view, so it will be easier to be analyzed. Furthermore, there are one or several Data Marts that require data and information in accordance with the requirements of subunits in Data Marts. In this part, the data will undergo a process of adjustment.
ETL or Extract Transform Loading is part of Environment Data Warehouse associated with the process that is performed by the Data Warehouse to equate data formats from data that has been collected. This will make it easier in the next processing is done using the data for multidimensional Cube. When it has been through the stages of the Cube will continue to the next stage which is where the data will be distributed to Data Marts for specific needs of the organizational unit. In this section, the Data will undergo data extraction and cleansing data from parts that are not relevant.
The interface is a step that deliver data and information of the output from the Data Warehouse to the user by using a number of media. For example the Dashboard Display, GUI, Web, Report. On this UMA, the resulting data and information delivery process to the media-the media.
Operational Application and Staging Area is a part that is associated with the data source be it internally or externally. The source of this data is in the form of applications that are in the operational organization. For example, information system ERP applications, databases, Files, documents, and more. The data in various formats from the source of this data is collected into a Staging Area on the Data Warehouse.
Cube and Data Mart is part of the Data Warehouse Environment process-related data analysis conducted by Cube multidimensional data. Data that has been likened in format will be analyzed from different points of view, so it will be easier to be analyzed. Furthermore, there are one or several Data Marts that require data and information in accordance with the requirements of subunits in Data Marts. In this part, the data will undergo a process of adjustment.
ETL or Extract Transform Loading is part of Environment Data Warehouse associated with the process that is performed by the Data Warehouse to equate data formats from data that has been collected. This will make it easier in the next processing is done using the data for multidimensional Cube. When it has been through the stages of the Cube will continue to the next stage which is where the data will be distributed to Data Marts for specific needs of the organizational unit. In this section, the Data will undergo data extraction and cleansing data from parts that are not relevant.
The interface is a step that deliver data and information of the output from the Data Warehouse to the user by using a number of media. For example the Dashboard Display, GUI, Web, Report. On this UMA, the resulting data and information delivery process to the media-the media.
Advertisement
No comments