Por favor, use este identificador para citar o enlazar este ítem: http://www.alice.cnptia.embrapa.br/alice/handle/doc/1153634
Registro completo de metadatos
Campo DCValorLengua/Idioma
dc.contributor.authorVILELA, F. DE A.
dc.contributor.authorTIMES, V. C.
dc.contributor.authorBERNARDI, A. C. de C.
dc.contributor.authorFREITAS, A. DE P.
dc.contributor.authorCIFERRI, R. R.
dc.date.accessioned2023-05-10T13:47:24Z-
dc.date.available2023-05-10T13:47:24Z-
dc.date.created2023-05-10
dc.date.issued2023
dc.identifier.citationHeliyon, v. 9, n. 5, e15728, may 2023.
dc.identifier.urihttp://www.alice.cnptia.embrapa.br/alice/handle/doc/1153634-
dc.descriptionNowadays, organizations are very interested to gather data for strategic decision-making. Data are disposable in operational sources, which are distributed, heterogeneous, and autonomous. These data are gathered through ETL processes, which occur traditionally in a pre-defined time, that is, once a day, once a week, once a month or in a specific period of time. On the other hand, there are special applications for which data needs to be obtained in a faster way and sometimes even immediately after the data are generated in the operation data sources, such as health systems and digital agriculture. Thus, the conventional ETL process and the disposable techniques are incapable of making the operational data delivered in real-time, providing low latency, high availability, and scalability. As our proposal, we present an innovative architecture, named Data Magnet, to cope with real-time ETL processes. The experimental tests performed in the digital agriculture domain using real and synthetic data showed that our proposal was able to deal in real-time with the ETL process. The Data Magnet provided great performance, showing an almost constant elapsed time for growing data volumes. Besides, Data Magnet provided significant performance gains over the traditional trigger technique.
dc.language.isoeng
dc.rightsopenAccess
dc.subjectData warehouse
dc.subjectReal time
dc.subjectETL
dc.subjectData extraction
dc.subjectData loading
dc.titleA non-intrusive and reactive architecture to support real-time ETL processes in data warehousing environments.
dc.typeArtigo de periódico
dc.format.extent225 p.
riaa.ainfo.id1153634
riaa.ainfo.lastupdate2023-05-10
dc.identifier.doihttps://doi.org/10.1016/j.heliyon.2023.e15728
dc.contributor.institutionFLÁVIO DE ASSIS VILELA, Federal Institute of Goiás; VALÉRIA CESÁRIO TIMES, Federal University of Pernambuco; ALBERTO CARLOS DE CAMPOS BERNARDI, CPPSE; AUGUSTO DE PAULA FREITAS, Federal University of São Carlos; RICARDO RODRIGUES CIFERRI, Federal University of São Carlos.
Aparece en las colecciones:Artigo em periódico indexado (CPPSE)

Ficheros en este ítem:
Fichero Descripción TamañoFormato 
NonIntrusiveReactive.pdf3.42 MBAdobe PDFVista previa
Visualizar/Abrir
Mostrar el registro sencillo del ítem

FacebookTwitterDeliciousLinkedInGoogle BookmarksMySpace