ABSTRACT
Embedded devices are increasingly being used for data collection and on-device data analysis for applications in environmental and infrastructure monitoring, health and wearable computing, and sensor and mobile systems. Processing data on the device rather than transmitting it over a network for analysis reduces energy consumption, network bandwidth usage, and results in more robust and longer functioning devices. A key challenge is enabling efficient data management on devices that may only have a few KBs of memory and limited code space. Previous work has demonstrated that using relational databases is possible on embedded devices with restrictions on the queries that can be processed. In this work, we eliminate one of the key barriers to using relational technology on embedded devices, which is the massive overhead involved in SQL parsing and translation that can take up to 50% of the code and memory resources on the device. Our approach allows developers to continue to use relational APIs and SQL during development which are then pre-compiled when deployed on the device. This produces all of the benefits of relational systems without the on-device overhead and limitations. Experimental results demonstrate that query pre-compiling can reduce query parse times by up to 90% and on-device execution times by up to 50%. The technique is applicable to a wide range of embedded systems and databases.
- N. Anciaux, L. Bouganim, and P. Pucheral. Memory Requirements for Query Execution in Highly Constrained Devices. VLDB '03, pages 694--705. VLDB Endowment, 2003. Google ScholarDigital Library
- P. Bonnet, J. Gehrke, and P. Seshadri. Towards Sensor Database Systems. MDM '01, pages 3--14, London, UK, UK, 2001. Springer-Verlag. Google ScholarDigital Library
- G. Douglas and R. Lawrence. LittleD: A SQL Database for Sensor Nodes and Embedded Applications. In Proceedings of the 29th Annual ACM Symposium on Applied Computing, SAC '14, pages 827--832, New York, NY, USA, 2014. ACM. Google ScholarDigital Library
- D. K. Fisher and P. J. Gould. Open-Source Hardware Is a Low-Cost Alternative for Scientific Instrumentation and Research. Modern Instrumentation, 1(2):8--20, 2012.Google ScholarCross Ref
- S. R. Madden, M. J. Franklin, J. M. Hellerstein, and W. Hong. TinyDB: An Acquisitional Query Processing System for Sensor Networks. ACM Trans. Database Syst., 30(1):122--173, Mar. 2005. Google ScholarDigital Library
- C. Severance. Massimo Banzi: Building Arduino. Computer, 47(1):11--12, Jan 2014. Google ScholarDigital Library
- N. Tsiftes and A. Dunkels. A Database in Every Sensor. SenSys '11, pages 316--332, New York, NY, USA, 2011. ACM. Google ScholarDigital Library
Index Terms
- Improving SQL query performance on embedded devices using pre-compilation
Recommendations
Efficient SQL querying on embedded devices using pre-compilation
Microprocessors and embedded devices are used for data collection and analysis applications in infrastructure and en- vironmental monitoring, medical technology, wearable com- puting, and sensor network and mobile systems. Such appli- cations demand low ...
Identifying New Directions in Database Performance Tuning
Database performance tuning is a complex and varied active research topic. With enterprise relational database management systems still reliant on the set-based relational concepts that defined early data management products, the disparity between the ...
SPARQL-to-SQL Query Translation: Bottom-Up or Top-Down?
SCC '11: Proceedings of the 2011 IEEE International Conference on Services ComputingEmerging Semantic Web Services rely on the availability of metadata that describes various functional and non-functional characteristics of computational resources. A number of semantic vocabularies and datasets describing existing services and ...
Comments