Integrated Model-Based Software Development, Data Access, and Data Migration

  • Behzad Bordbar
  • Dirk Draheim
  • Matthias Horn
  • Ina Schulz
  • Gerald Weber
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3713)


In this paper we describe a framework for robust system maintenance that addresses specific challenges of data-centric applications. We show that for data-centric applications, classical simultaneous roundtrip engineering approaches are not sufficient. Instead we propose an architecture that is an integrated model-based approach for software development, database access and data migration. We explain the canonical development process to exploit its features. We explain how the approach fits into the model-driven architecture vision. We report on experiences with the approach in the IMIS environmental mass database project.


Model Transformation Database Schema Data Migration Model Drive Architecture Persistent Data 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Balsters, H.: Modelling Database Views with Derived Classes in the UML/OCL-Framework. In: UML, pp. 295–309 (2003)Google Scholar
  2. 2.
    Banerjee, J., Kim, W., Kim, H.-J., Korth, H.F.: Semantics and Implementation of Schema Evolution in Object-Oriented Databases. ACM SIGMOD Record 15(4) (February 1987)Google Scholar
  3. 3.
    Chikofsky, E.J., Cross, J.H.: Reverse Engineering and Design Recovery: A Taxonomy. IEEE Software, 13–17 (January 1990)Google Scholar
  4. 4.
    Coleman, D., Ash, D., Lowther, B., Oman, P.: Using Metrics to Evaluate Software System Maintainability. IEEE Computer 27(8), 44–49 (1994)Google Scholar
  5. 5.
    Colleen, G.: DBMS Software Market: Flat but Not Calm, Dataquest Alert. Gartner Group (May 2002) Google Scholar
  6. 6.
    Czarnecki, K., Helsen, S.: Classification of Model Transformation Approaches. In: 2nd OOPSLA Workshop on Generative Techniques in the context of Model Driven Architecture (2003)Google Scholar
  7. 7.
    Draheim, D., Horn, M., Schulz, I.: The Schema Evolution and Data Migration Framework of the Environmental Mass Database IMIS. In: Proceedings of SSDBM 2004 - 16th International Conference on Scientific and Statistical Database Management, IEEE Press, Los Alamitos (2004)Google Scholar
  8. 8.
    Ferrandina, F., Lautermann, S.-E.: An Integrated Approach to Schema Evolution for Object Databases. In: 3rd International Conference on Object-Oriented Information Systems, pp. 280–294. Springer, Heidelberg (1996)Google Scholar
  9. 9.
    Horn, M., Triestram, V., van Nouhuys, J.: Data Evaluation Using the Generic Selection Component of the New IMIS System. In: EnviroInfo 2003 - 17th International Conference Informatics for Environmental Protection, Metropolis (2003)Google Scholar
  10. 10.
    Banerjee, J., Chou, H., Garza, J., Kim, W., Woelk, D., Ballou, N.: Data Model Issues for Object-Oriented Applications. ACM Transactions on Information Systems 5(1) (January 1987)Google Scholar
  11. 11.
    Kurtev, I., van den Berg, K.: Unifying Approach for Model Transformations in the MOF Metamodeling Architecture. In: 1st European MDA Workshop, University of Twente (March 2004)Google Scholar
  12. 12.
    Lerner, B.S.: A Model for Compound Type Changes Encountered in Schema Evolution. ACM Transactions on Database Systems 25(1), 83–127 (2000)CrossRefGoogle Scholar
  13. 13.
    Lerner, B.S., Nico Habermann, A.: Beyond Schema Evolution to Database Reorganization. SIGPLAN Notices 25(10), 67–76 (1990)CrossRefGoogle Scholar
  14. 14.
    Marcos, E., Vela, B., Cavero, J.M.: Extending UML for Object-Relational Database Design. In: UML, pp. 225–239 (2001)Google Scholar
  15. 15.
    Markowitz, V.M., Makowsky, J.A.: Incremental Reorganization of Relational Databases. In: 13th International Conference on Very Large Data Bases, pp. 127–135. Morgan Kaufmann, San Francisco (1987)Google Scholar
  16. 16.
    Miller, J., Mukerji, J.: MDA Guide Version 1.0.1. Technical Report omg/2003- 06-01, Object Managment Group (2003)Google Scholar
  17. 17.
    Miller, R.J., Haas, L.M., Hernandez, M.: Schema Mapping as Query Discovery. In: Proceedings of the International Conference on Very Large Data Bases, pp. 77–88. Morgan Kaufmann, San Francisco (2000)Google Scholar
  18. 18.
    Miller, R.J., Hernández, M.A., Haas, L.M., Yan, L., Howard Ho, C.T., Fagin, R., Popa, L.: The Clio Project: Managing Heterogeneity. SIGMOD Record (ACM Special Interest Group on Management of Data) 30(1), 78–83 (2001)Google Scholar
  19. 19.
    Nytun, J.P., Jensen, C.S.: Modeling and Testing Legacy Data Consistency Requirements. In: UML, pp. 341–355 (2003)Google Scholar
  20. 20.
    Ra, Y.-G., Rundensteiner, E.A.: A Transparent Object-Oriented Schema Change Approach Using View Evolution. In: 11th IEEE International Conference on Data Engineering, IEEE Press, Los Alamitos (1995)Google Scholar
  21. 21.
    Rahm, E., Bernstein, P.A.: A Survey of Approaches to Automatic Schema Matching. VLDB Journal: Very Large Data Bases 10, 334–350 (2001)zbMATHCrossRefGoogle Scholar
  22. 22.
    Roddick, J.: A Survey of Schema Versioning Issues for Database Systems. Information and Software Technology 37(7), 383–393 (1995)CrossRefGoogle Scholar
  23. 23.
    Shah, D., Slaughter, S.: Transforming UML Class Diagrams into Relational Data Models. In: UML and the Unified Process, pp. 217–236. Idea Group Publishing (2003)Google Scholar
  24. 24.
    Sockut, G.H., Goldberg, R.P.: Database Reorganization - Principles and Practice. ACM Computing Surveys 11(4), 371–395 (1979)CrossRefGoogle Scholar
  25. 25.
    Soley, R.: Model Driven Archtitecture, white paper formal/02-04-03, draft 3.2. Object Managment Group (November 2003) Google Scholar
  26. 26.
    Sterto, R.: White Paper: Persistent Data Development Tools Validate the Model Driven Architecture Approach. Technical report, Progress Software Corporation (2004) Google Scholar
  27. 27.
    Türker, C.: Schema Evolution in SQL-99 and Commercial (Object-)Relational DBMS. In: Balsters, H., De Brock, B., Conrad, S. (eds.) FoMLaDO 2000 and DEMM 2000. LNCS, vol. 2065, p. 1. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  28. 28.
    Van Doren, E.: Maintenance of Operational Systems - An Overview. In: Software technology Roadmap, Carnegie Mellon Software Engineering Institute (1997)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • Behzad Bordbar
    • 1
  • Dirk Draheim
    • 2
  • Matthias Horn
    • 3
  • Ina Schulz
    • 3
  • Gerald Weber
    • 4
  1. 1.School of Computer ScienceUniversity of BirminghamEdgbaston, BirminghamUK
  2. 2.Institute of Computer ScienceFreie Universität BerlinBerlinGermany
  3. 3.IMIS ProjektCondat AGBerlinGermany
  4. 4.Department of Computer ScienceThe University of AucklandAucklandNew Zealand

Personalised recommendations