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.
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
Similar content being viewed by others
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)