Skip to main content
Springer Nature Link
Log in

Data and Metadata Management

  • Chapter
  • First Online:
Semantic Web Information Management

  • 991 Accesses

Abstract

In this chapter, we illustrate fundamental notions of Data Management. We start from the basic concepts of database schema and instance, illustrating how they are handled within dictionaries in relational databases. We then address, from a general point of view, the notion of data model as a means for the representation of information at different levels of details, and show how dictionaries can be used to manage schemas of different data models. A further level of abstraction, called metamodel, is then introduced with the aim of supporting the interoperability between model based applications. Finally, we discuss a methodology for schema translation that makes use of the metamodel as an intermediate level.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web: From Relations to Semistructured Data and XML. Morgan Kauffman, San Mateo (1999)

    Google Scholar 

  2. Abiteboul, S., Cluet, S., Milo, T.: Correspondence and translation for heterogeneous data. Theor. Comput. Sci. 275(1–2), 179–213 (2002)

    Article  MATH  MathSciNet  Google Scholar 

  3. Atzeni, P., Bellomarini, L., Bugiotti, F., Gianforme, G.: From schema and model translation to a model management system. In: Sharing Data, Information and Knowledge, BNCOD 25. LNCS, vol. 5071, pp. 227–240. Springer, Berlin (2008)

    Chapter  Google Scholar 

  4. Atzeni, P., Cappellari, P., Bernstein, P.A.: A multilevel dictionary for model management. In: ER Conference. LNCS, vol. 3716, pp. 160–175. Springer, Berlin (2005)

    Google Scholar 

  5. Atzeni, P., Cappellari, P., Gianforme, G.: MIDST: model independent schema and data translation. In: SIGMOD Conference, pp. 1134–1136. ACM, New York (2007)

    Chapter  Google Scholar 

  6. Atzeni, P., Cappellari, P., Torlone, R., Bernstein, P.A., Gianforme, G.: Model-independent schema translation. VLDB J. 17(6), 1347–1370 (2008)

    Article  Google Scholar 

  7. Atzeni, P., Ceri, S., Paraboschi, S., Torlone, R.: Databases: Concepts, Languages and Architectures. McGraw-Hill, New York (1999)

    Google Scholar 

  8. Atzeni, P., Torlone, R.: Management of multiple models in an extensible database design tool. In: EDBT Conference. LNCS, vol. 1057, pp. 79–95. Springer, Berlin (1996)

    Google Scholar 

  9. Batini, C., Ceri, S., Navathe, S.: Database Design with the Entity-Relationship Model. Benjamin and Cummings, Redwood City (1991)

    Google Scholar 

  10. Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Comput. Surv. 18(4), 323–364 (1986)

    Article  Google Scholar 

  11. Bernstein, P.A.: Applying model management to classical meta data problems. In: CIDR Conference, pp. 209–220 (2003)

    Google Scholar 

  12. Bernstein, P.A., Halevy, A.Y., Pottinger, R.: A vision of management of complex models. SIGMOD Rec. 29(4), 55–63 (2000)

    Article  Google Scholar 

  13. Bernstein, P.A., Melnik, S.: Model management 2.0: manipulating richer mappings. In: SIGMOD Conference, pp. 1–12 (2007)

    Google Scholar 

  14. Bernstein, P.A., Rahm, E.: Data warehouse scenarios for model management. In: ER, pp. 1–15 (2000)

    Google Scholar 

  15. Bowers, S., Delcambre, L.M.L.: The Uni-Level Description: A uniform framework for representing information in multiple data models. In: ER Conference. LNCS, vol. 2813, pp. 45–58. Springer, Berlin (2003)

    Google Scholar 

  16. Ceri, S., Fraternali, P., Bongio, A., Brambilla, M., Comai, S., Matera, M.: Designing Data-Intensive Web Applications. Morgan Kauffman, San Mateo (2003)

    Google Scholar 

  17. Chen, P.: The entity-relationship model: Toward a unified view of data. ACM Trans. Database Syst. 1(1), 9–36 (1976)

    Article  Google Scholar 

  18. Cluet, S., Delobel, C., Siméon, J., Smaga, K.: Your mediators need data conversion! In: SIGMOD Conference, pp. 177–188 (1998)

    Google Scholar 

  19. ElMasri, R., Navathe, S.: Fundamentals of Database Systems, 5th edn. Addison-Wesley, Reading (2007)

    Google Scholar 

  20. Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336(1), 89–124 (2005)

    Article  MATH  MathSciNet  Google Scholar 

  21. Fagin, R., Kolaitis, P.G., Popa, L.: Data exchange: getting to the core. ACM Trans. Database Syst. 30(1), 174–210 (2005)

    Article  MathSciNet  Google Scholar 

  22. Florescu, D., Kossmann, D.: Storing and querying XML data using an rdmbs. IEEE Data Eng. Bull. 22(3), 27–34 (1999)

    Google Scholar 

  23. Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems: The Complete Book, 2nd edn. Prentice-Hall, Englewood Cliffs (2008)

    Google Scholar 

  24. Haas, L.M., Hernández, M.A., Ho, H., Popa, L., Roth, M.: Clio grows up: from research prototype to industrial tool. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Baltimore, Maryland, USA, June 14–16, 2005, pp. 805–810. ACM, New York (2005)

    Chapter  Google Scholar 

  25. Hull, R., King, R.: Semantic database modelling: Survey, applications and research issues. ACM Comput. Surv. 19(3), 201–260 (1987)

    Article  Google Scholar 

  26. Lenzerini, M.: Data integration: A theoretical perspective. In: PODS, pp. 233–246 (2002)

    Google Scholar 

  27. Madhavan, J., Halevy, A.Y.: Composing mappings among data sources. In: VLDB, pp. 572–583 (2003)

    Google Scholar 

  28. Melnik, S., Rahm, E., Bernstein, P.A.: Rondo: A programming platform for generic model management. In: Halevy, A.Y., Ives, Z.G., Doan, A. (eds.) SIGMOD Conference, pp. 193–204. ACM, New York (2003)

    Google Scholar 

  29. Miller, R.J., Haas, L.M., Hernández, M.A.: Schema mapping as query discovery. In: VLDB, pp. 77–88 (2000)

    Google Scholar 

  30. Pottinger, R., Bernstein, P.A.: Merging models based on given correspondences. In: VLDB, pp. 826–873 (2003)

    Google Scholar 

  31. Poulovassilis, A., McBrien, P.: A general formal framework for schema transformation. Data Knowl. Eng. 28(1), 47–71 (1998)

    Article  MATH  Google Scholar 

  32. Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)

    Article  MATH  Google Scholar 

  33. Ramakrishnan, R., Gehrke, J.: Database Management Systems, 3rd edn. McGraw-Hill, New York (2003)

    MATH  Google Scholar 

  34. Sheth, A., Larson, J.: Federated database systems for managing distributed database systems for production and use. ACM Comput. Surv. 22(3), 183–236 (1990)

    Article  Google Scholar 

  35. Shu, N.C., Housel, B.C., Taylor, R.W., Ghosh, S.P., Lum, V.Y.: Express: A data extraction, processing, and restructuring system. ACM Trans. Database Syst. 2(2), 134–174 (1977)

    Article  Google Scholar 

  36. Tsichritzis, D., Lochovski, F.: Data Models. Prentice-Hall, Englewood Cliffs (1982)

    Google Scholar 

  37. Zaniolo, C. (ed.): Special issue on Data Transformations. Data Eng. 22(1) (1999). IEEE Computer Society

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Università Roma Tre, Via della Vasca Navale 79, 00146, Rome, Italy

    Paolo Atzeni & Riccardo Torlone

Authors
  1. Paolo Atzeni
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Riccardo Torlone
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Paolo Atzeni .

Editor information

Editors and Affiliations

  1. Dipto. Informatica e Automazione, Università Roma Tre, Via della Vasca Navale 79, Roma, 00146, Italy

    Roberto de Virgilio

  2. Dipto. Ingegneria e Scienza, Università di Trento, Via Sommarive 14, Povo, 38100, Italy

    Fausto Giunchiglia

  3. Dipto. Elettronica e Informazione (DEI), Politecnico di Milano, Via Ponzio 34/5, Milano, 20133, Italy

    Letizia Tanca

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Atzeni, P., Torlone, R. (2010). Data and Metadata Management. In: de Virgilio, R., Giunchiglia, F., Tanca, L. (eds) Semantic Web Information Management. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-04329-1_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-04329-1_2

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-04328-4

  • Online ISBN: 978-3-642-04329-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics