NDLI: Optimizing spatial Min/Max aggregations

Content Provider	Springer Nature Link
Author	Zhang, Donghui Tsotras, Vassilis J.
Copyright Year	2005
Abstract	Aggregate computation over a collection of spatial objects appears in many real-life applications. Aggregates are computed on values (weights) associated with spatial objects, for example, the temperature or rainfall over the area covered by the object. In this paper we concentrate on MIN/MAX aggregations: “given a query rectangle, find the minimum/maximum weight among all objects intersecting the query rectangle.” Traditionally such queries have been performed as range searches. Assuming that objects are indexed by a spatial access method (SAM), the MIN/MAX is computed while retrieving those objects intersecting the query interval. This requires effort proportional to the number of objects satisfying the query, which may be large. A better approach is to maintain aggregate information among the index nodes of the spatial access method; then various index paths can be eliminated during the range search. Yet another approach is to build a specialized index that maintains the aggregate incrementally. We propose four novel optimizations for improving the performance of MIN/MAX queries when an index structure (traditional or specialized) is present. Moreover, we introduce the MR-tree, an R-tree-like dynamic specialized index that incorporates all four optimizations. Our experiments show that the MR-tree offers drastic performance improvement over previous solutions. As a byproduct of this work we present an optimized version of the MSB-tree, an index that has been proposed for the MIN/MAX computation over 1D interval objects.
Starting Page	170
Ending Page	181
Page Count	12
File Format	PDF
ISSN	10668888
Journal	The VLDB Journal
Volume Number	14
Issue Number	2
e-ISSN	0949877X
Language	English
Publisher	Springer-Verlag
Publisher Date	2005-01-01
Publisher Place	Berlin, Heidelberg
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Spatial aggregates Indexing Min/Max Database Management
Content Type	Text
Resource Type	Article
Subject	Information Systems Hardware and Architecture

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Authenticated indexing for outsourced spatial databases

Large-scale indexing of spatial data in distributed repositories: the SD-Rtree

Indexing spatiotemporal archives

The min-dist location selection and facility replacement queries

Finding top-k relevant groups of spatial web objects

Privacy-preserving indexing of documents on the network

Spatial data warehouses and spatial OLAP come towards the cloud: design and performance

The partitioned exponential file for database storage management

A framework for efficient spatial web object retrieval

Optimizing spatial Min/Max aggregations

Similar Documents

Authenticated indexing for outsourced spatial databases

Large-scale indexing of spatial data in distributed repositories: the SD-Rtree

Indexing spatiotemporal archives

The min-dist location selection and facility replacement queries

Finding top-k relevant groups of spatial web objects

Privacy-preserving indexing of documents on the network

Spatial data warehouses and spatial OLAP come towards the cloud: design and performance

The partitioned exponential file for database storage management

A framework for efficient spatial web object retrieval

Optimizing spatial Min/Max aggregations