Article

Free access

Extending a relational database with deferred referential integrity checking and intelligent joins

Authors:

Stephanie Cammarata,

Prasadram Ramachandra,

Darrell ShaneAuthors Info & Claims

SIGMOD '89: Proceedings of the 1989 ACM SIGMOD international conference on Management of data

Pages 88 - 97

https://doi.org/10.1145/67544.66935

Published: 01 June 1989 Publication History

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 (RIC) 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.

References

[1]

A1-Zobaidie, A. and Grimson, J. B., "Expert systems and database systems: how can they serve each other?," Expert Systems 4(1), pp.30-37 (February 1987).

[2]

Allen, F. W., Loomis, M. E., and Manning, M. V., "The integrated dictionary/directory system," ACM Computing Surveys 14(2), pp.245-286 (June 1982).

Digital Library

[3]

Blum, B. I., Diamond, S. D., Hammond, M. G., Perkins, M. E., and Semmel, R. D., "A intelligent navigational assistant for a decision resource database," pp. 19-25 in Proceedings of the third annual expert systems in government conference, Washington, DC (October 1987).

[4]

Cammarata, S. J., "An intelligent information dictionary for the semantic manipulation of relational databases," in Proceedings of the international conference extending database technology, Venice, Italy (1988).

Digital Library

[5]

Casanova, M. A. and Tucherman, L., "Enforcing inclusion dependencies and referential integrity," pp. 38-49 in Proceedings of the 14th international conference on very large data bases, Los Angeles (1988).

Digital Library

[6]

Curtice, R.M., "Data dictionaries: An assessment of current practice and problems," pp. 564-570 in Proceedings of 7th conference on very large data bases, Cannes, France (September 1981).

[7]

Dolk, D. and II, R. Kitsch, "A relational information resource dictionary system," Communications of the ACM 30(1), pp.48-61 (January 1987).

Digital Library

[8]

Gray, P., Storrs, G., and Boulay, J. du, "Knowledge representations for database metadata," Artificial Intelligence Review 2(1), pp.3-39 (1988).

[9]

Hatoun, T., Deferred vs. immediate checking for consistency of databases, Management Information Systems Week (June 6, 1988).

[10]

Hull, R. and King, R., "Semantic database modeling: Survey, applications, and research issues," ACM Computing Surveys 19(3), pp.201- 260 (September 1987).

Digital Library

[11]

Jones, P. and Shave, M., "A language for simple interactive retrieval from a database system," Data and Knowledge Engineering 2(4), pp.303-321 (1987).

Digital Library

[12]

Kossman, R., "An active information resource dictionary," in Proceedings of lngres user association meetings, San Francisco, CA (April 1987).

[13]

Lafue, G., "Semantic integrity dependencies and delayed integrity checking," pp. 292-299 in Proceedings of the 8th international conference on very large data bases, Los Angeles (1982).

Digital Library

[14]

Maier, D., Ullman, J. D., and Vardi, M. Y., "Equivalence of universal relation definitions," Report No. STAN-CS-82-940, Computer Science Dept, Stanford University (1982).

[15]

McCarthy, J.L., "Metadata management for large statistical databases," in Proceedings of 8th conference on very large databases (September 1982).

Digital Library

[16]

Navathe, S. and Kerschberg, L., "Role of dictionaries in information resource management," Information and Management 10(1), pp.21-46 (January 1986).

Digital Library

[17]

Neuhold, E. J. and Schrefl, M., "Dynamic derivation of personalized views," pp. 183-194 in Proceedings of the 14th international conference on very largedatabases, Los Angeles (1988).

Digital Library

[18]

Rehak, D. R. and Howard, H. C., "Interfacing expert systems with design databases in integrated CAD systems," Computer Aided Design (November 1985).

[19]

Schur, S., "Intelligent databases," Database Progranuning and Design 1(6), pp.46-53 (June 1988).

[20]

Stonebraker, M. and Rowe, L.A., "The design of POSTGRES," Memorandum No. UCB/ERL 85/95, University of California, Berkeley, Berkeley, CA (November 15, 1985).

[21]

Tou, F. N., Williams, M. D., Fikes, R., Henderson, A., and Malone, T., "Rabbit: An intelligent database assistant," pp. 314-318 in Proceedings of the third annual national conference on artificial intelligence, Pittsburg (1982).

Cited By

Ordonez CGarcía-García J(2008)Referential integrity quality metricsDecision Support Systems10.5555/1322568.132264444:2(495-508)Online publication date: 1-Jan-2008
https://dl.acm.org/doi/10.5555/1322568.1322644
Ruiz-Fuertes MMuñoz-Escoí FDecker HArmendáriz-Iñigo JMendívil J(2008)Integrity Dangers in Certification-Based Replication ProtocolsProceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS10.1007/978-3-540-88875-8_118(924-933)Online publication date: 9-Nov-2008
https://dl.acm.org/doi/10.1007/978-3-540-88875-8_118
Muñoz-Escoí FRuiz-Fuertes MDecker HArmendáriz-Íñigo JMendívil J(2008)Extending Middleware Protocols for Database Replication with Integrity SupportProceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part I on On the Move to Meaningful Internet Systems:10.1007/978-3-540-88871-0_43(607-624)Online publication date: 9-Nov-2008
https://dl.acm.org/doi/10.1007/978-3-540-88871-0_43
Show More Cited By

Index Terms

Extending a relational database with deferred referential integrity checking and intelligent joins
1. Human-centered computing
  1. Human computer interaction (HCI)
2. Information systems
  1. Data management systems
    1. Database design and models
  2. Information retrieval
    1. Document representation
      1. Dictionaries

Recommendations

Referential integrity
VLDB '81: Proceedings of the seventh international conference on Very Large Data Bases - Volume 7

The problem of referential integrity is discussed and a proposal for dealing with it in a relational framework is described in some detail. The proposal is consistent with a more general integrity scheme also sketched briefly in the paper. The ...
Extending a relational database with deferred referential integrity checking and intelligent joins

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 ...
The semantics of an extended referential integrity for a multilevel secure relational data model

To prevent information leakage in multilevel secure data models, the concept of polyinstantiation was inevitably introduced. Unfortunately, when it comes to references through foreign key in multilevel relational data models, the polyinstantiation ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '89: Proceedings of the 1989 ACM SIGMOD international conference on Management of data

June 1989

451 pages

ISBN:0897913175

DOI:10.1145/67544

ACM SIGMOD Record Volume 18, Issue 2
June 1989
442 pages
ISSN:0163-5808
DOI:10.1145/66926
Editors:
James Clifford,
Bruce Lindsay,
David Maier
Issue’s Table of Contents

Copyright © 1989 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1989

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD/PODS04

Sponsor:

SIGMOD

SIGMOD/PODS04: International Conference on Management of Data and Symposium on Principles Database and Systems

Oregon, Portland, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
672
Total Downloads

Downloads (Last 12 months)112
Downloads (Last 6 weeks)19

Reflects downloads up to 25 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Ordonez CGarcía-García J(2008)Referential integrity quality metricsDecision Support Systems10.5555/1322568.132264444:2(495-508)Online publication date: 1-Jan-2008
https://dl.acm.org/doi/10.5555/1322568.1322644
Ruiz-Fuertes MMuñoz-Escoí FDecker HArmendáriz-Iñigo JMendívil J(2008)Integrity Dangers in Certification-Based Replication ProtocolsProceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS10.1007/978-3-540-88875-8_118(924-933)Online publication date: 9-Nov-2008
https://dl.acm.org/doi/10.1007/978-3-540-88875-8_118
Muñoz-Escoí FRuiz-Fuertes MDecker HArmendáriz-Íñigo JMendívil J(2008)Extending Middleware Protocols for Database Replication with Integrity SupportProceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part I on On the Move to Meaningful Internet Systems:10.1007/978-3-540-88871-0_43(607-624)Online publication date: 9-Nov-2008
https://dl.acm.org/doi/10.1007/978-3-540-88871-0_43
Jin BEmbury S(2004)Reducing Disruption in Time-Tabled Condition MonitoringIntegrity and Internal Control in Information Systems VI10.1007/1-4020-7901-X_11(159-176)Online publication date: 2004
https://doi.org/10.1007/1-4020-7901-X_11
Caine NEmbury S(2001)LOIS: The “Lights Out” Integrity SubsystemAdvances in Databases10.1007/3-540-45754-2_5(57-74)Online publication date: 22-Jun-2001
https://doi.org/10.1007/3-540-45754-2_5
Reimers PChung S(1993)Automatic logical navigation for relational databasesProceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice10.1145/162754.162920(343-350)Online publication date: 1-Mar-1993
https://dl.acm.org/doi/10.1145/162754.162920

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents