Skip to main content
SpringerLink
Log in

A model of a generic Arabic language interface for multimodel database

  • Published:
International Journal of Speech Technology Aims and scope Submit manuscript

Abstract

The extraction of the information from database systems requires the formulation of queries using database query languages, such as Structured Query Language (SQL). This formulation needs the knowledge of the model and the structure of the database. However, non-expert users cannot write such queries. This is why a lot of works have been developed to query the database in natural language. Historically, most of these works were carried out for English language and they were designed for a specific database model. Some of them function independently of database domain. But, until now there is no system that functions independently of both database model and domain. For the Arabic language, all existing contributions are dependent on database domain and model. This paper presents a generic natural language interface to query databases using the Arabic language. This interface functions independently of the database domain and model (relational and XML). Furthermore, the use of machine learning helps our system to improve its knowledge base automatically through experience.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6

Similar content being viewed by others

References

  • Ahmad, R., Khan, M. A., & Ali, R. (2009). Efficient transformation of a natural language query to SQL for Urdu. In: Proceedings of the Conference on Language and Technology, pp. 53–60.

  • Akerkar, R., & Joshi, M. (2008). Natural language interface using shallow parsing. International Journal of Computer Science & Applications, 5, 70–90.

    Google Scholar 

  • Alian, M., Awajan, A., & Al-Kouz, A. (2016). Word sense disambiguation for Arabic text using wikipedia and vector space model. International Journal of Speech Technology, 19, 857–867.

    Article  Google Scholar 

  • Alonso-Lavernia, M. l. Á., De-la-Cruz-Rivera, A. V., & Sidorov, G. (2006). Generation of natural language explanations of rules in an expert system. In: Proceedings of the International Conference on Applications of Digital Information and Web Technologies 7th International Conference:CICLing 3878, pp. 311–314.

  • Al-Rababah, K., & Shatnawi, S. (2012). An Arabic language interface to databases using a morphologically-based lexicon, language indicators, and pos tagging. International Journal of Multimedia and Image Processing, 2, 87–95.

    Article  Google Scholar 

  • Alruily, M., Ayesh, A., & Zedan, H. (2014). Crime profiling for the Arabic language using computational linguistic techniques. Information Processing & Management, 50, 315–341.

    Article  Google Scholar 

  • Androutsopoulos, I., Ritchie, G., & Thanisch, P. (1995). Natural language interfaces to databases—An introduction. Natural Language Engineering, 1, 29–81.

    Article  Google Scholar 

  • Auxerre, P., & Inder, R. (1986). MASQUE Modular Answering System for Queries in English, User's Manual, technical report AIAI/SR/10, Artificial Intelligence Applications Institute, University of Edinburgh.

  • ElSayed, K. N. (2015). An Arabic natural language interface system for a database of the Holy Quran. ijarai 4.

  • Hemerelain, B., & Belbachir, H. (2010). Semantic analysis of natural language queries for an object oriented database. JSEA, 03, 1047–1053.

    Article  Google Scholar 

  • Kataria, A., & Nath, R. (2015). Natural language interface for databases in Hindi based on Karaka Theory. International Journal of Computer Applications, 122, 39–43.

    Article  Google Scholar 

  • Khoufi, N., Aloulou, C., & Belguith, L. H. (2016). Parsing Arabic using induced probabilistic context free grammar. International Journal of Speech Technology, 19, 313–323.

    Article  Google Scholar 

  • Kokarea, R., & Wanjaleb, K. (2015). A natural language query builder interface for structured databases using dependency parsing. I.J. Mathematical Sciences and Computing, 4, 11–20.

    Article  Google Scholar 

  • Li, Y., Yang, H., & Jagadish, H. V. (2005). Nalix: An interactive natural language interface for querying XML. In: SIGMOD '05: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, pp. 900–902.

  • Li, Z., Li, J., & Ning, W. (2015). Research on Chinese natural language query interface to database based on syntax and semantic. Applied Mechanics and Materials, 731, 237–241.

    Article  Google Scholar 

  • Llopis, M., & Ferrández, A. (2013). How to make a natural language interface to query databases accessible to everyone: An example. Computer Standards & Interfaces, 35, 470–481.

    Article  Google Scholar 

  • Mansour, N., Haraty, R., Daher, W., & Houri, M. (2008). An auto-indexing method for Arabic text. Information Processing & Management, 44, 1538–1545.

    Article  Google Scholar 

  • Meng, X., Zhou, Y., & Wang, S. (2002). Domain knowledge extracting in a Chinese natural language interface to databases: NChiql. Methodologies for Knowledge Discovery and Data Mining, 1574, 179–183.

    Google Scholar 

  • Mishra, A., & Jain, S. K. (2016). A survey on question answering systems with classification. Journal of King Saud University - Computer and Information Sciences, 28, 345–361.

    Article  Google Scholar 

  • Mohammed, F., Nasser, K., & Harb, H. (1993). A knowledge based Arabic question answering system (AQAS). ACM SIGART Bulletin, 4, 21–30.

    Article  Google Scholar 

  • Mony, M., Rao, J. M., & Potey, M. M. (2014). An Overview of NLIDB approaches and implementation for airline reservation system. International Journal of Computer Applications, 107, 36–41.

    Article  Google Scholar 

  • Nanda, G., Dua, M, & Singla, K. (2016). A Hindi question answering system using machine learning approach. In : Proceedings of the International Conference on Computational Techniques in Information and Communication Technologies.

  • Otair, M., Al-Sardi, R., & Al-Gialain, S. (2008). An Arabic retrieval system with native language rather than SQL queries. In: Proceedings of the International Conference on Applications of Digital Information and Web Technologies, pp. 84–89.

  • Papadakis, N., Kefalas, P., & Stilianakakis, M. (2011). A tool for access to relational databases in natural language. Expert Systems with Applications, 38, 7894–7900.

    Article  Google Scholar 

  • Popescu, A.-M., Armanasu, A., Etzioni, O., Ko, D., & Yates, A. (2004). Modern natural language interfaces to databases: Composing statistical parsing with semantic tractability. In: Proceedings of the COLING'04.

  • Rangel, R. A. P., Gelbukh, A. F., Barbosa, J. J. G., Ruiz, E. A., Mej́ıa, A. M., & Sánchez, A. P. D. (2002). Spanish natural language interface for a relational database querying system. In: Proceedings of the 5th International Conference, TSD 2002 Brno, Czech Republic 2448, pp. 123-130.

  • Reis, P., Matias, J., & Mamede, N. (1997). Edit—A natural language interface to databases: A new dimension for an old approach. In: Proceedings of the International Conference in Edinburgh, Scotland, pp. 317–326.

  • Shabaz, K., O’Shea, J., Crockett, K., & Latham, A. (2015). ANEESAH: a conversational natural language interface to databases. World Congress on Engineering, London UK, 1, 227–232.

    Google Scholar 

  • Shafique, U., & Qaiser, H. (2014). A comprehensive study on natural language processing and natural language interface to databases. International Journal of Innovation and Scientific Research, 9, 297–306.

    Google Scholar 

  • Sujatha, B., & Raju, S. V. (2015), A generic model for natural language interface to database. In: Proceedings of the 6th International Advanced Computing Conference, vol. 1, pp. 73–77.

  • Sujatha, B., & Raju, S. (2016). Ontology-based natural language interface for relational databases. Procedia Computer Science, 92, 487–492.

    Article  Google Scholar 

  • Tari, L., Tu, P. H., Hakenberg, J., Chen, Y., Son, T. C., Gonzalez, G., & Baral, C. (2010). Parse tree database for information extraction. In: Proceedings of IEEE transactions on knowledge and data.

  • Warren, D., & Pereira, F. (1982). An Efficient for interpreting easily adaptable system natural language queries. American Journal of Computational Linguistics, 8, 110–122.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Universite Ibn Zohr, Agadir, Morocco

    Bais Hanane, Mustapha Machkour & Lahcen Koutti

Authors
  1. Bais Hanane
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Mustapha Machkour
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Lahcen Koutti
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Bais Hanane.

Additional information

Publisher's Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Hanane, B., Machkour, M. & Koutti, L. A model of a generic Arabic language interface for multimodel database. Int J Speech Technol 23, 669–681 (2020). https://doi.org/10.1007/s10772-020-09740-9

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10772-020-09740-9

Keywords

Search

Navigation