<abstract xmlns="http://www.w3.org/1999/xhtml"><p> A lot of papers describe three common methods of data selection from primary systems. This paper defines how to select the correct method or combinations of methods for minimizing the impact of production system and common operation. Before using any method, it is necessary to know the primary system and its databases structures for the optimal use of the actual data structure setup and the best design for ETL process. Databases structures are usually categorized into groups, which characterize their quality. The classification helps to find the ideal method for each group and thus design a solution of ETL process with the minimal impact on the data warehouse and production system.</p></abstract>

A lot of papers describe three common methods of data selection from primary systems. This paper defines how to select the correct method or combinations of methods for minimizing the impact of production system and common operation. Before using any method, it is necessary to know the primary system and its databases structures for the optimal use of the actual data structure setup and the best design for ETL process. Databases structures are usually categorized into groups, which characterize their quality. The classification helps to find the ideal method for each group and thus design a solution of ETL process with the minimal impact on the data warehouse and production system.

EXTRACTING PROCESS AND MAPPING MANAGEMENT FOR HETEROGENNOUS SYSTEMS

Institute of Applied Informatics, Automation and Mathematics, Faculty of Materials Science and Technology in Trnava, Slovak University of Technology in Bratislava, Hajdóczyho 1, 917 01 Trnava, Slovak Republic

Research Papers Faculty of Materials Science and Technology Slovak University of Technology

{"article-title":"EXTRACTING PROCESS AND MAPPING MANAGEMENT FOR HETEROGENNOUS SYSTEMS"}

A lot of papers describe three common methods of data selection from primary systems. This paper defines how to select the correct method or combinations of...

EXTRACTING PROCESS AND MAPPING MANAGEMENT FOR HETEROGENNOUS SYSTEMS

Publié en ligne: 25 janv. 2014

Pages: 31 - 37

DOI: https://doi.org/10.2478/rput-2013-0037

Mots clés
data warehouse, ETL process, categorisation

This content is open access.

EXTRACTING PROCESS AND MAPPING MANAGEMENT FOR HETEROGENNOUS SYSTEMS

Publié en ligne: 25 janv. 2014

Pages: 31 - 37

DOI: https://doi.org/10.2478/rput-2013-0037

Mots clésdata warehouse, ETL process, categorisation

This content is open access.

Mots clés
data warehouse, ETL process, categorisation