Abstract
Public relational databases are accessed by end users to get the information they require. Direct interaction with relational databases requires the knowledge of structured query language (SQL). It is not feasible for every user to learn SQL. An access through an application limits the query options. An end user can ask a query very easily in a natural language. To provide the full advantages of public access, the users should be allowed to query the required data through natural language questions. It is possible by providing natural language support to query relational databases. This paper presents the system model, design and implementation to query relational databases in Punjabi language. It allows human–machine interaction in Punjabi language for information retrieval. It accepts a Punjabi language query in flexible format, uses pattern matching techniques to prepare an SQL query from it, maps data element tokens of the query to actual database objects and joins multiple tables to fetch the required data.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
O’Neil P (1994) Database design. In: Database, pp 293–384. https://doi.org/10.1016/b978-1-4831-8404-3.50008-3
Arenas M (2018) Normal forms and normalization. In: Encyclopedia of database systems, pp 2509–2513. https://doi.org/10.1007/978-1-4614-8265-9_1237
Zhang P (2017) Joins. In: Practical guide to oracle SQL, T-SQL and MySQL, pp 137–145. https://doi.org/10.1201/9781315101873-10
Lips M (2019) Open and transparent government. In: Digital government, pp 106–131. https://doi.org/10.4324/9781315622408-5
Mabuni D (2017) User interfaces to databases—a survey. Int J Adv Res Comput Sci 8(9):710–713. https://doi.org/10.26483/ijarcs.v8i9.5201
Foster EC, Godbole S (2016) Database user interface design. In: Database systems, pp 139–153. https://doi.org/10.1007/978-1-4842-1191-5_6
Krägeloh K-D, Lockemann PC (n.d.) Access to data base systems via natural language. In: Natural language communication with computers, pp 49–86. https://doi.org/10.1007/bfb0031369
Juan B, González J, Rangel P, Cruz C IC, Héctor H, Fraire J, de Santos Aguilar L, Joaquín Pérez O (2006) Issues in translating from natural language to SQL in a domain-independent natural language interface to databases. In: MICAI 2006: advances in artificial intelligence, pp 922–931. https://doi.org/10.1007/11925231_88
Reinaldha F, Widagdo TE (2014) Natural language interfaces to database (NLIDB): question handling and unit conversion. In: 2014 International conference on data and software engineering (ICODSE). https://doi.org/10.1109/icodse.2014.7062663
Li M, Du X-Y, Wang S (2005) Learning ontology from relational database. In: 2005 International conference on machine learning and cybernetics. https://doi.org/10.1109/icmlc.2005.1527531
Agrawal R, Chakkarwar A, Choudhary P, Jogalekar UA, Kulkarni DH (2014) DBIQS—An intelligent system for querying and mining databases using NLP. In: 2014 International conference on information systems and computer networks (ISCON). https://doi.org/10.1109/iciscon.2014.6965215
Kataria A, Nath R (2015) Natural language interface for databases in Hindi based on Karaka theory. Int J Comput Appl 122(7):39–43. https://doi.org/10.5120/21716-4841
Shabaz K, O’Shea JD, Crockett K, Latham A (2015) Aneesah: a conversational natural language interface to databases. In: World congress on engineering. URL: http://www.iaeng.org/publication/WCE2015/
Sangeeth N, Rejimoan R (2015) An intelligent system for information extraction from relational database using HMM. In: 2015 International conference on soft computing techniques and implementations (ICSCTI). https://doi.org/10.1109/icscti.2015.7489594
Ghahramani Z (2001) An introduction to hidden Markov models and Bayesian networks. In: Hidden Markov models, pp 9–41. https://doi.org/10.1142/9789812797605_0002
Goodman S, BenYishay A, Lv Z, Runfola D (2019) GeoQuery: integrating HPC systems and public web-based geospatial data tools. Comput Geosci 122:103–112. https://doi.org/10.1016/j.cageo.2018.10.009
Virk ZS, Dua M (2016) An advanced web-based Hindi language interface to database using machine learning approach. Lecture notes in computer science, pp 381–390. https://doi.org/10.1007/978-3-319-40349-6_36
Munekawa Y, Ino F, Hagihara K (2008) Design and implementation of the Smith-Waterman algorithm on the CUDA-compatible GPU. In: 2008 8th IEEE international conference on bioinformatics and bioengineering. https://doi.org/10.1109/bibe.2008.4696721
Laaksonen J, Oja E (1996) Classification with learning k-nearest neighbors. In: Proceedings of international conference on neural networks (ICNN’96). https://doi.org/10.1109/icnn.1996.549118
Bhattacharyya P (2016) IndoWordNet. In: The WordNet in Indian languages, pp 1–18. https://doi.org/10.1007/978-981-10-1909-8_1
Gupta V, Lehal GS (2011) Punjabi Language Stemmer for nouns and proper names. In: Proceedings of the 2nd workshop on South and Southeast Asian natural language processing (WSSANLP), IJCNLP 2011, Chiang Mai, Thailand, pp 35–39, 8 Nov 2011. URL: https://www.aclweb.org/anthology/W11-3006
Kaur J, Saini JR (2016) Punjabi stop words. In: Proceedings of the ACM symposium on women in research 2016, WIR’16. https://doi.org/10.1145/2909067.2909073
Melamed ID, Green R, Turian JP (2003) Precision and recall of machine translation. In: Proceedings of the 2003 conference of the North American chapter of the association for computational linguistics on human language technology companion volume of the proceedings of HLT-NAACL 2003. Short papers, NAACL’03. https://doi.org/10.3115/1073483.1073504
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Singh, H., Oberoi, A. (2021). Query Relational Databases in Punjabi Language. In: Singh, V., Asari, V., Kumar, S., Patel, R. (eds) Computational Methods and Data Engineering. Advances in Intelligent Systems and Computing, vol 1227. Springer, Singapore. https://doi.org/10.1007/978-981-15-6876-3_26
Download citation
DOI: https://doi.org/10.1007/978-981-15-6876-3_26
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-6875-6
Online ISBN: 978-981-15-6876-3
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)