Title |
STSDB: Spatio-Temporal Sensor Database for Smart City Query Processing |
ID_Doc |
37061 |
Authors |
Vyas, U; Panchal, P; Patel, M; Bhise, M |
Title |
STSDB: Spatio-Temporal Sensor Database for Smart City Query Processing |
Year |
2019 |
Published |
|
DOI |
10.1145/3288599.3296015 |
Abstract |
Modern world smart devices are equipped with several sensors which continuously generate the data. Managing and analyzing these data efficiently is a key need of the current sensor world. Present applications require real-time analysis of past sensor data for decision making. The goal of this work is to efficiently process the spatio-temporal queries for sensor data. Spatio-Temporal Sensor Index STSI helps in managing the sensor details and leads to faster query processing. The types of queries that have been considered are; 1) Spatio-Time Travel, 2) Temporal Aggregation and 3) Time Travel, 4) Spatio-temporal Aggregation. Spatio-Temporal Sensor Database STSDB is built by including STSI index in HBase. The STSDB performance is compared with HBase on two parameters Data Insertion Time DIT, and Query Execution Time QET. The DIT of STSDB is almost identical as compared to HBase. While the QET averaged over all four types of queries show 49% improvement for STSDB over HBase. Both the performance parameters continue to show similar trends for scaled data in HBase and STSDB. STSDB is demonstrated in this work using smart city data. |
Author Keywords |
Data Scaling; Query Processing; Sensors Data; Smart City Applications; Spatio-Temporal Sensor Database STSDB; Spatio-Temporal Sensor Index STSI |
Index Keywords |
Index Keywords |
Document Type |
Other |
Open Access |
Open Access |
Source |
Conference Proceedings Citation Index - Science (CPCI-S) |
EID |
WOS:000484491600058 |
WoS Category |
Computer Science, Hardware & Architecture; Computer Science, Theory & Methods; Engineering, Electrical & Electronic |
Research Area |
Computer Science; Engineering |
PDF |
|