<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

Publicado en línea: 25 ene 2014

Páginas: 31 - 37

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

Palabras clave
data warehouse, ETL process, categorisation

This content is open access.

EXTRACTING PROCESS AND MAPPING MANAGEMENT FOR HETEROGENNOUS SYSTEMS

Publicado en línea: 25 ene 2014

Páginas: 31 - 37

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

Palabras clavedata warehouse, ETL process, categorisation

This content is open access.

Palabras clave
data warehouse, ETL process, categorisation