ACM SIGMOD Anthology VLDB dblp.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}
}
BibTeX

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 ... BibTeX

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 BibTeX

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 BibTeX
[BBZ93]
Herman Balsters, Rolf A. de By, Roberto Zicari: Typed Sets as a Basis for Object-Oriented Database Schemas. ECOOP 1993: 161-184 BibTeX
[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) BibTeX
[CGW96]
Sudarshan S. Chawathe, Hector Garcia-Molina, Jennifer Widom: A Toolkit for Constraint Management in Heterogeneous Information Systems. ICDE 1996: 56-65 BibTeX
[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) BibTeX
[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) BibTeX
[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 BibTeX
[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- BibTeX
[GrW96]
Paul W. P. J. Grefen, Jennifer Widom: Integrity Constraint Checking in Federated Databases. CoopIS 1996: 38-47 BibTeX
[LSP93]
Ee-Peng Lim, Jaideep Srivastava, Satya Prabhakar, James Richardson: Entity Identification in Database Integration. ICDE 1993: 294-301 BibTeX
[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) BibTeX
[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) BibTeX
[VeA96]
Mark W. W. Vermeer, Peter M. G. Apers: On the Applicability of Schema Integration Techniques to Database Interoperation. ER 1996: 179-194 BibTeX
[VeA95]
Mark W. W. Vermeer, Peter M. G. Apers: Reverse Engineering of Relational Database Applications. OOER 1995: 89-100 BibTeX

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
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:12 2009