Applying UML and XML for designing and interchanging information for data warehouses and OLAP applications
Please use this identifier to cite or link to this item:
http://hdl.handle.net/10045/105209
Title: | Applying UML and XML for designing and interchanging information for data warehouses and OLAP applications |
---|---|
Authors: | Trujillo, Juan | Luján-Mora, Sergio | Song, Il-Yeol |
Research Group/s: | Lucentia | Advanced deveLopment and empIrical research on Software (ALISoft) |
Center, Department or Service: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Keywords: | Data warehouses | Multidimensional databases | OLAP | Conceptual modeling | UML | Object orientation | ODBMS | XML |
Knowledge Area: | Lenguajes y Sistemas Informáticos |
Issue Date: | Jan-2004 |
Publisher: | IGI Global |
Citation: | Journal of Database Management. 2004, 15(1): 41-72. doi:10.4018/jdm.2004010102 |
Abstract: | Multidimensional (MD) modeling is the basis for data warehouses (DW), multidimensional databases (MDB) and on-line analytical processing (OLAP) applications. In this paper, we present how the unified modeling language (UML) can be successfully used to represent both structural and dynamic properties of these systems at the conceptual level. The structure of the system is specified by means of a UML class diagram that considers the main properties of MD modeling with minimal use of constraints and extensions of the UML. If the system to be modeled is too complex, thereby leading us to a considerable number of classes and relationships, we describe how to use the package grouping mechanism provided by the UML to simplify the final model. Furthermore, we provide a UML-compliant class notation (called cube class) to represent OLAP users’ initial requirements. We also describe how we can use the UML state and interaction diagrams to model the behavior of a data warehouse system. To facilitate the interchange of conceptual MD models, we provide a Document Type Definition (DTD) which allows us to represent the same MD modeling properties that can be considered by using our approach. From this DTD, we can directly generate valid eXtensible Markup Language (XML) documents that represent MD models at the conceptual level. We believe that our innovative approach provides a theoretical foundation for simplifying the conceptual design of MD systems and the examples included in this paper clearly illustrate the use of our approach. |
URI: | http://hdl.handle.net/10045/105209 |
ISSN: | 1063-8016 (Print) | 1533-8010 (Online) |
DOI: | 10.4018/jdm.2004010102 |
Language: | eng |
Type: | info:eu-repo/semantics/article |
Rights: | © 2004, IGI Global |
Peer Review: | si |
Publisher version: | https://doi.org/10.4018/jdm.2004010102 |
Appears in Collections: | INV - LUCENTIA - Artículos de Revistas INV - ALISoft - Artículos de Revistas |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
Trujillo_etal_2004_JDatabaseManag_preprint.pdf | Preprint (acceso abierto) | 339,16 kB | Adobe PDF | Open Preview |
Trujillo_etal_2004_JDatabaseManag_final.pdf | Versión final (acceso restringido) | 980,9 kB | Adobe PDF | Open Request a copy |
Items in RUA are protected by copyright, with all rights reserved, unless otherwise indicated.