Abstract

 
 
 
 Data warehouse (DW) is the basis of systems for operational data analysis (OLAP-Online Analytical Processing). Data extracted from different sources transforms and load in DW. Proper organization of this process, which is called ETL (Extract, Transform, Load) has important significance in creation of DW and analytical data processing. Forms of organization, methods of realization and modeling of ETL processes are considered in this paper.
 
 
 
Highlights
Data warehouse (DW) is the basis of systems for operational data analysis (OLAP-Online Analytical Processing)
Since the ETL process is an integral part of DS operation, the development of ETL process is one of the most important issues in establishing the DS
Methods for arranging the ETL process can be distinguished by the following features: - the site where data conversion is carried out; - the person who the data is removed by from the source; - the site where the data removal process is conducted
Summary
An alternative way to the considered one performs converting data in the ETL server RAM, and the results are directly uploaded to the DS (Figure 2). Intermediate memory is used when the size of portion is large. Another way to arrange the ETL process is to perform data conversion in the DS server (Figure 3). In this case, data conversion is carried out during the process of their uploading to the DS. Data conversion is carried out during the process of their uploading to the DS The application of this method is determined by computing capabilities of the DS server
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
