Open AccessOVERVIEW OF OPTIMIZATION METHODS FOR PRODUCTIVITY OF THE ETL PROCES
Author(s) -
A.Dzh. Kartanova,
T.I. Imanbekov
Publication year - 2021
Publication title -
vestnik kyrgyzskogo gosudarstvennogo universiteta stroitelʹstva, transporta i arhitektury im.n.isanova/n.isanov atyndagy kyrgyz mamlekettik kuruluš,transport žana arhitektura universitetinin žarčysy
Language(s) - English
Resource type - Journals
eISSN - 1694-8181
pISSN - 1694-5298
DOI - 10.35803/1694-5298.2021.4.556-563
Subject(s) - data warehouse , computer science , process (computing) , realization (probability) , database , architecture , data mining , operating system , art , statistics , mathematics , visual arts
One of the important aspects in management and acceleration of processes, operations in databases and data warehouses is ETL processes, the process of extracting, transforming and loading data. These processes without optimizing, a realization data warehouse project is costly, complex, and time-consuming.This paper provides an overview and research of methods for optimizing the performance of ETL processes; that the most important indicator of ETL system's operation is the time and speed of data processing is shown. The issues of the generalized structure of ETL process flows are considered, the architecture of ETL process optimization is proposed, and the main methods of parallel data processing in ETL systems are presented, those methods can improve its performance. The most relevant today of the problem is performance of ETL processes for data warehouses is considered in detail.