Spatial data extension for Cassandra NoSQL database

• Published in: Journal of big data Vol. 3; no. 1; pp. 1 - 16
• Main Authors: Ben Brahim, Mohamed, Drira, Wassim, Filali, Fethi, Hamdi, Noureddine
• Format: Journal Article
• Language: English
• Published: Cham Springer International Publishing 22-06-2016; Springer Nature B.V
• Subjects: Big Data; Communications Engineering; Computational Science and Engineering; Computer Science; Data management; Data Mining and Knowledge Discovery; Database Management; Digitization; Information Storage and Retrieval; Mathematical Applications in Computer Science; Networks; Personal communication; Queries; Query languages; Research parks; Response time (computers); Spatial data; Big data; NoSQL databases; Spatial query; Cassandra DB; Geohash
• ISSN: 2196-1115; 2196-1115
• DOI: 10.1186/s40537-016-0045-4

The big data phenomenon is becoming a fact. Continuous increase of digitization and connecting devices to Internet are making current solutions and services smarter, richer and more personalized. The emergence of the NoSQL databases, like Cassandra, with their massive scalability and high availability encourages us to investigate the management of the stored data within such storage system. In our present work, we harness the geohashing technique to enable spatial queries as extension to Cassandra query language capabilities while preserving the native syntax. The developed framework showed the feasibility of this approach where basic spatial queries are underpinned and the query response time is reduced by up to 70 times for a fairly large area.