Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
A compression technique to materialize transitive closure
Jagadish H. (ed) ACM Transactions on Database Systems15 (3):558-598,1990.Type:Article
Date Reviewed: Oct 1 1992

The processing of recursive queries is likely to be one of the features of the next generation of database systems, and it is a property that is also required in expert databases. The problem with recursive queries is that they are computationally expensive to execute. Linear recursive queries can be expressed as transitive closures, and using these closures is a useful approach to precessing recursive queries. Computing the transitive closure itself is also computationally expensive, however, and many attempts have been made to do this efficiently. One of these attempts involves materializing or explicitly precomputing “appropriate” transitive closures that are required frequently and storing them; but the disadvantage of this technique has been that these closures can consist of huge numbers of tuples, and their storage management becomes a problem.

This paper proposes a compression technique to reduce the storage requirement of appropriate transitive closures while still permitting queries related to the closure, which allow recursive query processing to be answered efficiently. Updates to the underlying database involve adding nodes and arcs to the compressed closure, which can also be done efficiently. The authors present details of simulation results to verify that their compression strategy is of benefit.

This detailed report covers a specific piece of research work in a narrow area of future generation database query processing and is not for the general reader, but papers in ACM Transactions on Database Systems are not meant to be. The paper is long and difficult to read, but I am a general reader in this area of database processing and not one of the specialists for whom the paper is presumably intended. The bibliography is good.

Reviewer:  A. F. Smeaton Review #: CR115117
Bookmark and Share
 
Query Processing (H.2.4 ... )
 
 
Applications And Expert Systems (I.2.1 )
 
 
Problem Solving, Control Methods, And Search (I.2.8 )
 
Would you recommend this review?
yes
no
Other reviews under "Query Processing": Date
A correction of the termination conditions of the Henschen-Naqvi technique
Briggs D. Journal of the ACM 31(4): 711-719, 1984. Type: Article
Sep 1 1992
Efficient and optimal query answering on independent schemes
Atzeni P. (ed), Chan E. Theoretical Computer Science 77(3): 291-308, 1990. Type: Article
Nov 1 1991
The complexity of evaluating relational queries
Cosmadakis S. Information and Control 58(1-3): 101-112, 1984. Type: Article
Feb 1 1985
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