dblp.uni-trier.de www.dagstuhl.de www.uni-trier.de

The Role of Integrity Constraints in Database Interoperation.

Mark W. W. Vermeer, Peter M. G. Apers: The Role of Integrity Constraints in Database Interoperation. VLDB 1996: 425-435
@inproceedings{DBLP:conf/vldb/VermeerA96,
  author    = {Mark W. W. Vermeer and
               Peter M. G. Apers},
  editor    = {T. M. Vijayaraman and
               Alejandro P. Buchmann and
               C. Mohan and
               Nandlal L. Sarda},
  title     = {The Role of Integrity Constraints in Database Interoperation},
  booktitle = {VLDB'96, Proceedings of 22th International Conference on Very
               Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India},
  publisher = {Morgan Kaufmann},
  year      = {1996},
  isbn      = {1-55860-382-4},
  pages     = {425-435},
  ee        = {db/conf/vldb/VermeerA96.html},
  crossref  = {DBLP:conf/vldb/96},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

We present an approach to database interoperation that exploits the semantic information provided by integrity constraints defined on the component databases. We identify two roles of integrity constraints in database interoperation. First, a set of integrity constraints describing valid states of the integrated view can be derived from the constraints defined on the underlying databases. Moreover, local integrity constraints can be used as a semantic check on the validity of the specification of the integrated view. We illustrate our ideas in the context of an instance-based database interoperation paradigm, where objects rather than classes are the unit of integration. We introduce the notions of objectivity and subjectivity as an indication of whether a constraint is valid beyond the context of a specific database, and demonstrate the impact of these notions.

Copyright © 1996 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

T. M. Vijayaraman, Alejandro P. Buchmann, C. Mohan, Nandlal L. Sarda (Eds.): VLDB'96, Proceedings of 22th International Conference on Very Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India. Morgan Kaufmann 1996, ISBN 1-55860-382-4
Contents CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Electronic Edition

References

[AQF95]
R. M. Alzahrani, M. A. Qutaishat, N. J. Fiddian, W. A. Gray: Integrity Management in an Object-Oriented Federated Database Environment. BNCOD 1995: 226-248 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[BBZ93]
Herman Balsters, Rolf A. de By, Roberto Zicari: Typed Sets as a Basis for Object-Oriented Database Schemas. ECOOP 1993: 161-184 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[BLN86]
Carlo Batini, Maurizio Lenzerini, Shamkant B. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comput. Surv. 18(4): 323-364(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[CGW96]
Sudarshan S. Chawathe, Hector Garcia-Molina, Jennifer Widom: A Toolkit for Constraint Management in Heterogeneous Information Systems. ICDE 1996: 56-65 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DaH84]
Umeshwar Dayal, Hai-Yann Hwang: View Definition and Generalization for Database Integration in a Multidatabase System. IEEE Trans. Software Eng. 10(6): 628-645(1984) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DKM93]
Pamela Drew, Roger King, Dennis McLeod, Marek Rusinkiewicz, Abraham Silberschatz: Report of the Workshop on Semantic Heterogeneity and Interoperation in Multidatabase Systems. SIGMOD Record 22(3): 47-56(1993) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[FKS94]
Jan Flokstra, Maurice van Keulen, Jacek Skowronek: The IMPRESS DDT: A Database Design Toolbox Based on a Formal Specification Language. SIGMOD Conference 1994: 506 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GPQ95]
Hector Garcia-Molina, Dallan Quass, Yannis Papakonstantinou, Anand Rajaraman, Yehoshua Sagiv, Jeffrey D. Ullman, Jennifer Widom: The TSIMMIS Approach to Mediation: Data Models and Languages. NGITS 1995: 0- CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GrW96]
Paul W. P. J. Grefen, Jennifer Widom: Integrity Constraint Checking in Federated Databases. CoopIS 1996: 38-47 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[LSP93]
Ee-Peng Lim, Jaideep Srivastava, Satya Prabhakar, James Richardson: Entity Identification in Database Integration. ICDE 1993: 294-301 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RPG95]
M. P. Reddy, Bandreddi E. Prasad, Amar Gupta: Formulating Global Integrity Constraints During Derivation of Global Schema. Data Knowl. Eng. 16(3): 241-268(1995) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[ShL90]
Amit P. Sheth, James A. Larson: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Comput. Surv. 22(3): 183-236(1990) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[VeA96]
Mark W. W. Vermeer, Peter M. G. Apers: On the Applicability of Schema Integration Techniques to Database Interoperation. ER 1996: 179-194 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[VeA95]
Mark W. W. Vermeer, Peter M. G. Apers: Reverse Engineering of Relational Database Applications. OOER 1995: 89-100 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Referenced by

  1. Can Türker, Gunter Saake: Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration. ADBIS 1999: 31-45
  2. Mong-Li Lee, Tok Wang Ling: Resolving Constraint Conflicts in the Integration of Entity-Relationship Schemas. ER 1997: 394-407
  3. Mark W. W. Vermeer, Peter M. G. Apers: On the Applicability of Schema Integration Techniques to Database Interoperation. ER 1996: 179-194

Last update Fri Sep 14 17:38:20 2012 CET by the DBLP TeamThis material is Open Data Data released under the ODC-BY 1.0 license — See also our legal information page