Performance Analysis of One-to-Many Data Transformations

Detalhes bibliográficos
Autor(a) principal: Carreira, Paulo J.F.
Data de Publicação: 2006
Outros Autores: Galhardas, Helena, Pereira, João, Martins, Fernando, Silva, Mário J.
Tipo de documento: Relatório
Idioma: por
Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
Texto Completo: http://hdl.handle.net/10451/14208
Resumo: Relational Database Systems often support activities like data warehousing, cleaning and integration. All these activities require performing some sort of data transformations. Since data often resides on relational databases, data transformations are often specified using SQL, which is based of relational algebra. However, many useful data transformations cannot be expressed as SQL queries due to limited expressive power of relational algebra. In particular, an important class of data transformations that produces several output tuples for a single input tuple cannot be expressed in that way. In this report, we analyze alternatives to process one-to-many data transformations using Relational Database Systems, and compare them in terms of expressiveness, optimizability and performance
id RCAP_c68e8f5e715826ccdf5fdf5660294413
oai_identifier_str oai:repositorio.ul.pt:10451/14208
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling Performance Analysis of One-to-Many Data TransformationsData WarehousingData CleaningData IntegrationQuery OptimizationRelational Database Systems often support activities like data warehousing, cleaning and integration. All these activities require performing some sort of data transformations. Since data often resides on relational databases, data transformations are often specified using SQL, which is based of relational algebra. However, many useful data transformations cannot be expressed as SQL queries due to limited expressive power of relational algebra. In particular, an important class of data transformations that produces several output tuples for a single input tuple cannot be expressed in that way. In this report, we analyze alternatives to process one-to-many data transformations using Relational Database Systems, and compare them in terms of expressiveness, optimizability and performanceDepartment of Informatics, University of LisbonRepositório da Universidade de LisboaCarreira, Paulo J.F.Galhardas, HelenaPereira, JoãoMartins, FernandoSilva, Mário J.2009-02-10T13:11:41Z2006-122006-12-01T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/reportapplication/pdfhttp://hdl.handle.net/10451/14208porinfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2023-11-08T15:59:52Zoai:repositorio.ul.pt:10451/14208Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T21:36:02.292807Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv Performance Analysis of One-to-Many Data Transformations
title Performance Analysis of One-to-Many Data Transformations
spellingShingle Performance Analysis of One-to-Many Data Transformations
Carreira, Paulo J.F.
Data Warehousing
Data Cleaning
Data Integration
Query Optimization
title_short Performance Analysis of One-to-Many Data Transformations
title_full Performance Analysis of One-to-Many Data Transformations
title_fullStr Performance Analysis of One-to-Many Data Transformations
title_full_unstemmed Performance Analysis of One-to-Many Data Transformations
title_sort Performance Analysis of One-to-Many Data Transformations
author Carreira, Paulo J.F.
author_facet Carreira, Paulo J.F.
Galhardas, Helena
Pereira, João
Martins, Fernando
Silva, Mário J.
author_role author
author2 Galhardas, Helena
Pereira, João
Martins, Fernando
Silva, Mário J.
author2_role author
author
author
author
dc.contributor.none.fl_str_mv Repositório da Universidade de Lisboa
dc.contributor.author.fl_str_mv Carreira, Paulo J.F.
Galhardas, Helena
Pereira, João
Martins, Fernando
Silva, Mário J.
dc.subject.por.fl_str_mv Data Warehousing
Data Cleaning
Data Integration
Query Optimization
topic Data Warehousing
Data Cleaning
Data Integration
Query Optimization
description Relational Database Systems often support activities like data warehousing, cleaning and integration. All these activities require performing some sort of data transformations. Since data often resides on relational databases, data transformations are often specified using SQL, which is based of relational algebra. However, many useful data transformations cannot be expressed as SQL queries due to limited expressive power of relational algebra. In particular, an important class of data transformations that produces several output tuples for a single input tuple cannot be expressed in that way. In this report, we analyze alternatives to process one-to-many data transformations using Relational Database Systems, and compare them in terms of expressiveness, optimizability and performance
publishDate 2006
dc.date.none.fl_str_mv 2006-12
2006-12-01T00:00:00Z
2009-02-10T13:11:41Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/report
format report
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10451/14208
url http://hdl.handle.net/10451/14208
dc.language.iso.fl_str_mv por
language por
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Department of Informatics, University of Lisbon
publisher.none.fl_str_mv Department of Informatics, University of Lisbon
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799134258638356480

Registros relacionados