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...
I tiakina i:
| Kaituhi matua: | |
|---|---|
| Hōputu: | report |
| I whakaputaina: |
2001
|
| Ngā marau: | |
| Urunga tuihono: | http://hdl.handle.net/20.500.12008/3433 |
| Ngā 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 |