Registro:
| Documento: | Tesis Doctoral |
| Disciplina: | computacion |
| Título: | Actualización y mantenimiento de vistas en bases de datos multidimensionales = Updates and view maintenance in multidimensional databases |
| Autor: | Vaisman, Alejandro Ariel |
| Editor: | Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales |
| Publicación en la Web: | 2017-03-01 |
| Fecha de defensa: | 2001 |
| Fecha en portada: | 2001 |
| Grado Obtenido: | Doctorado |
| Título Obtenido: | Doctor en Ciencias de la Computación |
| Departamento Docente: | Departamento de Computación |
| Director: | Mendelzon, Alberto |
| Idioma: | Español |
| Formato: | PDF |
| Handle: |
http://hdl.handle.net/20.500.12110/tesis_n3331_Vaisman |
| PDF: | https://bibliotecadigital.exactas.uba.ar/download/tesis/tesis_n3331_Vaisman.pdf |
| Registro: | https://bibliotecadigital.exactas.uba.ar/collection/tesis/document/tesis_n3331_Vaisman |
| Ubicación: | 003331 |
| Derechos de Acceso: | Esta obra puede ser leída, grabada y utilizada con fines de estudio, investigación y docencia. Es necesario el reconocimiento de autoría mediante la cita correspondiente. Vaisman, Alejandro Ariel. (2001). Actualización y mantenimiento de vistas en bases de datos multidimensionales = Updates and view maintenance in multidimensional databases. (Tesis Doctoral. Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales). Recuperado de http://hdl.handle.net/20.500.12110/tesis_n3331_Vaisman |
Abstract:
Usually, OLAP(On Line Analytical Processing) systems provide data visualization through a multidimensionaldata model according to which a data fact is viewed as a mapping from a point in aspace of dimensions into one or more spaces of measures. Moreover, dimensions are organized inlevels which conform a hierarchy, providing a way of defining different levels of data aggregation, acentral issue in data analysis. In a relational implementation of OLAP(usually called ROLAP), wecan think of facts as being stored in fact tables, while each dimension is described in a dimensiontable. The industry solutions were built under the assumption that data in fact tables reflect thedynamic aspect of the data warehouse, while data in dimension tables represent static information. However, if we think of the data warehouse as a materialized view of data located in multiplesources, it is usual to find situations in which the structure of these sources changes, a new sourceis added, or an old one dropped. Any of these changes may require updates to the structure ofsome dimensions. Further, as multidimensional views are designed according to requirements fromend users, a redefinition of the initial requirements may cause a dimension update. In this thesis we argue that accounting for dimension updates is necessary in an OLAP toolin order to avoid constantly rebuilding dimensions from scratch. Thus, we first characterize theseupdates and study the view maintenance problem when they occur. We developed algorithms which,taking advantage of the nature of the dimension updates, in some cases outperform well-known viewmaintenance algorithms. We then propose an extension to the MDX language(a standard querylanguage for OLAP) and describe the implementation of TSOLAP, a multidimensional repositorywhich supports dimension updates and view maintenance, developed following the OLE DB for OLAP standard. We discuss the experimental results of tests performed over a real-life case study,a medical center in Buenos Aires. In the second part of the thesis we embed our proposal in the temporal database framework,introducing the Temporal Multidimensional Data Model, and a temporal query language for OLAPwhich we called TOLAP. TOLAP allows expressing complex OLAP queries in an elegant anddeclarative fashion. We discuss issues like syntax, semantics, safety and expressive power. We alsopresent an implementation including a graphic environment for temporal OLAP. Finally, we showhow the temporal approach can be applied to the case study mentioned above.
Citación:
---------- APA ----------
Vaisman, Alejandro Ariel. (2001). Actualización y mantenimiento de vistas en bases de datos multidimensionales = Updates and view maintenance in multidimensional databases. (Tesis Doctoral. Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales.). Recuperado de https://hdl.handle.net/20.500.12110/tesis_n3331_Vaisman
---------- CHICAGO ----------
Vaisman, Alejandro Ariel. "Actualización y mantenimiento de vistas en bases de datos multidimensionales = Updates and view maintenance in multidimensional databases". Tesis Doctoral, Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales, 2001.https://hdl.handle.net/20.500.12110/tesis_n3331_Vaisman
Estadísticas:
Descargas totales desde :
Descargas mensuales
https://bibliotecadigital.exactas.uba.ar/download/tesis/tesis_n3331_Vaisman.pdf
