Skip to main content
SpringerLink
Log in

Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration

  • Conference paper
  • First Online:
Advances in Databases and Information Systems (ADBIS 1999)

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

Abstract

Schema integration is a main step in the database integration process. Since the semantics of a schema is also determined by its integrity constraints, a correct and complete schema integration has to deal with integrity constraints existing in the di.erent schemas to be integrated. In this paper, we present a framework for the correct handling of integrity constraints during schema integration. In particular, we work out the correspondence between local integrity constraints and global extensional assertions. The knowledge about the correspondences between the underlying integrity constraints and extensional assertions can then be utilized for an augmented schema integration process.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. R. M. Alzahrani, M. A. Qutaishat, N. J. Fiddian, and W. A. Gray. Integrity Merging in an Object-Oriented Federated Database Environment. In C. Goble and J. Keane, eds., Proc. BNCOD-13, LNCS 940, pp. 226–248. Springer, 1995.

    Google Scholar 

  2. C. Batini, M. Lenzerini, and S. B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323–364, 1986.

    Article  Google Scholar 

  3. S. Conrad, I. Schmitt, and C. Türker. Considering Integrity Constraints During Federated Database Design. In S. M. Embury, N. J. Fiddian, A. W. Gray, and A. C. Jones, eds., Proc. BNCOD-16, LNCS 1405, pp. 119–133. Springer, 1998.

    Google Scholar 

  4. M. Garcia-Solaco, M. Castellanos, and F. Saltor. A Semantic-Discriminated Approach to Integration in Federated Databases. In S. Laufmann, S. Spaccapietra, and T. Yokoi, eds., Proc. CoopIS’95, pp. 19–31, 1995.

    Google Scholar 

  5. M. Garcia-Solaco, F. Saltor, and M. Castellanos. Semantic Heterogeneity in Multidatabase Systems. In O. A. Bukhres and A. K. Elmagarmid, eds., Object-Oriented Multidatabase Systems, pp. 129–202, Prentice Hall, 1996.

    Google Scholar 

  6. R. Hull. Relative Information Capacity of Simple Relational Database Schemata. SIAM Journal on Computing, 15(3):856–886, 1986.

    Article  MathSciNet  Google Scholar 

  7. J. A. Larson, S. B. Navathe, and R. Elmasri. A Theory of Attribute Equivalence in Databases with Application to Schema Integration. IEEE Transactions on Software Engineering, 15(4):449–463, 1989.

    Article  Google Scholar 

  8. M. V. Mannino, B. N. Navathe, and W. Effelsberg. A Rule-based Approach for Merging Generalization Hierarchies. Information Systems, 13(3):257–272, 1988.

    Article  Google Scholar 

  9. A. Motro. Superviews: Virtual Integration of Multiple Databases. IEEE Transactions on Software Engineering, 13(7):785–798, 1987.

    Article  Google Scholar 

  10. S. B. Navathe, R. Elmasri, and J. A. Larson. Integrating User Views in Database Design. IEEE Computer, 19(1):50–62, 1986.

    Article  Google Scholar 

  11. M. P. Reddy, B. E. Prasad, and A. Gupta. Formulating Global Integrity Constraints during Derivation of Global Schema. Data & Knowledge Engineering, 16(3):241–268, 1995.

    Article  Google Scholar 

  12. I. Schmitt and G. Saake. Merging Inheritance Hierarchies for Database Integration. In M. Halper, ed., Proc. CoopIS’98, pp. 322–331. IEEE CS Press, 1998.

    Google Scholar 

  13. A. P. Sheth and J. A. Larson. Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22(3):183–236, 1990. 31

    Article  Google Scholar 

  14. S. Spaccapietra, C. Parent, and Y. Dupont. Model Independent Assertions for Integration of Heterogeneous Schemas. The VLDB Journal, 1(1):81–126, 1992.

    Article  Google Scholar 

  15. C. Türker and G. Saake. Deriving Relationships between Integrity Constraints for Schema Comparison. In W. Litwin, T. Morzy, and G. Vossen, eds., Proc. ADBIS’98, LNCS 1475, pp. 188–199. Springer, 1998.

    Google Scholar 

  16. M. W. W. Vermeer and P. M. G. Apers. The Role of Integrity Constraints in Database Interoperation. In T. M. Vijayaraman, A. P. Buchmann, C. Mohan, and N. L. Sarda, eds., Proc. VLDB’96, pp. 425–435. Morgan Kaufmann, 1996.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. ITI, Otto-von-Guericke-Universität Magdeburg, Postfach 4120, D-39016, Magdeburg, Germany

    Can Türker & Gunter Saake

Authors
  1. Can Türker
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Gunter Saake
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Faculty of Economics, Business Administration and Informatics, University of Klagenfurt, Uiversitätsstr. 65-67, 9020, Klagenfurt, Austria

    Johann Eder

  2. Faculty of Electrical Engineering and Computer Science, University of Maribor, Smetanova 17, 2000, Maribor, Slovenia

    Ivan Rozman  & Tatjana Welzer  & 

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Türker, C., Saake, G. (1999). Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration. In: Eder, J., Rozman, I., Welzer, T. (eds) Advances in Databases and Information Systems. ADBIS 1999. Lecture Notes in Computer Science, vol 1691. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48252-0_3

Download citation

  • DOI: https://doi.org/10.1007/3-540-48252-0_3

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66485-7

  • Online ISBN: 978-3-540-48252-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation