Space-time tradeoff for answering range queries

  • Andrew C. Yao

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

96 Scopus citations

Abstract

In this paper, we raise and investigate the question of (storage) space- (retrieval) time tradeoff for a static database, in the general framework of Fredman's. As will be seen, such tradeoff results also lead to lower bounds on the complexity of processing a sequence of m INSERT and QUERY instructions. The latter results are incomparable to Fredman's, since the presence of DELETE instructions was crucial for his proof technique. We will present our results in detail in the next few sections. Here we will only mention three main conclusions. Firstly, circular query is shown to be intrinsically hard in the sense that, for some static database with n records, there is a space-time tradeoff TS -α-> n1 + -α-egr; where -α-egr;-α->0; in contrast, orthogonal query can always be implemented with space S-α-equil;0(n(log n)k) and time T-α-equil;0((log n)k) for fixed k. Furthermore, any algorithm for processing 0(n) INSERT and QUERY instructions must use time -α-Ohgr;(n1+-α-egr;) in the worst case. Secondly, for the -α-ldquo;interval-α-rdquo; query, we have determined the space-time tradeoff quite precisely to be T -α-agr;(S,n), where -α-agr; is the inverse to an Ackermann's function first defined by Tarjan [9]. This is a rare case where the function -α-agr; arises outside the context of path compression, and is obtained through a totally independent derivation. Thirdly, we prove that, for the interval query, any algorithm to process a sequence of 0(n) INSERT and QUERY must take time -α-Ohgr;((n log n)/(log log n)) in the worst case. This means that one cannot hope to maintain the most efficient static data structure (with retrieval time -α-agr;(S,n)) in the dynamic case.

Original languageEnglish
Title of host publicationProceedings of the 14th Annual ACM Symposium on Theory of Computing, STOC 1982
PublisherAssociation for Computing Machinery
Pages128-136
Number of pages9
ISBN (Print)0897910702
DOIs
StatePublished - 5 May 1982
Event14th Annual ACM Symposium on Theory of Computing, STOC 1982 - San Francisco, United States
Duration: 5 May 19827 May 1982

Publication series

NameProceedings of the Annual ACM Symposium on Theory of Computing
ISSN (Print)0737-8017

Conference

Conference14th Annual ACM Symposium on Theory of Computing, STOC 1982
Country/TerritoryUnited States
CitySan Francisco
Period5/05/827/05/82

Fingerprint

Dive into the research topics of 'Space-time tradeoff for answering range queries'. Together they form a unique fingerprint.

Cite this