|
|
Registro Completo |
Biblioteca(s): |
Embrapa Pecuária Sudeste. |
Data corrente: |
10/05/2023 |
Data da última atualização: |
10/05/2023 |
Tipo da produção científica: |
Artigo em Periódico Indexado |
Autoria: |
VILELA, F. DE A.; TIMES, V. C.; BERNARDI, A. C. de C.; FREITAS, A. DE P.; CIFERRI, R. R. |
Afiliação: |
FLÁ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. |
Título: |
A non-intrusive and reactive architecture to support real-time ETL processes in data warehousing environments. |
Ano de publicação: |
2023 |
Fonte/Imprenta: |
Heliyon, v. 9, n. 5, e15728, may 2023. |
Páginas: |
25 p. |
DOI: |
https://doi.org/10.1016/j.heliyon.2023.e15728 |
Idioma: |
Inglês |
Conteúdo: |
Nowadays, 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. |
Palavras-Chave: |
Data extraction; Data loading; Data warehouse; ETL; Real time. |
Categoria do assunto: |
X Pesquisa, Tecnologia e Engenharia |
URL: |
https://ainfo.cnptia.embrapa.br/digital/bitstream/doc/1153634/1/NonIntrusiveReactive.pdf
|
Marc: |
LEADER 02051naa a2200253 a 4500 001 2153634 005 2023-05-10 008 2023 bl uuuu u00u1 u #d 024 7 $ahttps://doi.org/10.1016/j.heliyon.2023.e15728$2DOI 100 1 $aVILELA, F. DE A. 245 $aA non-intrusive and reactive architecture to support real-time ETL processes in data warehousing environments.$h[electronic resource] 260 $c2023 300 $a25 p. 520 $aNowadays, 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. 653 $aData extraction 653 $aData loading 653 $aData warehouse 653 $aETL 653 $aReal time 700 1 $aTIMES, V. C. 700 1 $aBERNARDI, A. C. de C. 700 1 $aFREITAS, A. DE P. 700 1 $aCIFERRI, R. R. 773 $tHeliyon$gv. 9, n. 5, e15728, may 2023.
Download
Esconder MarcMostrar Marc Completo |
Registro original: |
Embrapa Pecuária Sudeste (CPPSE) |
|
Biblioteca |
ID |
Origem |
Tipo/Formato |
Classificação |
Cutter |
Registro |
Volume |
Status |
URL |
Voltar
|
|
| Acesso ao texto completo restrito à biblioteca da Embrapa Agroindústria de Alimentos. Para informações adicionais entre em contato com ctaa.biblioteca@embrapa.br. |
Registro Completo
Biblioteca(s): |
Embrapa Agroindústria de Alimentos. |
Data corrente: |
28/09/2011 |
Data da última atualização: |
30/11/2012 |
Tipo da produção científica: |
Artigo em Periódico Indexado |
Circulação/Nível: |
A - 1 |
Autoria: |
NEGRI, G.; TEIXEIRA, E. W.; ALVES, M. L. T. M. F.; MORETI, A. C. de C. C.; OTSUK, I. P.; BORGUINI, R. G.; SALATINO, A. |
Afiliação: |
GIUSEPPINA NEGRI, CEBRID-UNIFESP; ERICA WEINSTEIN TEIXEIRA, AGÊNCIA PAULISTA DE TECNOLOGIA DOS AGRONEGÓCIOS; MARIA LUISA TELES MARQUES FLORÊNCIO ALVES, AGÊNCIA PAULISTA DE TECNOLOGIA DOS AGRONEGÓCIOS; AUGUSTA CAROLINA DE CAMARGO CARMELLO MORETI, AGÊNCIA PAULISTA DE TECNOLOGIA DOS AGRONEGÓCIOS; IVANI POZAR OTSUK, AGÊNCIA PAULISTA DE TECNOLOGIA DOS AGRONEGÓCIOS; RENATA GALHARDO BORGUINI, CTAA; ANTONIO SALATINO, INSTITUTO DE BIOCIÊNCIAS-USP. |
Título: |
Hydroxycinnamic acid amide derivatives, phenolic compounds and antioxidant activities of extracts of pollen samples from southeast Brazil. |
Ano de publicação: |
2011 |
Fonte/Imprenta: |
Journal of Agricultural and Food Chemistry, v. 59, n. 10, p. 5516-5522, 2011. |
DOI: |
10.1021/jf200602k |
Idioma: |
Inglês |
Conteúdo: |
Seven bee pollen samples (C1?C7) with different palynological sources were harvested from Pindamonhangaba municipality (Southeast Brazil). Methanol extracts of untreated samples (control), samples frozen at −18 °C and samples frozen and then dried were analyzed by HPLC/PAD/ESI/MS/MS. Flavonoid diglycosides of quercetin, kaempferol, isorhamnetin and patuletin were detected, together with hydroxycinnamic acid amide derivatives, such as N′,N′′,N′′′-tris-p-feruloylspermidine and N′,N′′,N′′′-tris-p-coumaroylspermidine. Distinct phenolic profiles characterized the analyzed samples, but no differences were noted as resulting from different treatments. Total phenolic contents determined with the Folin?Ciocalteau reagent ranged from 1.7 to 2.2%. Antioxidant activities above 75%, based on the DPPH method, were observed for all extracts, not correlated with total phenolic contents. Among samples from the same origin, those frozen were more active than samples untreated (control), and the samples frozen and then dried were the most active. |
Palavras-Chave: |
Atividade antioxidante. |
Thesagro: |
Apis mellifera; Composição química; Composto fenólico; Flavonóide; Pólen. |
Categoria do assunto: |
X Pesquisa, Tecnologia e Engenharia |
Marc: |
LEADER 01989naa a2200277 a 4500 001 1901614 005 2012-11-30 008 2011 bl uuuu u00u1 u #d 024 7 $a10.1021/jf200602k$2DOI 100 1 $aNEGRI, G. 245 $aHydroxycinnamic acid amide derivatives, phenolic compounds and antioxidant activities of extracts of pollen samples from southeast Brazil. 260 $c2011 520 $aSeven bee pollen samples (C1?C7) with different palynological sources were harvested from Pindamonhangaba municipality (Southeast Brazil). Methanol extracts of untreated samples (control), samples frozen at −18 °C and samples frozen and then dried were analyzed by HPLC/PAD/ESI/MS/MS. Flavonoid diglycosides of quercetin, kaempferol, isorhamnetin and patuletin were detected, together with hydroxycinnamic acid amide derivatives, such as N′,N′′,N′′′-tris-p-feruloylspermidine and N′,N′′,N′′′-tris-p-coumaroylspermidine. Distinct phenolic profiles characterized the analyzed samples, but no differences were noted as resulting from different treatments. Total phenolic contents determined with the Folin?Ciocalteau reagent ranged from 1.7 to 2.2%. Antioxidant activities above 75%, based on the DPPH method, were observed for all extracts, not correlated with total phenolic contents. Among samples from the same origin, those frozen were more active than samples untreated (control), and the samples frozen and then dried were the most active. 650 $aApis mellifera 650 $aComposição química 650 $aComposto fenólico 650 $aFlavonóide 650 $aPólen 653 $aAtividade antioxidante 700 1 $aTEIXEIRA, E. W. 700 1 $aALVES, M. L. T. M. F. 700 1 $aMORETI, A. C. de C. C. 700 1 $aOTSUK, I. P. 700 1 $aBORGUINI, R. G. 700 1 $aSALATINO, A. 773 $tJournal of Agricultural and Food Chemistry$gv. 59, n. 10, p. 5516-5522, 2011.
Download
Esconder MarcMostrar Marc Completo |
Registro original: |
Embrapa Agroindústria de Alimentos (CTAA) |
|
Biblioteca |
ID |
Origem |
Tipo/Formato |
Classificação |
Cutter |
Registro |
Volume |
Status |
Fechar
|
Expressão de busca inválida. Verifique!!! |
|
|