Abstract
Accessing information is a vital activity in businesses; therefore, databases (DBs) have become necessary tools for storing their information. However, for accessing the information stored in a database, it is necessary to use a DB query language, such as SQL. Natural language interfaces to databases (NLIDBs) allow inexperienced users to obtain information from a DB using natural language expressions without the need of using a DB query language. Despite the relative effectiveness of NLIDBs, most of the approaches proposed for designing NLIDBs ignore the possibility that the DB to be queried could be poorly designed; i.e., it could have design anomalies. Unfortunately, various experiments (described in this paper) show that DB anomalies degrade the performance (recall) of NLIDBs. The purpose of this paper is to analyze the most common DB design anomalies for proposing solutions to this problem and avoid performance degradation of NLIDBs when accessing such DBs.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
O. Pivert, H. Prade, Handling dirty databases: from user warning to data cleaning towards an interactive approach. in Fourth International Conference on Scalable Uncertainty Management (France, 2010)
M.L. Pedro de Jesus, P.M.A. Sousa, Selection of reverse engineering methods for relational databases. in Proceedings of the European Conference on Software Maintenance and Reengineering. (1999)
N. Mofourga, Extracting entity-relationship schemas from relational databases: a form-driven approach, in Proceedings of the Fourth Working Conference on Reverse Engineering (IEEE, 1997)
P. Rob, C. Coronel, in Database Systems: Design, Implementation, and Management. 8th edn. (Course Technology, 2009)
D. Kroenke, in Database Processing: Fundamentals, Design, and Implementation. Eighth edn. (Pearson Education, 2003)
C.J. Date, in The Relational Database Dictionary, Extended Edition (O’Reilly Media, 2008)
C.J. Date, in An Introduction to Database Systems, 8th edn. (Pearson Education, 2004)
M. Minock, C-phrase: a system for building robust natural language interfaces to databases. Data Knowl. Eng. 69, 290–302 (2010)
S. Conlon, J. Conlon, T. James, The economics of natural language interfaces: natural language processing technology as a scarce resource. Decis. Support Syst. 38(1), 141–159 (2004)
A. Giordani, A. Moschitti, Translating queries with generative parsers discriminatively reranked, in Proceedings of Computational Linguistics (Mumbai, 2012), pp. 401–410
I. Esquivel, R. Córdoba, D. González, E. Ogarita, SNL2SQL: Conversión de consultas en SQL al idioma Español, in Congreso internacional de investigación, ISSN:1946-5351, Vol. 5, No. 3, Mexico (2013)
F. Li, H.V. Jagadish, Constructing an interactive natural language interface for relational databases. Proc. VLBD Endow. 8(1) (2014)
J.D. O’Shea, K. Shabaz, K.A. Crockett, Aneesah: a conversational natural language interface to databases, in Proceedings of World Congress on Engineering 2015, vol. 1 (London, 2015)
Y. Amsterdamer, A. Kukliansky, T. Milo, A natural language interface for querying general and individual knowledge. Proc. VLDB Endow. 8(12) (2015)
K. ElSayed, An Arabic natural language interface system for a database of the Holy Quran. Int. J. Adv. Res. Artif. Intell. (IJARAI 4(7) (2015)
A. Kataria, R. Nath, Natural language interface for databases in hindi based on karaka theory. Int. J. Comput. Appl. 122(7), India (2015)
R.A. Pazos, M.A. Aguirre, J.J. González, J.A. Martínez, J. Pérez, A.A. Verástegui, Comparative study on the customization of natural language interfaces to databases, SpringerPlus, doi:10.1186/s40064-016-2164-y (2016)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this chapter
Cite this chapter
Pazos R., R.A., Martínez F., J.A., Aguirre L., A.G., Aguirre L., M.A. (2018). Issues in Querying Databases with Design Anomalies Using Natural Language Interfaces. In: Castillo, O., Melin, P., Kacprzyk, J. (eds) Fuzzy Logic Augmentation of Neural and Optimization Algorithms: Theoretical Aspects and Real Applications. Studies in Computational Intelligence, vol 749. Springer, Cham. https://doi.org/10.1007/978-3-319-71008-2_33
Download citation
DOI: https://doi.org/10.1007/978-3-319-71008-2_33
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-71007-5
Online ISBN: 978-3-319-71008-2
eBook Packages: EngineeringEngineering (R0)