# Efficient temporal counting with bounded error

Efficient temporal counting with bounded error This paper studies aggregate search in transaction time databases. Specifically, each object in such a database can be modeled as a horizontal segment, whose y -projection is its search key, and its x -projection represents the period when the key was valid in history. Given a query timestamp q t and a key range $$\vec{q_k}$$ , a count-query retrieves the number of objects that are alive at q t , and their keys fall in $$\vec{q_k}$$ . We provide a method that accurately answers such queries, with error less than $$\frac{1}{\varepsilon} + \varepsilon \cdot N_{\rm alive}(q_t)$$ , where N alive ( q t ) is the number of objects alive at time q t , and ɛ is any constant in (0, 1). Denoting the disk page size as B , and n = N / B , our technique requires O ( n ) space, processes any query in O (log B n ) time, and supports each update in O (log B n ) amortized I/Os. As demonstrated by extensive experiments, the proposed solutions guarantee query results with extremely high precision (median relative error below 5%), while consuming only a fraction of the space occupied by the existing approaches that promise precise results. http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png The VLDB Journal Springer Journals

# Efficient temporal counting with bounded error

, Volume 17 (5) – Aug 1, 2008
22 pages

/lp/springer_journal/efficient-temporal-counting-with-bounded-error-QW4Ybh1xzY
Publisher
Springer-Verlag
Subject
Computer Science; Database Management
ISSN
1066-8888
eISSN
0949-877X
D.O.I.
10.1007/s00778-007-0066-x
Publisher site
See Article on Publisher Site

### References

• I/O-efficient dynamic planar point location
Arge, L.; Vahrenhold, J.

## You’re reading a free preview. Subscribe to read the entire article.

### DeepDyve is your personal research library

It’s your single place to instantly
that matters to you.

over 12 million articles from more than
10,000 peer-reviewed journals.

All for just $49/month ### Explore the DeepDyve Library ### Unlimited reading Read as many articles as you need. Full articles with original layout, charts and figures. Read online, from anywhere. ### Stay up to date Keep up with your field with Personalized Recommendations and Follow Journals to get automatic updates. ### Organize your research It’s easy to organize your research with our built-in tools. ### Your journals are on DeepDyve Read from thousands of the leading scholarly journals from SpringerNature, Elsevier, Wiley-Blackwell, Oxford University Press and more. All the latest content is available, no embargo periods. ### Monthly Plan • Read unlimited articles • Personalized recommendations • No expiration • Print 20 pages per month • 20% off on PDF purchases • Organize your research • Get updates on your journals and topic searches$49/month

14-day Free Trial

Best Deal — 39% off

### Annual Plan

• All the features of the Professional Plan, but for 39% off!
• Billed annually
• No expiration
• For the normal price of 10 articles elsewhere, you get one full year of unlimited access to articles.

$588$360/year

billed annually

14-day Free Trial