Diseño lógico de Data Warehouses a partir de esquemas multidimensionales
A Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making requests. DW features are very different from conventional database ones, so that the data models and design strategies for the latter are generally not to be applicable for DW. These differences have mot...
Saved in:
| Main Author: | |
|---|---|
| Format: | masterThesis |
| Language: | Spanish |
| Published: |
2001
|
| Subjects: | |
| Online Access: | http://hdl.handle.net/20.500.12008/2919 |
| Tags: |
No Tags, Be the first to tag this record!
|
| _version_ | 1868889983905955840 |
|---|---|
| author | Peralta Costabel, Veronika del Carmen |
| author_browse | Peralta Costabel, Veronika del Carmen |
| author_facet | Peralta Costabel, Veronika del Carmen |
| author_role | author |
| collection | COLIBRI |
| dc.creator.none.fl_str_mv | Peralta Costabel, Veronika del Carmen |
| dc.date.none.fl_str_mv | 2001 2014-11-24T22:35:35Z 2014-11-24T22:35:35Z 20141202 |
| dc.format.none.fl_str_mv | 153 p. application/pdf |
| dc.identifier.none.fl_str_mv | PERALTA COSTABEL, V. "Diseño lógico de Data Warehouses a partir de esquemas multidimensionales". Tesis de maestría, Universidad de la República (Uruguay). Facultad de Ingeniería. Instituto de Computación – PEDECIBA, 2001. http://hdl.handle.net/20.500.12008/2919 |
| dc.language.none.fl_str_mv | es spa |
| dc.publisher.none.fl_str_mv | UR. FI-INCO, |
| 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 BASE DE DATOS DATABASES |
| dc.title.none.fl_str_mv | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| dc.type.none.fl_str_mv | Tesis de maestría info:eu-repo/semantics/masterThesis info:eu-repo/semantics/acceptedVersion |
| description | A Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making requests. DW features are very different from conventional database ones, so that the data models and design strategies for the latter are generally not to be applicable for DW. These differences have motivated the development of new design techniques and strategies. This work addresses DW logical design. Concretely, we propose for generating the DW relational schema starting from a conceptual multidimensional schema and integrated source database. The generation is carried out applying schema transformations to the relational schema of the source database. We propose an algorithm to determine wich transformations must be applied, wich is based on a set of design rules. The rules involve the conceptual schema, the source database, correspondences between these schemes and design strategies related with performance and storage constraints. This works includes the prototype of a CASE tool wich assists the designer in the construction of a relational DW from a conceptual specification. |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| id | anni_2371e6fa6dedcc5c33491790b3ddd2ce |
| identifier_str_mv | PERALTA COSTABEL, V. "Diseño lógico de Data Warehouses a partir de esquemas multidimensionales". Tesis de maestría, Universidad de la República (Uruguay). Facultad de Ingeniería. Instituto de Computación – PEDECIBA, 2001. |
| instacron_str | Universidad de la República |
| institution | Universidad de la República |
| instname_str | Universidad de la República |
| language | spa |
| language_invalid_str_mv | es |
| network_acronym_str | anni |
| network_name_str | oai-lr-anni |
| oai_identifier_str | oai:colibri.udelar.edu.uy:20.500.12008/2919 |
| 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 | Diseño lógico de Data Warehouses a partir de esquemas multidimensionalesPeralta Costabel, Veronika del CarmenDATA WAREHOUSEBASE DE DATOSDATABASESA Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making requests. DW features are very different from conventional database ones, so that the data models and design strategies for the latter are generally not to be applicable for DW. These differences have motivated the development of new design techniques and strategies. This work addresses DW logical design. Concretely, we propose for generating the DW relational schema starting from a conceptual multidimensional schema and integrated source database. The generation is carried out applying schema transformations to the relational schema of the source database. We propose an algorithm to determine wich transformations must be applied, wich is based on a set of design rules. The rules involve the conceptual schema, the source database, correspondences between these schemes and design strategies related with performance and storage constraints. This works includes the prototype of a CASE tool wich assists the designer in the construction of a relational DW from a conceptual specification.UR. FI-INCO,2014-11-24T22:35:35Z2014-11-24T22:35:35Z200120141202Tesis de maestríainfo:eu-repo/semantics/masterThesisinfo:eu-repo/semantics/acceptedVersion153 p.application/pdfPERALTA COSTABEL, V. "Diseño lógico de Data Warehouses a partir de esquemas multidimensionales". Tesis de maestría, Universidad de la República (Uruguay). Facultad de Ingeniería. Instituto de Computación – PEDECIBA, 2001.http://hdl.handle.net/20.500.12008/2919reponame:COLIBRIinstname:Universidad de la Repúblicainstacron:Universidad de la RepúblicaesspaLas 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/29192026-04-14T10:27:49Z |
| spellingShingle | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales Peralta Costabel, Veronika del Carmen DATA WAREHOUSE BASE DE DATOS DATABASES |
| status_str | acceptedVersion |
| title | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| title_full | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| title_fullStr | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| title_full_unstemmed | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| title_short | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| title_sort | Diseño lógico de Data Warehouses a partir de esquemas multidimensionales |
| topic | DATA WAREHOUSE BASE DE DATOS DATABASES |
| url | http://hdl.handle.net/20.500.12008/2919 |