Real Time Delta Extraction Based on Triggers to Support Data Warehousing

Registro completo de metadados
MetadadosDescriçãoIdioma
Autor(es): dc.contributorUniversidade Estadual Paulista (Unesp)-
Autor(es): dc.creatorValencio, Carlos Roberto [UNESP]-
Autor(es): dc.creatorMarioto, Matheus Henrique [UNESP]-
Autor(es): dc.creatorDonega Zafalon, Geraldo Francisco [UNESP]-
Autor(es): dc.creatorMachado, Jose Marcio [UNESP]-
Autor(es): dc.creatorMomente, Julio Cesar [UNESP]-
Autor(es): dc.creatorHorng, S. J.-
Data de aceite: dc.date.accessioned2022-02-22T00:12:42Z-
Data de disponibilização: dc.date.available2022-02-22T00:12:42Z-
Data de envio: dc.date.issued2020-12-09-
Data de envio: dc.date.issued2020-12-09-
Data de envio: dc.date.issued2013-01-01-
Fonte completa do material: dc.identifierhttp://dx.doi.org/10.1109/PDCAT.2013.52-
Fonte completa do material: dc.identifierhttp://hdl.handle.net/11449/197452-
Fonte: dc.identifier.urihttp://educapes.capes.gov.br/handle/11449/197452-
Descrição: dc.descriptionNowadays large corporations require integrated data from diverse sources, leading to the use of data warehouse architectures for this purpose. To bypass problems related to the use of computational resources to process large volumes of data, an ETL (Extract, Transform and Load) technique with zero latency can be used, that works by constantly processing small data loads. Among the extraction techniques of the zero latency ETL are the use of logs, triggers, materialized views and timestamps. This paper proposes a structure capable of performing this task by means of triggers and a tool developed for the automatic generation of the SQL (Structured Query Language) code to create these trigger, besides showing its performance and comparing it to other techniques. Said method is relevant for the extraction of portions of selected information as it permits to combine conventional and real time ETL techniques.-
Descrição: dc.descriptionSao Paulo State Univ, Dept Ciencias Computacao & Estat, Sao Paulo, Brazil-
Descrição: dc.descriptionSao Paulo State Univ, Dept Ciencias Computacao & Estat, Sao Paulo, Brazil-
Formato: dc.format293-297-
Idioma: dc.languageen-
Publicador: dc.publisherIeee-
Relação: dc.relation2013 International Conference On Parallel And Distributed Computing, Applications And Technologies (pdcat)-
???dc.source???: dc.sourceWeb of Science-
Palavras-chave: dc.subjectdata warehouse-
Palavras-chave: dc.subjectETL (Extract Transform and Load)-
Palavras-chave: dc.subjectCDC (Change Data Capture)-
Palavras-chave: dc.subjecttrigger-
Palavras-chave: dc.subjectautomatic code generation-
Título: dc.titleReal Time Delta Extraction Based on Triggers to Support Data Warehousing-
Aparece nas coleções:Repositório Institucional - Unesp

Não existem arquivos associados a este item.