Duration: 1:09:28

108 views

2

Spatial Database Management Systems (SDBMS), e.g., Geographical Information Systems, that manage spatial objects such as points, lines, and hyper-rectangles, often have very high query processing costs. Accurate selectivity estimation during query optimization therefore is crucially important for finding good query plans, especially when spatial joins are involved. Selectivity estimation has been studied for relational database systems, but till date has only received little attention in SDBMS. In this talk, I will present novel sketch-based methods that permit high-quality selectivity estimation for spatial joins and range queries. The sketch-based synopses can be constructed in a single scan over the input, handle inserts and deletes to the database incrementally, and hence can also be used for processing of streaming data. In contrast to previous approaches which provide no guarantees on the quality of approximate results provided, our techniques return approximate results that come with provable probabilistic quality guarantees. The quality guarantees are user tunable and permit a graceful tradeoff between space consumption and the quality of the resulting approximation.