doi: 10.17586/2226-1494-2018-18-2-262-267


DATABASE SEMANTIC MODEL APPLICATION IN NATURAL LANGUAGE USER INTERFACE DEVELOPMENT PROCESS

R. V. Posevkin


Read the full article  ';
Article in Russian

For citation: Posevkin R.V. Database semantic model application in natural language user interface development process. Scientific and Technical Journal of Information Technologies, Mechanics and Optics, 2018, vol. 18, no. 2, pp. 262–267 (in Russian). doi: 10.17586/2226-1494-2018-18-2-262-267

Abstract

Subject of Research.The paper considers common natural language processing stages such as morphological, syntactic and semantic analysis. We describe connections between query parts, semantic model and internal database representation. Method. A method is proposed for the database semantic model application as a part of the natural language user database interface. There is a description of the semantic model data transforms to intermediate Q-representation of the user query. The next step is transforming of Q-representation to database SQL query based on substitution to predefined query template. Main Results. We give an account of the semantic model application as a part of natural language user interface. An example is provided of the transformation of both simple and nested natural language user queries to the database SQL query. The paper presents experimental research results of the proposed method of the semantic model application as a part of the natural language user database interface. Practical Relevance. Implementation of the proposed approach gives the possibility to resolve the problem of extracting information from the database based on user’s natural language query. This method also improves the process of resolving the ambiguity during natural language processing. The presence of information about internal database structure makes it possible to create more accurate database SQL query.


Keywords: user interface, natural language text, database, semantic mode, SQL query

References
    
  1. Llopis M., Ferrandez A. How to make a natural language interface to query databases accessible to everyone: an example. Computer Standards and Interfaces, 2013, vol. 35, no. 5, pp. 470–481. doi: 10.1016/j.csi.2012.09.005
  2. Zhou L., Mohammed A.S., Zhang D. Mobile personal information management agent: supporting natural language interface and application integration. Information Processing and Management, 2012, vol. 48, no. 1, pp. 23–31. doi: 10.1016/j.ipm.2011.08.008
  3. Codd E. Seven steps to rendezvous with the casual user. In Data Base Management. Eds. J. Kimbie, K. Koffeman. North-Holland Publ., 1974, pp. 179–200.
  4. Li F., Jagadish H.V. NaLIR: an interactive natural language interface for querying relational databases. Proc. 2014 ACM SIGMOD Int. Conf. on Management of Data. Snowbird, USA, 2014, pp. 709–712. doi: 10.1145/2588555.2594519
  5. Mikolov T., Sutskever I., Chen K., Corrado G., Dean J. Distributed representations of words and phrases and their compositionality. Proc. 26th Int. Conf. on Neural Information Processing Systems, 2013, pp. 3111–3119.
  6. Giordani A., Moschitti A. Semantic mapping between natural language questions and SQL queries via syntactic pairing. Lecture Notes in Computer Science, 2009, vol. 5723,
    pp. 207–221. doi: 10.1007/978-3-642-12550-8_17
  7. Suleimanov D.Sh. Two-level linguistic processor of response texts in natural language. Proc. Int. Conf. OSTIS-2011. Minsk, 2011, pp. 311–322. (In Russian)
  8. Posevkin R., Bessmertny I. Multilanguage natural user interface to database. Proc. 10th Int. Conf. on Application of Information and Communication Technologies. Baku, Azerbaijan, 2016, pp. 304–306. doi: 10.1109/ICAICT.2016.7991706
  9. Posevkin R.V., Bessmertnyi I.A. Natural language user interface of a dialogue systems. Software and Systems, 2016, no. 3, pp. 5–9. (In Russian) doi: 10.15827/0236-235X.115.005-009
  10. Bhadgale A.M., Gavas S.R., Goyal P.R. Natural language to SQL conversion system. International Journal of Computer Science Engineering and Information Technology Research, 2013, vol. 3, no. 2, pp. 161–166.
  11. Wang C. et al. PANTO: a portable natural language interface to ontologies. Lecture Notes in Computer Science, 2007, vol. 4519, pp. 473–487.
  12. Pravikov A.A., Fomichov V.A. The design of a recommender system with natural language interface of the basis of mathematical models of semantic objects. Biznes-Iinformatika, 2010, no. 4, pp. 3–11. (In Russian)
  13. Nihalani M.N., Silakari S., Motwani M. Natural language interface for database: a brief review. International Journal of Computer Science Issues, 2011, vol. 8, no. 2, pp. 600–608.
  14. Pan S., Shaw J. Natural language query recommendation in conversation systems. Proc. 20th Int. Joint Conf. on Artificial Intelligence. Hyderabad, India, 2007, pp. 1701–1706.
  15. Fomichev V.A. Mathematical Basics for Representation of Messages Contents of Computer Intelligent Agents. Moscow, VShE Publ., 2007, 174 p. (In Russian)
  16. Hemphill С., Godfrey J., Doddington G. The ATIS spoken language systems pilot corpus. Proceedings of Workshop on Speech and Natural Language. Hidden Valley, USA, 1990, pp. 96–101. doi: 10.3115/116580.116613
  17. Haas C., Riezler S. A corpus and semantic parser for multilingual natural language querying of openstreetmap. Proc. NAACL-HLT, 2016, pp. 740–750.
  18. Brad F., Iacob R., Hosu I., Rebedea T. Dataset for a neural natural language interface for databases. Proc. 8th Int. Joint Conf. on Natural Language Processing, 2017, pp. 906–914.
  19. Tablan V., Damljanovic D., Bontcheva K. A natural language query interface to structured. Lecture Notes in Computer Science, 2008, vol. 5021, pp. 361–375. doi: 10.1007/978-3-540-68234-9_28


Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License
Copyright 2001-2024 ©
Scientific and Technical Journal
of Information Technologies, Mechanics and Optics.
All rights reserved.

Яндекс.Метрика