A Wizard for creating semantic views in a natural language interface to databases

Authors

  • Rodolfo A. Pazos Instituto Tecnológico de Cd. Madero, Mexico
  • José A. Martínez Instituto Tecnológico de Cd. Madero, Mexico
  • Héctor J. Fraire Instituto Tecnológico de Cd. Madero, Mexico
  • Héctor J. Puga Instituto Tecnológico de León, Mexico
  • Juana Gaspar Instituto Tecnológico de Cd. Madero, Mexico

DOI:

https://doi.org/10.61467/2007.1558.2022.v13i3.304

Keywords:

Natural language interface, Relational database, Semantic view

Abstract

When using natural language interfaces to databases (NLIDBs) for database queries that involve many tables, the resulting SQL query may include semantically implicit entities. These entities are related to the semantic meaning of a query, when upon referring to an entity (table), another entity (or entities) is (are) semantically implied with which the first entity is related, and the user might ignore the relationship between the two (or more) entities. In a previous work, this problem was addressed by using a semantic view. However, the configuration of the NLIDB is very complex for the database administrator for dealing with this kind of queries. This means that the semantic view can only be created and configured by the NLIDB developers. This article describes a method to configure a dictionary of semantic information to create a virtual semantic view in a NLIDB, thus facilitating the creation of semantic views in a NLIDB.

Author Biographies

Rodolfo A. Pazos, Instituto Tecnológico de Cd. Madero, Mexico

Rodolfo A. Pazos R. He graduated with honors as a communications and electronics engineer in 1973 from the Instituto Politécnico Nacional (Mexico). Dr. Pazos concluded an MS program in electrical engineering in 1976 at the Centro de Investigación y de Estudios Avanzados (Mexico) and obtained a PhD in computer science from the University of California at Los Angeles in 1983. He worked as researcher at the Centro de Investigación y Desarrollo de Telecomunicaciones (agency of the Ministry of Transportation and Communications, Mexico), researcher at the Instituto de Investigaciones Eléctricas (currently renamed as Instituto Nacional de Electricidad y Energías Limpias, Mexico), and researcher-professor at the Centro Nacional de Investigación y Desarrollo Tecnológico (Tecnológico Nacional de México). Dr. Pazos is currently working as researcher-professor at the Instituto Tecnológico de Ciudad Madero (Tecnológico Nacional de México). He holds a National Researcher distinction (from CONACYT, Mexico). He has published more than 60 articles in journals and over 120 papers in conference proceedings on natural language interfaces, distributed database systems and optimization algorithms

José A. Martínez, Instituto Tecnológico de Cd. Madero, Mexico

José A. Martínez F. He received a B.S. degree in computer systems engineering from the Instituto Tecnológico de Ciudad Madero (Tecnológico Nacional de México) in 1995. Dr. Martínez concluded an MS program in computer science in 1996 and obtained a PhD in computer science from the Centro Nacional de Investigación y Desarrollo Tecnológico (Tecnológico Nacional de México) in 2006. Dr. Martínez is currently working as full professor at the Instituto Tecnológico de Ciudad Madero (Tecnológico Nacional de México). He has published more than 12 articles in journals and over 20 papers in conference proceedings on natural language interfaces and optimization algorithms

Downloads

Published

2022-08-16

How to Cite

Pazos, R. A., Martínez, J. A., Fraire, H. J., Puga, H. J. ., & Gaspar, J. (2022). A Wizard for creating semantic views in a natural language interface to databases. International Journal of Combinatorial Optimization Problems and Informatics, 13(3), 34–42. https://doi.org/10.61467/2007.1558.2022.v13i3.304

Issue

Vol. 13 No. 3 (2022)

Section

Articles

License

Copyright (c) 2022 International Journal of Combinatorial Optimization Problems and Informatics

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Most read articles by the same author(s)