Model Transformations for Development of Object-Relational Databases

In this work we present an approach for Object-Relational (OR) Database (DB) Development in the framework of MIDAS, a model driven methodology for the development of Web Information Systems. In our proposal, the Platform Independent Model (PIM) is the conceptual data model. Starting from the PIM we obtain the Platform Specific Model (PSM), that is the OR model. Since in both cases the used notation is UML, the proposal includes also the corresponding UML profiles to represent the OR models (one for the SQL:2003 standard and another one for an specific product, Oracle 10g) This paper focuses on the formalization of the PIM to PSM mappings. In this way, we define the model transformations needed to obtain the DB schema (OR model) from the conceptual data model (PIM), first as rules defined in natural language to later express them by means of graph grammars.