Model transformation for object-relational database development

ABSTRACT

In this paper we define and formalize the model transformations that complete the methodological approach for the development of Object-Relational (OR) Databases (DB) proposed in MIDAS, a model driven methodology for the development of Web Information Systems. In this proposal the Platform Independent Model is the conceptual data model while the Platform Specific Model is the Object-Relational model that represents the OR DB schema. Since both of them will be represented in UML, we also summarize an UML profile for OR DB modeling. In this work we focus on the formalization of the mappings needed to get the OR DB schema from the conceptual data model. We have first specified them with natural language to later formalize them with graph transformation rules.

REFERENCES

• 1: S. Ambler, Agile Database Techniques. Wiley, 2003.
• 2: P. Atzeni, S. Ceri, S. Paraboschi and R. Torlone, Database Systems. Concepts, Languages and Architectures McGraw-Hill, 1999.
• 3: E. Bertino and E. Marcos, Object Oriented Database Systems. In: Advanced Databases: Technology and Design, O. Díaz and M. Piattini (Eds.). Artech House, 2000.
• 4: F. Buttner and M. Gogolla Realizing UML Metamodel Transformations with AGG, Proceedings of GT-VMT. Electronic Notes in Theoretical Computer Science. Vol. 109, December 2004, pp. 31--42. 2004.
• 5: Paloma Cáceres , Valeria de Castro , Juan M. Vara , Esperanza Marcos, Model transformations for hypertext modeling on web information systems, Proceedings of the 2006 ACM symposium on Applied computing, April 23-27, 2006, Dijon, France [doi>10.1145/1141277.1141567]
• 6: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 7: György Csertán , Gábor Huszerl , István Majzik , Zsigmond Pap , András Pataricza , Dániel Varró, VIATRA " Visual Automated Transformations for Formal Verification and Validation of UML Models, Proceedings of the 17th IEEE international conference on Automated software engineering, p.267, September 23-27, 2002
• 8: J. De Lara, H. Vangheluwe and M. Alfonseca, Meta-Modelling and Graph Grammars for Multi-Paradigm Modelling in AToM3, Software and Systems Modelling, Vol 3(3), Springer-Verlag. August 2004, pp.: 194--209.
• 9: H. Ehrig, G. Engels, H.-J. Kreowski, and G. Rozenberg. Handbook of Graph Grammars and Computing by Graph Transformation. Vol(1). World Scientific, 1999.
• 10: K. Ehrig, E. Guerra, J. de Lara, L. Lengyel, T. Levendovszky, U. Prange, G. Taentzer, D. Varró, and S. Varró-Gyapay, Model Transformation by Graph Transformation: A Comparative Study, in: Proc. of Model Transformations in Practice Workshop, at MoDELS Conference, Montego Bay, Jamaica, 2005.
• 11: IBM DB2 Universal Database. http://www-306.ibm.com/software/data/db2/
• 12: ISO / IEC 9075 Standard, Information Technology -- Database Languages -- SQL:2003, International Organization for Standardization, 2003.
• 13: F. Jouault and I. Kurtev, Transforming Models withATL, in: Proc. of the Model Transformations in Practice Workshop at MoDELS Conference, Montego Bay, Jamaica. 2005.
• 14: Esperanza Marcos , B. Vela , José María Cavero, Extending UML for Object-Relational Database Design, Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools, p.225-239, October 01-05, 2001
• 15: Esperanza Marcos , P. Cáceres , B. Vela , José María Cavero, MIDAS/BD: A Methodological Framework for Web Database Design, Revised Papers from the HUMACS, DASWIS, ECOMO, and DAMA on ER 2001 Workshops, p.227-238, November 27-30, 2001
• 16: Microsoft SQL Server, http://www.microsoft.org/sql/
• 17: J. Miller and J. Mukerji (eds.), MDA Guide Version 1.0.1, OMG, Framingham, Massachusetts, June 2003.
• 18: Robert J. Muller, Database design for smarties: using UML for data modeling, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1999
• 19: Eric J. Nailburg , Robert A. Maksimchuk , Robert A. Maksimchuck, UML for Database Design, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 2001
• 20: Oracle Corporation. Oracle 10g Release 2 (10.2). SQL Reference. In www.oracle.com, 2005.
• 21: Bran Selic, The Pragmatics of Model-Driven Development, IEEE Software, v.20 n.5, p.19-25, September 2003 [doi>10.1109/MS.2003.1231146]
• 22: Michael Stonebraker , Dorothy Moore , Paul Brown, Object-Relational DBMSs: Tracking the Next Great Wave, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1998
• 23: J. M. Vara, V. De Castro and E. Marcos, WSDL automatic generation from UML models in a MDA framework, in: International Journal of Web Services Practices. Volume 1 -- Issue 1 & 2. November 2005, pp. 1--12. 2005.
• 24: B. Vela, C. Acuña and E. Marcos, A Model Driven Approach for XML Database Development, 23^rd. International Conference on Conceptual Modelling Springer Verlag, LNCS 3288, pp. 780--794. 2004.
• 25: Torben Weis , Andreas Ulbrich , Kurt Geihs, Model Metamorphosis, IEEE Software, v.20 n.5, p.46-51, September 2003 [doi>10.1109/MS.2003.1231151]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models

Additional Classification:
  I. Computing Methodologies
  I.6 SIMULATION AND MODELING
      I.6.5 Model Development
          Subjects: Modeling methodologies

General Terms:
Design, Languages, Standardization

Keywords:
formalization, graph transformation, model transformation, object-relational databases