Abstract
In this demonstration, we focus on middleware data obtained from devices like the network routers and power meters which may be of interest to a technician fixing a customer complaint or a user trying to self-diagnose their utility usage. The users in our case are often unaware of both the data details and database querying language which is in contrast to typical natural language to structured query (NL2SQL) situations where the business analyst knows their domain data but not the querying techniques. We adapt the rule-based NL2SQL approach to our problem and in particular, focus on queries about users, devices and spatio-temporal properties that are unique to this setting. We demonstrate an Alexa-based system, implemented using open-source Rasa, that can answer router usage queries in a home setting and easily extended for power usage or other utilities.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Bocklisch, T., Faulkner, J., Pawlowski, N., Nichol, A.: Rasa: open source language understanding and dialogue management (2017). https://arxiv.org/abs/1712.05181
Gan, Y., et al.: Natural SQL: making SQL easier to infer from natural language specifications. In: EMNLP Findings Preprint https://arxiv.org/abs/2109.05153 (2021)
Saha, D., Floratou, A., Sankaranarayanan, K., Minhas, U.F., Mittal, A.R., Özcan, F.: Athena: an ontology-driven system for natural language querying over relational data stores. In: Proceedings of the VLDB (2016)
Sheinin, V., Khorashani, E., Yeo, H., Xu, K., Vo, N.P.A., Popescu, O.: QUEST: a natural language interface to relational databases. In: Proceedings of the LREC, May 2018
Yu, T., et al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. In: Proceedings of the EMNLP (2018)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Lakkaraju, K., Palaiya, V., Paladi, S.T., Appajigowda, C., Srivastava, B., Johri, L. (2022). Data-Based Insights for the Masses: Scaling Natural Language Querying to Middleware Data. In: Bhattacharya, A., et al. Database Systems for Advanced Applications. DASFAA 2022. Lecture Notes in Computer Science, vol 13247. Springer, Cham. https://doi.org/10.1007/978-3-031-00129-1_49
Download citation
DOI: https://doi.org/10.1007/978-3-031-00129-1_49
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-00128-4
Online ISBN: 978-3-031-00129-1
eBook Packages: Computer ScienceComputer Science (R0)