ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Using Integrity Constraints to Provide Intensional Answers to Relational Queries.

Amihai Motro: Using Integrity Constraints to Provide Intensional Answers to Relational Queries. VLDB 1989: 237-246
@inproceedings{DBLP:conf/vldb/Motro89,
  author    = {Amihai Motro},
  editor    = {Peter M. G. Apers and
               Gio Wiederhold},
  title     = {Using Integrity Constraints to Provide Intensional Answers to
               Relational Queries},
  booktitle = {Proceedings of the Fifteenth International Conference on Very
               Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands},
  publisher = {Morgan Kaufmann},
  year      = {1989},
  isbn      = {1-55860-101-5},
  pages     = {237-246},
  ee        = {db/conf/vldb/Motro89.html},
  crossref  = {DBLP:conf/vldb/89},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

An intensional answer to a query is a set of characterizations of the set of database values that satisfy the query (the extensional answer). Intensional answers provide users with additional insight into the nature of standard extensional answers. In this paper we describe a method that applies database constraints to generate intensional answers. These intensional answers characterize the extensional answers in two ways: (1) with constraints that are applicable to the extensional answer, and (2) with database views that are contained entirely in the extensional answer. Our method is to represent the definitions of constraints in special "meta-relations", and extend standard algebraic operators to these relations. When a query is presented to the database system, it is performed both on the actual relations, resulting in an extensional answer, andon the meta-relations, resulting in definitions of constraints that apply to the extensional answer, as well as database views that are contained entirely in the extensional answer. These definitions are translated into an intensional answer that accompanies the extensional answer.

Copyright © 1989 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

Peter M. G. Apers, Gio Wiederhold (Eds.): Proceedings of the Fifteenth International Conference on Very Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands. Morgan Kaufmann 1989, ISBN 1-55860-101-5
BibTeX

References

[1]
Laurence Cholvy, Robert Demolombe: Querying a Rule Base. Expert Database Conf. 1986: 477-485 BibTeX
[2]
Francisco Corella: Semantic Retrieval and Levels of Abstraction. Expert Database Workshop 1984: 91-114 BibTeX
[3]
Tomasz Imielinski: Intelligent Query Answering in Rule Based Systems. J. Log. Program. 4(3): 229-257(1987) BibTeX
[4]
David Maier: The Theory of Relational Databases. Computer Science Press 1983, ISBN 0-914894-42-0
Contents BibTeX
[5]
Amihai Motro: An Access Authorization Model for Relational Databases Based on Algebraic Manipulation of View Definitions. ICDE 1989: 339-347 BibTeX
[6]
Amihai Motro: Integrity = Validity + Completeness. ACM Trans. Database Syst. 14(4): 480-502(1989) BibTeX
[7]
Chung-Dak Shum, Richard R. Muntz: Implicit Representation for Extensional Answers. Expert Database Conf. 1988: 497-522 BibTeX
[8]
Chung-Dak Shum, Richard R. Muntz: An Information-Theoretic Study on Aggregate Responses. VLDB 1988: 479-490 BibTeX
[9]
Jeffrey D. Ullman: Principles of Database Systems, 2nd Edition. Computer Science Press 1982, ISBN 0-914894-36-6
BibTeX
[10]
Moshé M. Zloof: Query-by-Example: A Data Base Language. IBM Systems Journal 16(4): 324-343(1977) BibTeX

Referenced by

  1. Xubo Zhang, Z. Meral Özsoyoglu: Implication and Referential Constraints: A New Formal Reasoning. IEEE Trans. Knowl. Data Eng. 9(6): 894-910(1997)
  2. Jiawei Han, Yue Huang, Nick Cercone, Yongjian Fu: Intelligent Query Answering by Knowledge Discovery Techniques. IEEE Trans. Knowl. Data Eng. 8(3): 373-390(1996)
  3. H. V. Jagadish: The INCINERATE Data Model. ACM Trans. Database Syst. 20(1): 71-110(1995)
  4. Susan V. Vrbsky, Jane W.-S. Liu: APPROXIMATE - A Query Processor that Produces Monotonically Improving Approximate Answers. IEEE Trans. Knowl. Data Eng. 5(6): 1056-1068(1993)
  5. Yang Hee Kim, Hyoung-Joo Kim: Applying Intensional Query Processing Techniques to Object-Oriented Database Systems. DASFAA 1993: 405-412
  6. Alain Pirotte, Dominique Roelants, Esteban Zimányi: Controlled Generation of Intensional Answers. IEEE Trans. Knowl. Data Eng. 3(2): 221-236(1991)
  7. Wesley W. Chu, Rei-Chi Lee, Qiming Chen: Using Type Inference and Induced Rules to Provide Intensional Answers. ICDE 1991: 396-403
  8. Amihai Motro, Qiuhui Yuan: Querying Database Knowledge. SIGMOD Conference 1990: 173-183
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:45:41 2009