ACM SIGMOD Anthology ACM SIGMOD dblp.uni-trier.de

Extendeing a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins.

Stephanie J. Cammarata, Prasadram Ramachandra, Darrell Shane: Extendeing a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins. SIGMOD Conference 1989: 88-97
@inproceedings{DBLP:conf/sigmod/CammarataRS89,
  author    = {Stephanie J. Cammarata and
               Prasadram Ramachandra and
               Darrell Shane},
  editor    = {James Clifford and
               Bruce G. Lindsay and
               David Maier},
  title     = {Extendeing a Relational Database with Deferred Referential Integrity
               Checking and Intelligent Joins},
  booktitle = {Proceedings of the 1989 ACM SIGMOD International Conference on
               Management of Data, Portland, Oregon, May 31 - June 2, 1989},
  publisher = {ACM Press},
  year      = {1989},
  pages     = {88-97},
  ee        = {http://doi.acm.org/10.1145/67544.66935, db/conf/sigmod/CammarataRS89.html},
  crossref  = {DBLP:conf/sigmod/89},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

Interactive use of relational database management systems (DBMS) requires a user to be knowledgeable about the semantics of the application represented in the database. In many cases, however, users are not trained in the application field and are not DBMS experts. Two categories of functionality are problematic for such users: (1) updating a database without violating integrity constraints imposed by the domain and (2) using join operations to retrieve data from more than one relation. We have been conducting research to help an uninformed or casual user interact with a relational DBMS.

This paper describes two capabilities to aid an interactive database user who is neither an application specialist nor a DBMS expert. We have developed deferred Referential Integrity Checking (RIG) and Intelligent Join (IJ) which extend the operations of a relational DBMS. These facilities are made possible by explicit representation of database semantics combined with a relational schema. Deferred RIC is a static validation procedure that checks uniqueness of tuples, non-null keys, uniqueness of keys, and inclusion dependencies. IJ allows a user to identify only the "target" data which is to be retrieved without the need to additionally specify "join clauses". In this paper we present the motivation for these facilities, describe the features of each, and present examples of their use.

Copyright © 1989 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.


ACM SIGMOD Anthology

Online Version (ACM WWW Account required): Full Text in PDF Format

CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

James Clifford, Bruce G. Lindsay, David Maier (Eds.): Proceedings of the 1989 ACM SIGMOD International Conference on Management of Data, Portland, Oregon, May 31 - June 2, 1989. ACM Press 1989 BibTeX , SIGMOD Record 18(2), June 1989
Contents

Online Edition: ACM Digital Library


References

[AI-Z87]
...
[Alle82]
Frank W. Allen, Mary E. S. Loomis, Michael V. Mannino: The Integrated Dictionary/Directory System. ACM Comput. Surv. 14(2): 245-286(1982) BibTeX
[Blum87]
...
[Camm88]
Stephanie J. Cammarata: An Intelligent Information Dictionary for Semantic Manipulation of Relational Databases. EDBT 1988: 214-230 BibTeX
[Casa88]
Marco A. Casanova, Luiz Tucherman, Antonio L. Furtado: Enforcing Inclusion Dependencies and Referencial Integrity. VLDB 1988: 38-49 BibTeX
[Curt81]
Robert M. Curtice: Data Dictionaries: An Assessment of Current Practice and Problems. VLDB 1981: 564-570 BibTeX
[Dolk87]
Daniel R. Dolk, Robert A. Kirsch II: A Relational Information Resource Dictionary System. Commun. ACM 30(1): 48-61(1987) BibTeX
[Gray88]
...
[Hato88]
...
[Hull87]
Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987) BibTeX
[Jone87]
Perry Jones, Michael J. R. Shave: A Language for Simple Interactive Retrieval from a Database System. Data Knowl. Eng. 2: 303-321(1987) BibTeX
[Koss87]
...
[Lafu82]
Gilles M. E. Lafue: Semantic Integrity Dependencies and Delayed Integrity Checking. VLDB 1982: 292-299 BibTeX
[Maie82]
...
[McCa82]
John L. McCarthy: Metadata Management for Large Statistical Databases. VLDB 1982: 234-243 BibTeX
[Nava86]
...
[Neuh88]
Erich J. Neuhold, Michael Schrefl: Dynamic Derivation of Personalized Views. VLDB 1988: 183-194 BibTeX
[Reha85]
...
[Schu88]
...
[Ston85]
Michael Stonebraker, Lawrence A. Rowe: The Design of Postgres. SIGMOD Conference 1986: 340-355 BibTeX
[Tou82]
Frederich N. Tou, Michael D. Williams, Richard Fikes, D. Austin Henderson Jr., Thomas W. Malone: RABBIT: An Intelligent Database Assistant. AAAI 1982: 314-318 BibTeX

Referenced by

  1. Priti Mishra, Margaret H. Eich: Join Processing in Relational Databases. ACM Comput. Surv. 24(1): 63-113(1992)
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
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:39:57 2009