Supporting Model---Driven Development of Object---Relational Database Schemas: A Case Study

  • Authors:
  • Juan Manuel Vara;Belén Vela;Verónica Andrea Bollati;Esperanza Marcos

  • Affiliations:
  • Kybele Research Group, Rey Juan Carlos University, Madrid, Spain;Kybele Research Group, Rey Juan Carlos University, Madrid, Spain;Kybele Research Group, Rey Juan Carlos University, Madrid, Spain;Kybele Research Group, Rey Juan Carlos University, Madrid, Spain

  • Venue:
  • ICMT '09 Proceedings of the 2nd International Conference on Theory and Practice of Model Transformations
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper completes our proposal for automatic development of Object-Relational (OR) DataBase (DB) schemas. By means of a case study, this work focuses on presenting the tooling developed to support the whole process. As usual, the proposal starts from a conceptual data model (Platform Independent Model) depicted in a UML class diagram. Then, the conceptual data model is mapped into an OR DB model (Platform Specific Model) that represents the OR DB schema. To that end, we have implemented a set of formalized mapping rules using the ATL language. Finally, the SQL code that implements the modeled schema in Oracle 10g is automatically generated from the OR model by means of a MOFScript model to text transformation. Moreover, since the OR model could be refined along the design process, we have developed a graphical editor for OR DB models.