Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Space-time trade-offs for orthogonal range queries
Vaidya P. SIAM Journal on Computing18 (4):748-758,1989.Type:Article
Date Reviewed: Oct 1 1990

Vaidya’s work provides an insight into such issues as the minimum amount of storage needed to ensure a certain query time. The tradeoff between space and time depends on the model of the data structure and the set of records in the database. Worst-case bounds or the lower bound of the space-time product can be obtained by fixing a data structure and showing the existence of a set of records whose space-time product has the given bound.

This paper presents the space-time tradeoffs for orthogonal range queries on a static database. The database contains a collection of records, each of which has a key and a number of data fields. A database system returns either the set of records or a function of the set of records whose keys satisfy all the constraints of a given query. A record ( k , f ( k ) ) is a pair, where k is the key and f ( k ) is the datum from a commutative semigroup G. If k is a d -tuple, an orthogonal range query is specified by a 2 d -tuple ( x 11 , x 12 , x 21 , x 22 ,..., x d1 , x d2 ) of positive integers satisfying x i1 < x i2 where 1 ≤ i ≤ d. The query region for an orthogonal range query is a parallelepiped defined by the product of d -semiclosed intervals [ x 11 , x 12 ) × [x 21 , x 22 ) × ... × [ x d1 , x d2 ). A key is said to be located in the parallelepiped if and only if x i1 ≤ k i ≤ x i2 for 1 ≤ i ≤ d.

The author considers two types of responses to an orthogonal range query. In one case, the output is the semigroup sum of the data values whose keys are located in the query parallelepiped, while in the other the output is a list of all the records whose keys lie in the query parallelepiped. The paper studies two models, the arithmetic model and the tree model. The arithmetic model attributes unit cost to each arithmetic operation but no cost to measuring retrieval. Given a query box b, the query answering algorithm is expected to return the semigroup sum of the data values whose keys are located in b. The tree model considers a scaled query time in order to take the overhead involved in producing the response to a query into account. The data structure for this model is a rooted tree with each edge in the tree associated with a condition. The output to a query is a function of the data associated with the vertices visited, starting from the root.

The paper is clear and concise. Since most data structures in practical use are rooted trees (fitting the tree model), the results are significant.

Reviewer:  Donald H. Kraft Review #: CR114292
Bookmark and Share
 
Query Formulation (H.3.3 ... )
 
 
Access Methods (H.2.2 ... )
 
 
Query Processing (H.2.4 ... )
 
 
Retrieval Models (H.3.3 ... )
 
 
Nonnumerical Algorithms And Problems (F.2.2 )
 
 
Data Structures (E.1 )
 
Would you recommend this review?
yes
no
Other reviews under "Query Formulation": Date
A comparison of two methods for Boolean query relevancy feedback
Salton G., Voorhees E., Fox E. Information Processing and Management: an International Journal 20(5-6): 637-651, 1984. Type: Article
Jul 1 1985
Calibrating databases
Fischhoff B., MacGregor D. Journal of the American Society for Information Science 37(4): 222-233, 1986. Type: Article
Sep 1 1987
The dynamic HomeFinder
Williamson C., Shneiderman B.  Research and development in information retrieval (, Copenhagen, Denmark, Jun 21-24, 1992)3461992. Type: Proceedings
Jul 1 1994
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