Skip to main content

A formal basis for dynamic schema integration

  • Session 5: Integration
  • Conference paper
  • First Online:
Conceptual Modeling — ER '96 (ER 1996)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1157))

Included in the following conference series:

Abstract

We construct a framework for determining when two schemata can be meaningfully integrated. Intuitively, two schemata can be integrated if the rules of one of the schemata together with a set of integration assertions do not restrict the models of the other schema. We formalise this concept using the notion of conflictfreeness and shows how it can be used to ensure that the merging of two schemata results in an integrated schema with the same information capacity as the original ones. The problem of conflictfreeness is undecidable, and we outline how it can be addressed for finite domains and determine its complexity properties in this case. Our approach takes into account static as well as dynamic aspects of a schema, where the dynamics is modelled by means of the event concept. We introduce correspondence assertions for events that can be used to specify the equivalence of event combinations.

This work was partly performed within the project SDeLphi at Telia Research AB. It was also partly supported by the NUTEK project CISIS.

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

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases: Addison-Wesley, 1995.

    Google Scholar 

  2. S. Abiteboul and V. Vianu, “Equivalence and Optimization of Relational Transactions,” Journal of ACM, vol. 35, pp. 130–145, 1988.

    Google Scholar 

  3. C. Batini, M. Lenzerini, and S. B. Navathe, “A Comparative Analysis of Methodologies for Database Schema Integration,” ACM Computing Surveys, vol. 18, pp. 323–364, 1986.

    Google Scholar 

  4. J. Biskup and B. Convent, “A Formal View Integration Method,” Proceedings of International Conference on the Management of Data, 1986.

    Google Scholar 

  5. L. Ekenberg and P. Johannesson, “Conflictfreeness as a Basis for Schema Integration,” Proceedings of CISMOD-95, pp. 1–13, 1995.

    Google Scholar 

  6. R. Hull, “Relative Information Capacity of Simple Relational Database Schemata,” SIAM Journal of Computing, vol. 15, pp. 856–886, 1986.

    Google Scholar 

  7. D. S. Johnson, “A Catalogue of Complexity Classes,” in Handbook of Theoretical Computer Science: Volume A, J. van Leeuwen, Ed. Amsterdam: Elsevier, 1990.

    Google Scholar 

  8. R. Miller, Y. Ioannidis, and R. Ramakrishnan, “Schema Equivalence in Heterogeneous Systems: Bridging Theory and Practice,” Information Systems, vol. 19, 1994.

    Google Scholar 

  9. E. Simon, J. Kiernan, and C. de Mandreville,“Implementing High Level Active Rules on Top of a Relational DBMS,” Proceedings of International Conference on Very Large Data Bases, pp. 281–290, 1992.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Bernhard Thalheim

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ekenberg, L., Johannesson, P. (1996). A formal basis for dynamic schema integration. In: Thalheim, B. (eds) Conceptual Modeling — ER '96. ER 1996. Lecture Notes in Computer Science, vol 1157. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0019925

Download citation

  • DOI: https://doi.org/10.1007/BFb0019925

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-61784-6

  • Online ISBN: 978-3-540-70685-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics