Designing relational data warehouses through schema-transformation primitives

A Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making request. It is a database with some particular features concerning the data it contains and its utilisation. The features od DWs cause the DW design process and strategies to be different from the ones fo...

Whakaahuatanga katoa

I tiakina i:
Ngā taipitopito rārangi puna kōrero
Kaituhi matua: Marotta, Adriana (author)
Hōputu: report
I whakaputaina: 2001
Ngā marau:
Urunga tuihono:http://hdl.handle.net/20.500.12008/3433
Ngā Tūtohu: Tāpirihia he Tūtohu
Kāore He Tūtohu, Me noho koe te mea tuatahi ki te tūtohu i tēnei pūkete!
_version_ 1868890118845104128
author Marotta, Adriana
author_browse Marotta, Adriana
author_facet Marotta, Adriana
author_role author
collection COLIBRI
dc.creator.none.fl_str_mv Marotta, Adriana
dc.date.none.fl_str_mv 2001
2014-12-02T16:05:55Z
2014-12-02T16:05:55Z
20141202
dc.format.none.fl_str_mv 60 p.
application/pdf
dc.identifier.none.fl_str_mv MAROTTA, A. "Designing relational data warehouses through schema-transformation primitives". Reportes Técnicos 01-10. UR. FI – INCO, 2001.
0797-6410
http://hdl.handle.net/20.500.12008/3433
dc.language.none.fl_str_mv in
dc.publisher.none.fl_str_mv UR. FI – INCO.
dc.relation.none.fl_str_mv Reportes Técnicos 01-10
dc.rights.none.fl_str_mv info:eu-repo/semantics/openAccess
Licencia Creative Commons Atribución – No Comercial – Sin Derivadas (CC BY-NC-ND 4.0)
dc.source.none.fl_str_mv reponame:COLIBRI
instname:Universidad de la República
instacron:Universidad de la República
dc.subject.none.fl_str_mv DATA WAREHOUSE
DATA WAREHOUSE DESIGN
SCHEMA TRANFORMATION
RELATIONAL DATA WAREHOUSE
DISEÑO DE DATA WAREHOUSE
dc.title.none.fl_str_mv Designing relational data warehouses through schema-transformation primitives
dc.type.none.fl_str_mv Reporte técnico
info:eu-repo/semantics/report
info:eu-repo/semantics/publishedVersion
description A Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making request. It is a database with some particular features concerning the data it contains and its utilisation. The features od DWs cause the DW design process and strategies to be different from the ones for OLTP Systems. We address the DW design problem through a schema transformation approach. We propose a set of schema transformation primitives, which are high-level operations that transform relational sub-schemas into other relational sub-chemas. We also provide some tools that can help in DW design process: (a) the design trace, (b) a set of DW schema invariants, (c) a set of rules that specify how to correct schema-strategies dor designing the DW through application of primitives.
eu_rights_str_mv openAccess
format report
id anni_8899dec3abe5f282575fb4dae8b170c4
identifier_str_mv MAROTTA, A. "Designing relational data warehouses through schema-transformation primitives". Reportes Técnicos 01-10. UR. FI – INCO, 2001.
0797-6410
instacron_str Universidad de la República
institution Universidad de la República
instname_str Universidad de la República
language_invalid_str_mv in
network_acronym_str anni
network_name_str oai-lr-anni
oai_identifier_str oai:colibri.udelar.edu.uy:20.500.12008/3433
publishDate 2001
publishDateSort 2001
publisher.none.fl_str_mv UR. FI – INCO.
reponame_str COLIBRI
repository.mail.fl_str_mv
repository.name.fl_str_mv
repository_id_str
rights_invalid_str_mv Licencia Creative Commons Atribución – No Comercial – Sin Derivadas (CC BY-NC-ND 4.0)
spelling Designing relational data warehouses through schema-transformation primitivesMarotta, AdrianaDATA WAREHOUSEDATA WAREHOUSE DESIGNSCHEMA TRANFORMATIONRELATIONAL DATA WAREHOUSEDISEÑO DE DATA WAREHOUSEA Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making request. It is a database with some particular features concerning the data it contains and its utilisation. The features od DWs cause the DW design process and strategies to be different from the ones for OLTP Systems. We address the DW design problem through a schema transformation approach. We propose a set of schema transformation primitives, which are high-level operations that transform relational sub-schemas into other relational sub-chemas. We also provide some tools that can help in DW design process: (a) the design trace, (b) a set of DW schema invariants, (c) a set of rules that specify how to correct schema-strategies dor designing the DW through application of primitives.UR. FI – INCO.2014-12-02T16:05:55Z2014-12-02T16:05:55Z200120141202Reporte técnicoinfo:eu-repo/semantics/reportinfo:eu-repo/semantics/publishedVersion60 p.application/pdfMAROTTA, A. "Designing relational data warehouses through schema-transformation primitives". Reportes Técnicos 01-10. UR. FI – INCO, 2001.0797-6410http://hdl.handle.net/20.500.12008/3433reponame:COLIBRIinstname:Universidad de la Repúblicainstacron:Universidad de la RepúblicainReportes Técnicos 01-10Las obras depositadas en el Repositorio se rigen por la Ordenanza de los Derechos de la Propiedad Intelectual de la Universidad De La República. (Res. Nº 91 de C.D.C. de 8/III/1994 – D.O. 7/IV/1994) y por la Ordenanza del Repositorio Abierto de la Universidad de la República (Res. Nº 16 de C.D.C. de 07/10/2014)info:eu-repo/semantics/openAccessLicencia Creative Commons Atribución – No Comercial – Sin Derivadas (CC BY-NC-ND 4.0)oai:colibri.udelar.edu.uy:20.500.12008/34332026-04-14T10:16:10Z
spellingShingle Designing relational data warehouses through schema-transformation primitives
Marotta, Adriana
DATA WAREHOUSE
DATA WAREHOUSE DESIGN
SCHEMA TRANFORMATION
RELATIONAL DATA WAREHOUSE
DISEÑO DE DATA WAREHOUSE
status_str publishedVersion
title Designing relational data warehouses through schema-transformation primitives
title_full Designing relational data warehouses through schema-transformation primitives
title_fullStr Designing relational data warehouses through schema-transformation primitives
title_full_unstemmed Designing relational data warehouses through schema-transformation primitives
title_short Designing relational data warehouses through schema-transformation primitives
title_sort Designing relational data warehouses through schema-transformation primitives
topic DATA WAREHOUSE
DATA WAREHOUSE DESIGN
SCHEMA TRANFORMATION
RELATIONAL DATA WAREHOUSE
DISEÑO DE DATA WAREHOUSE
url http://hdl.handle.net/20.500.12008/3433