A performance study on different data load methods in relational databases.
Uloženo v:
| Název: | A performance study on different data load methods in relational databases. |
|---|---|
| Autoři: | Martins, Pedro, Sá, Filipe, Wanzeller, Cristina, Abbasi, Maryam |
| Zdroj: | CISTI (Iberian Conference on Information Systems & Technologies / Conferência Ibérica de Sistemas e Tecnologias de Informação) Proceedings; 2019, p1-6, 6p |
| Témata: | DATABASES, LEGACY systems, BACK up systems, ATTITUDE change (Psychology), CLOUD computing |
| Abstrakt: | Alongside with new cloud system emerging, legacy systems inside organizations are being migrated. With them, databases, and all stored data, which might variate from some GB to large amounts of TB. These systems migrations pose considerable problems - data export method, import method, consumed time, consistency, and so on - the so-called legacy system migration opens a new research topic, concerning how to migrate data timely efficient. The same problem, loading data, can be applied to ETL processes, with particular focus to the Load phase, which needs to be performed as fast as possible. This paper provides a brief review of different relational databases load methods and compares their performance. Experimental results show that despite the different available methods to efficiently load data (without losing information), performance is severely affected, presenting variations that can go from seconds to hours/days depending on the used strategy. [ABSTRACT FROM AUTHOR] |
| Copyright of CISTI (Iberian Conference on Information Systems & Technologies / Conferência Ibérica de Sistemas e Tecnologias de Informação) Proceedings is the property of Conferencia Iberica de Sistemas Tecnologia de Informacao and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Databáze: | Complementary Index |
Full Text Finder 
Nájsť tento článok vo Web of Science Buďte první, kdo okomentuje tento záznam!