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.
Preview
Unable to display preview. Download preview PDF.
References
S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases: Addison-Wesley, 1995.
S. Abiteboul and V. Vianu, “Equivalence and Optimization of Relational Transactions,” Journal of ACM, vol. 35, pp. 130–145, 1988.
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.
J. Biskup and B. Convent, “A Formal View Integration Method,” Proceedings of International Conference on the Management of Data, 1986.
L. Ekenberg and P. Johannesson, “Conflictfreeness as a Basis for Schema Integration,” Proceedings of CISMOD-95, pp. 1–13, 1995.
R. Hull, “Relative Information Capacity of Simple Relational Database Schemata,” SIAM Journal of Computing, vol. 15, pp. 856–886, 1986.
D. S. Johnson, “A Catalogue of Complexity Classes,” in Handbook of Theoretical Computer Science: Volume A, J. van Leeuwen, Ed. Amsterdam: Elsevier, 1990.
R. Miller, Y. Ioannidis, and R. Ramakrishnan, “Schema Equivalence in Heterogeneous Systems: Bridging Theory and Practice,” Information Systems, vol. 19, 1994.
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.
Author information
Authors and Affiliations
Editor information
Rights 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