MISM: A Platform for Model-Independent Solutions to Model Management Problems

  • Paolo Atzeni
  • Luigi Bellomarini
  • Francesca Bugiotti
  • Giorgio Gianforme
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5880)


Model management is a metadata-based approach to database problems aimed at supporting the productivity of developers by providing schema manipulation operators.

Here we propose MISM (Model Independent Schema Management), a platform for model management offering a set of operators to manipulate schemas, in a manner that is both model-independent (in the sense that operators are generic and apply to schemas of different data models) and model-aware (in the sense that it is possible to say whether a schema is allowed for a data model). This is the first proposal for model management in this direction.

We consider the main operators in model management: merge, diff, and modelgen. These operators play a major role in solving various problems related to schema evolution (such as data integration, data exchange or forward engineering), and we show in detail a solution to a major representative of the class, the round-trip engineering problem.


model management model management operators roundtrip engineering model-independent schema and data translation 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Atzeni, P., Cappellari, P., Bernstein, P.A.: Modelgen: Model independent schema translation. In: ICDE Conference, pp. 1111–1112. IEEE Computer Society, Los Alamitos (2005)Google Scholar
  2. 2.
    Atzeni, P., Cappellari, P., Bernstein, P.A.: A multilevel dictionary for model management. In: Delcambre, L.M.L., Kop, C., Mayr, H.C., Mylopoulos, J., Pastor, Ó. (eds.) ER 2005. LNCS, vol. 3716, pp. 160–175. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  3. 3.
    Atzeni, P., Cappellari, P., Bernstein, P.A.: Model-independent schema and data translation. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 368–385. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  4. 4.
    Atzeni, P., Cappellari, P., Gianforme, G.: MIDST: model independent schema and data translation. In: SIGMOD Conference, pp. 1134–1136. ACM, New York (2007)CrossRefGoogle Scholar
  5. 5.
    Atzeni, P., Cappellari, P., Torlone, R., Bernstein, P.A., Gianforme, G.: Model-independent schema translation. VLDB J. 17(6), 1347–1370 (2008)CrossRefGoogle Scholar
  6. 6.
    Atzeni, P., Torlone, R.: Management of multiple models in an extensible database design tool. In: Apers, P.M.G., Bouzeghoub, M., Gardarin, G. (eds.) EDBT 1996. LNCS, vol. 1057, pp. 79–95. Springer, Heidelberg (1996)CrossRefGoogle Scholar
  7. 7.
    Bernstein, P., Haas, L., Jarke, M., Rahm, E., Wiederhold, G.: Panel: Is generic metadata management feasible? In: VLDB Conference, pp. 660–662 (2000)Google Scholar
  8. 8.
    Bernstein, P.A.: Applying model management to classical meta data problems. In: CIDR Conference, pp. 209–220 (2003)Google Scholar
  9. 9.
    Bernstein, P.A., Green, T.J., Melnik, S., Nash, A.: Implementing mapping composition. VLDB J. 17(2), 333–353 (2008)CrossRefGoogle Scholar
  10. 10.
    Bernstein, P.A., Halevy, A.Y., Pottinger, R.: A vision of management of complex models. SIGMOD Record 29(4), 55–63 (2000)CrossRefGoogle Scholar
  11. 11.
    Bernstein, P.A., Melnik, S.: Model management 2.0: manipulating richer mappings. In: SIGMOD Conference, pp. 1–12. ACM, New York (2007)CrossRefGoogle Scholar
  12. 12.
    Codd, E.: A relational model for large shared data banks. CACM 13(6), 377–387 (1970)zbMATHGoogle Scholar
  13. 13.
    Codd, E.: Relational database: A practical foundation for productivity. CACM 25(2), 109–117 (1982)Google Scholar
  14. 14.
    Curino, C., Moon, H.J., Zaniolo, C.: Graceful database schema evolution: the PRISM workbench. PVLDB 1(1), 761–772 (2008)Google Scholar
  15. 15.
    Fagin, R., Kolaitis, P., Popa, L., Tan, W.: Quasi-inverses of schema mappings. ACM Trans. Database Syst. 33(2), 1–52 (2008)CrossRefGoogle Scholar
  16. 16.
    Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336(1), 89–124 (2005)zbMATHCrossRefMathSciNetGoogle Scholar
  17. 17.
    Fagin, R., Kolaitis, P.G., Popa, L.: Data exchange: getting to the core. ACM Trans. Database Syst. 30(1), 174–210 (2005)CrossRefMathSciNetGoogle Scholar
  18. 18.
    Haas, L.M.: Beauty and the beast: The theory and practice of information integration. In: Schwentick, T., Suciu, D. (eds.) ICDT 2007. LNCS, vol. 4353, pp. 28–43. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  19. 19.
    Haas, L.M., Hernández, M.A., Ho, H., Popa, L., Roth, M.: Clio grows up: from research prototype to industrial tool. In: SIGMOD Conference, pp. 805–810. ACM, New York (2005)Google Scholar
  20. 20.
    Halevy, A.Y., Ashish, N., Bitton, D., Carey, M.J., Draper, D., Pollock, J., Rosenthal, A., Sikka, V.: Enterprise information integration: successes, challenges and controversies. In: SIGMOD Conference, pp. 778–787. ACM, New York (2005)Google Scholar
  21. 21.
    Hull, R., King, R.: Semantic database modelling: Survey, applications and research issues. ACM Computing Surveys 19(3), 201–260 (1987)CrossRefGoogle Scholar
  22. 22.
    McGee, W.C.: Generalization: Key to successful electronic data processing. J. ACM 6(1), 1–23 (1959)zbMATHCrossRefGoogle Scholar
  23. 23.
    Melnik, S.: Generic Model Management: Concepts and Algorithms. Springer, Heidelberg (2004)zbMATHGoogle Scholar
  24. 24.
    Miller, R.J., Haas, L.M., Hernández, M.A.: Schema mapping as query discovery. In: VLDB Conference, pp. 77–88 (2000)Google Scholar
  25. 25.
    Mork, P., Bernstein, P.A., Melnik, S.: Teaching a schema translator to produce O/R views. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 102–119. Springer, Heidelberg (2007)CrossRefGoogle Scholar
  26. 26.
    Papotti, P., Torlone, R.: Heterogeneous data translation through XML conversion. J. Web Eng. 4(3), 189–204 (2005)Google Scholar
  27. 27.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)zbMATHCrossRefGoogle Scholar
  28. 28.
    Velegrakis, Y., Miller, R.J., Popa, L.: Mapping adaptation under evolving schemas. In: VLDB Conference, pp. 584–595 (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Paolo Atzeni
    • 1
  • Luigi Bellomarini
    • 1
  • Francesca Bugiotti
    • 1
  • Giorgio Gianforme
    • 1
  1. 1.Dipartimento di informatica e automazioneUniversità Roma Tre 

Personalised recommendations