Abstract
Motivated by a real-world scenario, we enable end users to query data due natural language from different sources like spreadsheets and databases. We provide a natural language user interface (NLUI) solution on how real-world entities and relations between them can be interpreted as a model to allow end user questions on the data. Therefore, the system enables end users to give instructions step-by-step, to avoid the complexity in full descriptions and give directly feedback of success. An evaluation is conducted with human users who had to perform a series of tasks using natural language. Overall, 13 end user took part in our survey with ten questions. 94.9% of all answers in the first part could be resolved on spreadsheet data, and 62,5% on SQL database.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Wachtel, A., Eurich, F., Tichy, W.F.: Programming in natural language building algorithms from human descriptions. In: The Eleventh International Conference on Advances in Computer-Human Interactions, March 2018
Ballard, B.W., Biermann, A.W.: Programming in natural language: NLC as a prototype. In: Proceedings of the 1979 Annual Conference, pp. 228–237. ACM (1979)
Bundesanstalt Statistik Österreich: Regional Atlas Austria (Online Atlas). http://statistik.at/web_de/services/regionalatlas_oesterreich/index.html
Campbell, B.A., Treude C.: NLP2Code: code snippet content assist via natural language tasks. In: ICSME (2017)
Cunha, J., Fernandes, J., Mendes, J., Pacheco, H., Saraiva, J.: Bidirectional transformation of model-driven spreadsheets. In: ICMT (2012)
Ferrucci, D., et al.: Building Watson: an overview of the DeepQA project. AI Mag. 31(3), 59–79 (2010)
Hearst, M.A.: Automatic acquisition of hyponyms from large text corpora. In: Proceedings of the 14th Conference on Computational Linguistics - Volume 2 (1992)
Ko, A.J., Myers, B.A.: Designing the whyline: a debugging interface for asking questions about program behavior. In: Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (2004)
Lieberman, H., Paterno, F., Klann, M., Wulf, V.: End-user development: an emerging paradigm. In: Lieberman, H., Paternó, F., Wulf, V. (eds.) End user development, pp. 1–8. Springer, Heidelberg (2006). https://doi.org/10.1007/1-4020-5386-X_1
Liu, H., Lieberman, H.: Toward a programmatic semantics of natural language. In: IEEE Symposium on Visual Languages and Human Centric Computing (2004)
Liu, H., Lieberman, H.: Metafor: visualizing stories as code. In: Proceedings of the 10th International Conference on Intelligent User Interfaces. ACM (2005)
Myers, B., Ko, A., Burnett, M.: Invited research overview: end-user programming. In: CHI Extended Abstracts on Human Factors in Computing Systems (2006)
Paterno, F.: End user development: survey of an emerging field for empowering people. ISRN Softw. Eng. (2013)
Sammet, J.E.: The use of English as a programming language. Commun. ACM 9, 228–230 (1966)
Sestoft, P., Sørensen, J.Z.: Sheet-defined functions: implementation and initial evaluation. In: Dittrich, Y., Burnett, M., Mørch, A., Redmiles, D. (eds.) IS-EUD 2013. LNCS, vol. 7897, pp. 88–103. Springer, Heidelberg (2013). https://doi.org/10.1007/978-3-642-38706-7_8
Spahn, M., Dorner, C., Wulf, V.: End user development: approaches towards a flexible software design. In: ECIS, pp. 303–314 (2008)
Statistical Office of the European Union: Population on 1 January by age and sex (2017). http://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=demo_pjan
Statistical Office of the European Union: House price index - annual data (2018). http://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=prc_hpi_a
Ortiz, C.L.: The road to natural conversational speech interfaces. IEEE Internet Comput. 18, 74–78 (2014)
Tichy, W.F., Landhäußer, M., Körner, S.: Universal programmability - how AI can help. Artificial Intelligence Synergies in Software Engineering, May 2013
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Wachtel, A., Fuchß, D., Przybylla, M., Tichy, W.F. (2019). Natural Language Data Queries on Multiple Heterogenous Data Sources. In: Malizia, A., Valtolina, S., Morch, A., Serrano, A., Stratton, A. (eds) End-User Development. IS-EUD 2019. Lecture Notes in Computer Science(), vol 11553. Springer, Cham. https://doi.org/10.1007/978-3-030-24781-2_13
Download citation
DOI: https://doi.org/10.1007/978-3-030-24781-2_13
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-24780-5
Online ISBN: 978-3-030-24781-2
eBook Packages: Computer ScienceComputer Science (R0)