Zobraziť v EDS

A performance study on different data load methods in relational databases.

Uložené v:
Podrobná bibliografia
Názov: A performance study on different data load methods in relational databases.
Autori: 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
Predmety: 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áza: Complementary Index
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://resolver.ebscohost.com/openurl?sid=EBSCO:edb&genre=article&issn=21660727&ISBN=&volume=&issue=&date=20190101&spage=1&pages=1-6&title=CISTI (Iberian Conference on Information Systems & Technologies / Conferência Ibérica de Sistemas e Tecnologias de Informação) Proceedings&atitle=A%20performance%20study%20on%20different%20data%20load%20methods%20in%20relational%20databases.&aulast=Martins%2C%20Pedro&id=DOI:
    Name: Full Text Finder
    Category: fullText
    Text: Full Text Finder
    Icon: https://imageserver.ebscohost.com/branding/images/FTF.gif
    MouseOverText: Full Text Finder
  – Url: https://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=EBSCO&SrcAuth=EBSCO&DestApp=WOS&ServiceName=TransferToWoS&DestLinkType=GeneralSearchSummary&Func=Links&author=Martins%20P
    Name: ISI
    Category: fullText
    Text: Nájsť tento článok vo Web of Science
    Icon: https://imagesrvr.epnet.com/ls/20docs.gif
    MouseOverText: Nájsť tento článok vo Web of Science
Header DbId: edb
DbLabel: Complementary Index
An: 139263162
RelevancyScore: 889
AccessLevel: 6
PubType: Conference
PubTypeId: conference
PreciseRelevancyScore: 888.718200683594
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: A performance study on different data load methods in relational databases.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Martins%2C+Pedro%22">Martins, Pedro</searchLink><br /><searchLink fieldCode="AR" term="%22Sá%2C+Filipe%22">Sá, Filipe</searchLink><br /><searchLink fieldCode="AR" term="%22Wanzeller%2C+Cristina%22">Wanzeller, Cristina</searchLink><br /><searchLink fieldCode="AR" term="%22Abbasi%2C+Maryam%22">Abbasi, Maryam</searchLink>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: CISTI (Iberian Conference on Information Systems & Technologies / Conferência Ibérica de Sistemas e Tecnologias de Informação) Proceedings; 2019, p1-6, 6p
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22DATABASES%22">DATABASES</searchLink><br /><searchLink fieldCode="DE" term="%22LEGACY+systems%22">LEGACY systems</searchLink><br /><searchLink fieldCode="DE" term="%22BACK+up+systems%22">BACK up systems</searchLink><br /><searchLink fieldCode="DE" term="%22ATTITUDE+change+%28Psychology%29%22">ATTITUDE change (Psychology)</searchLink><br /><searchLink fieldCode="DE" term="%22CLOUD+computing%22">CLOUD computing</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: 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]
– Name: Abstract
  Label:
  Group: Ab
  Data: <i>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.</i> (Copyright applies to all Abstracts.)
PLink https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edb&AN=139263162
RecordInfo BibRecord:
  BibEntity:
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 6
        StartPage: 1
    Subjects:
      – SubjectFull: DATABASES
        Type: general
      – SubjectFull: LEGACY systems
        Type: general
      – SubjectFull: BACK up systems
        Type: general
      – SubjectFull: ATTITUDE change (Psychology)
        Type: general
      – SubjectFull: CLOUD computing
        Type: general
    Titles:
      – TitleFull: A performance study on different data load methods in relational databases.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Martins, Pedro
      – PersonEntity:
          Name:
            NameFull: Sá, Filipe
      – PersonEntity:
          Name:
            NameFull: Wanzeller, Cristina
      – PersonEntity:
          Name:
            NameFull: Abbasi, Maryam
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Text: 2019
              Type: published
              Y: 2019
          Identifiers:
            – Type: issn-print
              Value: 21660727
          Titles:
            – TitleFull: CISTI (Iberian Conference on Information Systems & Technologies / Conferência Ibérica de Sistemas e Tecnologias de Informação) Proceedings
              Type: main
ResultId 1