Abstract
Domains such as energy management rely heavily on dashboards and other related interfaces to manage the infrastructure and resources. The users of this domain use dashboards to manage the data and extensively perform periodic analysis to save energy and cost. Creating multiple dashboards for visualization of data is not user-friendly from a design perspective. This motivates the need of a single interface through which users can do data exploration, visualization and summarizing. Combining this with features such as anomaly detection can identify various issues and assist in day to day monitoring of an energy management center.
In this paper, we present ROC (Resource Optimization Center) Bot, a novel data exploration tool with a natural language interface. ROC Bot leverages recent advances in deep models to make query understanding more robust in the following ways: First, ROC Bot uses a deep model to translate natural language statements to SQL, making the translation process more robust to paraphrasing and other linguistic variations. Second, to support the users in automatically summarizing data, ROC Bot provides a machine learning model that helps in writing natural looking summaries in any given tabular data.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
These data sets are available for download and public use at https://github.com/nlpteam19/ROCBot.
References
Dong, L., Lapata, M.: Coarse-to-fine decoding for neural semantic parsing. CoRR abs/1805.04793 (2018)
Ehrenbrink, P., Osman, S., Möller, S.: Google now is for the extraverted, cortana for the introverted: investigating the influence of personality on IPA preference. In: Proceedings of the 29th Australian Conference on Computer-Human Interaction, OZCHI 2017, pp. 257–265. ACM, New York (2017). https://doi.org/10.1145/3152771.3152799
Guo, D., et al.: Question generation from SQL queries improves neural semantic parsing. CoRR abs/1808.06304 (2018)
Jadeja, M., Varia, N.: Perspectives for evaluating conversational AI. CoRR abs/1709.04734 (2017)
Kukich, K.: Design of a knowledge-based report generator. In: 21st Annual Meeting of the Association for Computational Linguistics, pp. 145–150. Association for Computational Linguistics, Cambridge, June 1983. https://doi.org/10.3115/981311.981340, https://www.aclweb.org/anthology/P83-1022
Li, F., Jagadish, H.V.: Constructing an interactive natural language interface for relational databases. Proc. VLDB Endow. 8(1), 73–84 (2014). https://doi.org/10.14778/2735461.2735468
McKeown, K.R.: Text Generation: Using Discourse Strategies and Focus Constraints to Generate Natural Language Text. Cambridge University Press, Cambridge (1985)
Parks, M.: Microsoft Business Intelligence. POWER BI. CreateSpace Independent Publishing Platform, USA (2014)
Pasupat, P., Liang, P.: Compositional semantic parsing on semi-structured tables (2015)
Peters, M.E., et al.: Deep contextualized word representations. CoRR abs/1802.05365 (2018)
Popescu, A.M., Etzioni, O., Kautz, H.: Towards a theory of natural language interfaces to databases. In: Proceedings of the 8th International Conference on Intelligent User Interfaces. IUI 2003, pp. 149–157. ACM, New York (2003). https://doi.org/10.1145/604045.604070, http://doi.acm.org/10.1145/604045.604070
Reiter, E., Dale, R.: Building applied natural language generation systems. Nat. Lang. Eng. 3(1), 57–87 (Mar 1997). https://doi.org/10.1017/S1351324997001502, https://doi.org/10.1017/S1351324997001502
Sadun, E., Sande, S.: Talking to Siri: Learning the Language of Apple’s Intelligent Assistant, 2nd edn. Que Publishing Company, Indianapolis (2013)
Sun, Y., et al.: Semantic parsing with syntax- and table-aware SQL generation. In: ACL (2018)
Tian, R., Narayan, S., Sellam, T., Parikh, A.P.: Sticking to the facts: confident decoding for faithful data-to-text generation (2019)
Xu, X., Liu, C., Song, D.: SQLNET: generating structured queries from natural language without reinforcement learning (2017)
Yaghmazadeh, N., Wang, Y., Dillig, I., Dillig, T.: SQLizer: query synthesis from natural language. Proc. ACM Program. Lang. 1(OOPSLA), 63:1–63:26 (2017). https://doi.org/10.1145/3133887, http://doi.acm.org/10.1145/3133887
Yin, P., Lu, Z., Li, H., Kao, B.: Neural enquirer: learning to query tables with natural language (2015)
Yu, T., Li, Z., Zhang, Z., Zhang, R., Radev, D.: TypeSQL: knowledge-based type-aware neural text-to-SQL generation. In: Proceedings of the 2018 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, vol. 2 (Short Papers), pp. 588–594. Association for Computational Linguistics (2018). http://aclweb.org/anthology/N18-2093
Zhong, V., Xiong, C., Socher, R.: SEQ2SQL: generating structured queries from natural language using reinforcement learning (2017)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 Springer Nature Switzerland AG
About this paper
Cite this paper
Tiwari, R., Afaque, M., Sangroya, A., Rawat, M. (2021). ROC Bot: Towards Designing Virtual Command Centre for Energy Management. In: Gupta, M., Ramakrishnan, G. (eds) Trends and Applications in Knowledge Discovery and Data Mining. PAKDD 2021. Lecture Notes in Computer Science(), vol 12705. Springer, Cham. https://doi.org/10.1007/978-3-030-75015-2_16
Download citation
DOI: https://doi.org/10.1007/978-3-030-75015-2_16
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-75014-5
Online ISBN: 978-3-030-75015-2
eBook Packages: Computer ScienceComputer Science (R0)