Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
A sound and sometimes complete query evaluation algorithm for relational databases with null values
Reiter R. Journal of the ACM33 (2):349-370,1986.Type:Article
Date Reviewed: Nov 1 1986

Yet another paper dealing with null values? Yes and no--the main point of the paper is not so much the null values issue itself, but rather an example of application of first-order logic to databases. In order to make the semantics clear, precise logical specifications are provided of the notions of interest, i.e., of null values and answers to queries. The author deals with only one kind of nulls--“value existing but unknown,” and the only difference between a null value (Skolem constant) and an “ordinary” constant is the absence of (some) unique name axioms for a null value. On the other hand, nulls are “indexed”; i.e., for each new null value, a new distinct name is introduced.

Though the paper under review is (to a great extent) self-contained, the author defines all the necessary notions and provides some motivation. For better understanding and for a very interesting and stimulating discussion of the merits of this proof-theoretic approach, the reader is referred to [1] and [2]. Actually, the reviewed paper is a further development of the ideas set forth in [1], in one of the directions already mentioned there. It appears that the “extended relational theories” developed by Reiter are a very good means for extending the semantics of the “basic” relational model, in particular because they provide the possibility of expressing rather subtle facts not always representable using more traditional and prevailing approaches (including the model-theoretic one). Moreover, the formal semantics of these relational model extensions (including null values) are simple and intuitively correct, and do not use multivalued logics.

The query evaluation algorithm provided in the paper recursively decomposes complex queries into algebraic operations on primitive queries, in particular, stripping off leading typed universal and existential quantifiers. In two of the cases, the decomposition presents problems which may lead to incomplete answers; these difficulties are known from the literature and deal with disjunction and leading typed existential quantifiers. After decomposition, algebraic operators are determined for evaluating primitive queries. The author shows that for some cases (universally quantified conjunctive queries; “positive” queries (without negation); and relational databases without nulls), the query evaluation algorithm is complete.

As the author correctly remarks in his Conclusion, after the abstract specification has been provided for the notions of interest, “the rest was more or less routine” (and consisted mainly of technicalities). It is interesting (and probably fruitful) to compare the use of logic for defining semantics in the database setting with the use of logic in programming (for precise and explicit definition of program semantics, see, e.g., [3]). However, it seems that in the database area (unlike programming), the results still tend to be more theoretical than practical, and more developments are needed--probably in the directions set forth by [1] and [2]--in order to be able to handle “more practical” problems.

Reviewer:  H. I. Kilov Review #: CR110594
1) Reiter, R.Towards a logical reconstruction of relational database theory, in On conceptual modelling: perspectives from artificial intelligence, databases, and programming languages, M. Brodie, J. Mylopoulos, and J. Schmidt (Eds.), Springer-Verlag, New York, 1984.
2) Gallaire, H.; Minker, J.; and Nicolas, J.-M.Log- ic and databases: a deductive approach, ACM Comput. Surv. 16 (1984), 153–185.
3) Dijkstra, E. W.A discipline of programming, Prentice-Hall, Englewood Cliffs, NJ, 1976. See <CR> 17, 11 (Nov. 1976), Revs. 30,461 and 30,462.
Bookmark and Share
  Featured Reviewer  
 
Relational Databases (H.2.4 ... )
 
 
Query Languages (H.2.3 ... )
 
Would you recommend this review?
yes
no
Other reviews under "Relational Databases": Date
Sort sets in the relational model
Ginsburg S., Hull R. Journal of the ACM 33(3): 465-488, 1986. Type: Article
Nov 1 1986
Foundation for object/relational databases
Date C., Darwen H., Addison Wesley Longman Publishing Co., Inc., Redwood City, CA, 1998. Type: Book (9780201309782)
Nov 1 1998
Joe Celko’s data and databases
Celko J., Morgan Kaufmann Publishers Inc., San Francisco, CA, 1999. Type: Book (9781558604322)
Oct 1 1999
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy