- Back to Home »
- Relations between Data Warehouse, Data Mart, ETL and ELT
Posted by : Rega Adhitya
Monday, October 19, 2015
NIM : 1304505113
Faculty/Major : Engineering/IT Engineering
College : Udayana University
Lecturer : I Putu Agus Eka Pratama ST.,MT.,
Data Warehouse is a database that stores the data present and past data from different operational systems and other sources are an important concern for the management of the organization and is intended for analysis and management reporting within the framework of decision-making.
Part of the Data Warehouse that support the needs at the departmental level or a certain business functions within the company or called Data Mart is only focusing on the needs of users involved in a department or business function. Data Mart usually contain detailed operational data such as the Data Warehouse.
In processing an information, which comes from documents, databases, files and applications that will be processed by ETL (Extraction Transformation Loading) or ELT (Extraction Loading Transformation) which at this stage will process a source of data that will be stored in the Data Warehouse , A data will be through a process of extraction and then be transformed and the last will be loaded into the Data Warehouse in other words, this process is called ETL or by extraction of the data first, and then loaded into the Data Warehouse and transformed into a data that can be processed into a information other words, this process is called ELT.
Once the data is stored in the Data Warehouse, the need for OLAP technology that helps the process of analyzing the data to obtain an information, obtain necessary in making the report, allowing it to use the query that is needed and requires technology Data Mining in obtaining sources of data needed to process a information, which can later be used by the user in making a decision.