Title
$\mathcal{MD}$-HBase: design and implementation of an elastic data infrastructure for cloud-scale location services
Abstract
The ubiquity of location enabled devices has resulted in a wide proliferation of location based applications and services. To handle the growing scale, database management systems driving such location based services (LBS) must cope with high insert rates for location updates of millions of devices, while supporting efficient real-time analysis on latest location. Traditional DBMSs, equipped with multi-dimensional index structures, can efficiently handle spatio-temporal data. However, popular open-source relational database systems are overwhelmed by the high insertion rates, real-time querying requirements, and terabytes of data that these systems must handle. On the other hand, key-value stores can effectively support large scale operation, but do not natively provide multi-attribute accesses needed to support the rich querying functionality essential for the LBSs.We present the design and implementation of $\mathcal {MD}$ -HBase, a scalable data management infrastructure for LBSs that bridges this gap between scale and functionality. Our approach leverages a multi-dimensional index structure layered over a key-value store. The underlying key-value store allows the system to sustain high insert throughput and large data volumes, while ensuring fault-tolerance, and high availability. On the other hand, the index layer allows efficient multi-dimensional query processing. Our optimized query processing technique accesses only the index and storage level entries that intersect with the query region, thus ensuring efficient query processing. We present the design of $\mathcal {MD}$ -HBase that demonstrates how two standard index structures--the K-d tree and the Quad tree--can be layered over a range partitioned key-value store to provide scalable multi-dimensional data infrastructure. Our prototype implementation using HBase, a standard open-source key-value store, can handle hundreds of thousands of inserts per second using a modest 16 node cluster, while efficiently processing multi-dimensional range queries and nearest neighbor queries in real-time with response times as low as few hundreds of milliseconds.
Year
DOI
Venue
2013
10.1007/s10619-012-7109-z
Distributed and Parallel Databases
Keywords
Field
DocType
large data volume,index layer,cloud-scale location service,scalable data management infrastructure,key-value store,latest location,multi-dimensional index structure,scalable multi-dimensional data infrastructure,multi-dimensional range query,location updates,efficient multi-dimensional query processing,elastic data infrastructure,location based services
Computer science,Range query (data structures),Location-based service,Relational database management system,Throughput,High availability,Data management,Scalability,Cloud computing,Distributed computing
Journal
Volume
Issue
ISSN
31
2
0926-8782
Citations 
PageRank 
References 
36
1.44
15
Authors
4
Name
Order
Citations
PageRank
Shoji Nishimura119116.40
Sudipto Das2109951.98
Divyakant Agrawal382011674.75
Amr El Abbadi467671569.95