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

  • Juan Manuel Vara
  • Belén Vela
  • Verónica Andrea Bollati
  • Esperanza Marcos
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5563)


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.


Model-Driven Engineering Object-Relational Databases Model Transformations Code Generation 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Atzeni, P., Cappellari, P., Gianforme, G.: MIDST: model independent schema and data translation. In: Proceedings of the 2007 ACM SIGMOD international Conference on Management of Data. SIGMOD 2007, Beijing, China, June 11-14, pp. 1134–1136. ACM, New York (2007)CrossRefGoogle Scholar
  2. 2.
    Baresi, L., Heckel, R.: Tutorial Introduction to Graph Transformation: A Software Engineering Perspective. In: Corradini, A., Ehrig, H., Kreowski, H.-J., Rozenberg, G. (eds.) ICGT 2002. LNCS, vol. 2505, pp. 402–429. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  3. 3.
    Bernstein, P.A.: Applying Model Management to Classical Meta Data Problems. In: First Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA (2003)Google Scholar
  4. 4.
    Bertino, E., Marcos, E.: Object Oriented Database Systems. In: Díaz, O., Piattini, M. (eds.) Advanced Databases: Technology and Design. Artech House, Norwood (2000)Google Scholar
  5. 5.
    Bézivin, J.: Some Lessons Learnt in the Building of a Model Engineering Platform. In: 4th Workshop in Software Model Engineering (WISME), Montego Bay, Jamaica (2005)Google Scholar
  6. 6.
    Bézivin, J., et al.: Model Transformations in Practice Workshop. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 120–127. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  7. 7.
    Cáceres, P., De Castro, V., Vara, J.M., Marcos, E.: Model Transformations for Hypertext Modeling on Web Information Systems. In: SAC 2006. Proc. of the 2006 ACM Symposium on Applied Computing, pp. 1232–1239. ACM Press, New York (2006)Google Scholar
  8. 8.
    Chen, P.P.: The Entity-Relationship Model – Toward a Unified View of Data. ACM Transactions on Database Systems 1(1), 9–36 (1976)CrossRefGoogle Scholar
  9. 9.
    Fernández-Medina, E., Trujillo, J., Villarroel, R., Piattini, M.: Developing secure data warehouses with a UML extension. Information Systems 32, 826–856 (2007)CrossRefGoogle Scholar
  10. 10.
    ISO / IEC 9075-14:2008 Standard, Information Technology – Database Languages – SQL 2008, International Organization for Standardization (2008)Google Scholar
  11. 11.
    Jouault, F., Kurtev, I.: Transforming Models with ATL. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 128–138. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  12. 12.
    Marcos, E., Vela, B., Cavero, J.M.: Extending UML for Object-Relational Database Design. In: Gogolla, M., Kobryn, C. (eds.) UML 2001. LNCS, vol. 2185, pp. 225–239. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  13. 13.
    Marcos, E., Vela, B., Cáceres, P., Cavero, J.M.: MIDAS/DB: a Methodological Framework for Web Database Design. In: Arisawa, H., Kambayashi, Y., Kumar, V., Mayr, H.C., Hunt, I. (eds.) ER Workshops 2001. LNCS, vol. 2465, pp. 227–238. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  14. 14.
    Marjan, M., Jan, H., Anthony, M.S.: When and how to develop domain-specific languages. ACM Comput. Surv. 37, 316–344 (2005)CrossRefGoogle Scholar
  15. 15.
    Mazon, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: Proceedings of the 8th ACM international workshop on Datawarehousing and OLAP. ACM, Bremen (2005)Google Scholar
  16. 16.
    Muller, R.: Database Design for Smarties. Morgan Kaufmann, San Francisco (1999)Google Scholar
  17. 17.
    Naiburg, E.J., Maksimchuk, R.A.: UML for Database Design. Addison-Wesley, Reading (2001)Google Scholar
  18. 18.
    Oldevik, J., Neple, T., Grønmo, R., Aagedal, J., Berre, A.-J.: Toward Standardised Model to Text Transformations. In: Model-driven Architecture – Foundations and Applications, pp. 239–253 (2005)Google Scholar
  19. 19.
    Miller, J., Mukerji, J. (eds.): OMG. MDA Guide Version 1.0. Document number omg/2003-05-01 (retrieved 2003),
  20. 20.
    Oracle Corporation. Oracle Database 10g. Release 2 (10.2),
  21. 21.
    Selic, B.: The pragmatics of Model-Driven development. IEEE Software 20(5), 19–25 (2003)CrossRefGoogle Scholar
  22. 22.
    Stonebraker, M., Brown, P.: Object-Relational DBMSs. In: Tracking the Next Great Wave. Morgan Kauffman, San Francisco (1999)Google Scholar
  23. 23.
    Tonkunaite, J., Nemuraite, L., Paradauskas, B.: Model driven development of data warehouses. In: 7th International Baltic Conference on Databases and Information Systems, July 3-6, pp. 106–113 (2006)Google Scholar
  24. 24.
    Vara, J.M., De Castro, V., Marcos, E.: WSDL automatic generation from UML models in a MDA framework. International Journal of Web Services Practices 1(1,2), 1–12 (2005)Google Scholar
  25. 25.
    Voelter, M. MD* Best Practices (12/2008), January 10, 2009)

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Juan Manuel Vara
    • 1
  • Belén Vela
    • 1
  • Verónica Andrea Bollati
    • 1
  • Esperanza Marcos
    • 1
  1. 1.Kybele Research GroupRey Juan Carlos UniversityMadridSpain

Personalised recommendations