Automatically Generating Database Schemas into OLAP Tools from Object-Oriented Conceptual Models
Juan Trujillo, Sergio Luján-Mora
International Conference on Computer Science, Software Engineering, Information Technology, e-Business, and Applications (CSITeA'02), p. 102-107, Foz do Iguazu (Brazil), June 6-8 2002.
(CSITEA'2002) Congreso internacional / International conference
Graphical conceptual models for OLAP applications should semi-automatically generate the database schema and the multidimensional (MD) model for a specific target commercial OLAP tool. However, this generation process is not immediate as the semantics represented by these conceptual models are different from those considered by the underlying MD models of OLAP tools. In this paper, we present an overview of this generation process from graphical conceptual modeling into target commercial OLAP tools. The conceptual model is accomplished by using an object-oriented approach, based on the Unified Modeling Language (UML), that allows us to represent both the MD model and initial users' requirements at the conceptual level. In this generation process, some semantics represented in the conceptual model are transformed into those considered by the underlying MD model of the target OLAP tool.