Skip to main content
SpringerLink
Log in

Query Relational Databases in Punjabi Language

  • Conference paper
  • First Online:
Computational Methods and Data Engineering

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 1227))

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.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    http://www.cfilt.iitb.ac.in/indowordnet/.

References

  1. O’Neil P (1994) Database design. In: Database, pp 293–384. https://doi.org/10.1016/b978-1-4831-8404-3.50008-3

  2. 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

  3. Zhang P (2017) Joins. In: Practical guide to oracle SQL, T-SQL and MySQL, pp 137–145. https://doi.org/10.1201/9781315101873-10

  4. Lips M (2019) Open and transparent government. In: Digital government, pp 106–131. https://doi.org/10.4324/9781315622408-5

  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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

    Article  Google Scholar 

  13. 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/

  14. 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

  15. 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

  16. 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

    Article  Google Scholar 

  17. 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

  18. 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

  19. 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

  20. Bhattacharyya P (2016) IndoWordNet. In: The WordNet in Indian languages, pp 1–18. https://doi.org/10.1007/978-981-10-1909-8_1

  21. 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

  22. 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

  23. 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

Download references

Author information

Authors and Affiliations

  1. Punjabi University Patiala, Patiala, India

    Harjit Singh

  2. RIMT University, Mandi-Gobindgarh, India

    Ashish Oberoi

Authors
  1. Harjit Singh
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ashish Oberoi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Harjit Singh .

Editor information

Editors and Affiliations

  1. School of Computer Science, University of Petroleum and Energy Studies, Dehradun, Uttarakhand, India

    Vijendra Singh

  2. Department of Electrical and Computer Engineering, University of Dayton, Dayton, OH, USA

    Vijayan K. Asari

  3. Department of Computer Science and Engineering, SRM University Delhi-NCR, Sonepat, Haryana, India

    Sanjay Kumar

  4. Department of Computer Science and Engineering, Chandigarh College of Engineering and Technology, Chandigarh, Punjab, India

    R. B. Patel

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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

Publish with us

Policies and ethics

Search

Navigation