Abstract
In most business activities, decision-making has a very important role, since it may benefit or harm the business. Nowadays decision-making is based on information obtained from databases, which are only accessible directly by computer experts; however, the end-user that requires information from a database is not always a computer expert, so the need arises to allow inexperienced users to obtain information directly from a database. To this end, several tools are commercially available such as visual query building and natural language interfaces to databases (NLIDBs). However, the first kind of tools requires at least a basic level of knowledge of some formal query language, while NLIDBs, despite the fact that users do not require training for using the interface, have not obtained the desired performance due to problems inherent to natural language processing. In this paper an intuitive interface is presented, which allows inexperienced users to easily compose queries in SQL, without the need of training on its operation nor having knowledge of SQL.
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
References
Chai, J., Pan, S., Zhou, M.: MIND: a context-based multimodal interpretation framework in conversational systems. In: Van Kuppevelt, J.C.J., Dybkjær, L., Bernsen, N.O. (eds.) Advances in Natural Multimodal Dialogue Systems Text, Speech and Language Technology, vol. 30, pp. 265–285. Springer, Netherlands (2005)
Agrawal, A., Kakde, O.: Semantic analysis of natural language queries using domain ontology for information access from database. Int. J. Intell. Syst. Appl. 5, 81–90 (2013)
Pazos, R., Aguirre, M., Gonzalez, J., Carpio, J.: Features and pitfalls that users should seek in natural language interfaces to databases. In: Castillo, O., Melin, P., Pedrycz, W., Kacprzyk, J. (eds.) Studies in Computational Intelligence, vol. 547, pp. 617–630. Springer, Heidelberg (2014)
Pazos, R., González, J., Aguirre, M.: Semantic model for improving the performance of natural language interfaces to databases. In: Batyrshin, I., Sidorov, G. (eds.) MICAI 2011. LNCS, vol. 7094, pp. 227–290. Springer, Heidelberg (2011)
Zhang, G., Chu, W., Meng, F., Kong, G.: Query formulation from high-level concepts for relational databases. In: User Interfaces to Data Intensive Systems, pp. 64–74. IEEE Computer Society, Los Alamitos, CA (1999)
Hallet, C., Scott, D., Power, R.: Composing questions through conceptual authoring. Computational linguistics 33(1), 105–133 (2007)
Pan, S., Zhou, M., Houck, K., Kissa, P.: Natural language aided visual query building for complex data access. In: 22nd Innovative Applications of Artificial Intelligence Conference (IAAI-10), pp. 1821–1826. Association for the Advancement of Artificial Intelligence, Palo Alto, CA (2010)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Pazos R., R.A., Aguirre L., A.G., Aguirre L., M.A., Martínez F., J.A. (2015). Interface for Composing Queries for Complex Databases for Inexperienced Users. In: Onieva, E., Santos, I., Osaba, E., Quintián, H., Corchado, E. (eds) Hybrid Artificial Intelligent Systems. HAIS 2015. Lecture Notes in Computer Science(), vol 9121. Springer, Cham. https://doi.org/10.1007/978-3-319-19644-2_6
Download citation
DOI: https://doi.org/10.1007/978-3-319-19644-2_6
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19643-5
Online ISBN: 978-3-319-19644-2
eBook Packages: Computer ScienceComputer Science (R0)