Databases act as repository of data for various applications. In today’s scenario every organization has the database to store data and database management systems to access that data. SQL (Structured Query Language) is the language of database management system which is a specific language used to write statements against Relational Database Management Systems to retrieve and manipulate data. But the common user asks query in his/her natural language such as Punjabi Language. That natural language query is not understandable to the computer and hence RDBMS cannot process that query. That natural language query can be processed through Natural Language Processing to understand what kind of data the user wants to retrieve. From that natural language query, we need to retrieve data from the database. To automate the process, various data elements need to be extracted from the Punjabi Language query. These data elements include Entity, Attributes, Condition etc. This paper explains the process of extracting Data Elements from the Punjabi Language query.

Natural Language Processing, Punjabi Language Processing, Data Element Extraction, Structured Query Language (SQL)

[1] Joseph, Sethunya & Sedimo, Kutlwano & Kaniwa, Freeson & Hlomani, Hlomani & Letsholo, Keletso, “Natural Language Processing: A Review”,Natural Language Processing: A Review, 6, 207-210, 2016
[2] Reshamwala, Alpa & Mishra, Dhirendra & Pawar, Prajakta, “Review on Natural Language Processing”, IRACST – Engineering Science and Technology: An International Journal (ESTIJ), 3, 113-116, 2013
[3] Srivastava, Siddhant & Shukla, A & Tiwari, Ritu, “Machine Translation : From Statistical to modern Deep-learning practices”, arXiv preprint, arXiv:1812.04238, 2018
[4] Sundar Ram R, Vijay & Lalithadevi, Sobha, “Overview of Verb Phrase Translation in Machine Translation: English to Tamil and Hindi to Tamil”, Conference: the 10th annual meeting of the Forum for Information Retrieval Evaluation, 6-10. DOI: 10.1145/3293339.3293341, 2018
[5] T.K, Bijimol & , Professor & Abraham, Johnt, “A Study of Machine Translation Methods An Analysis of Malayalam Machine Translation Systems”, Conference: NCILC-14, At CUSAT, Cochin, 2014
[6] Sinhal, Ruchika & Gupta, Kapil, “Machine Translation Approaches and Design Aspects” IOSR Journal of Computer Engineering, 16, 22-25, DOI:10.9790/0661-16122225, 2014
[7] Fadiel Alawneh, Mouiad & Sembok, Tengku, “Rule-Based and Example-Based Machine Translation from English to Arabic”, Conference: Bio-Inspired Computing: Theories and Applications (BIC-TA), 2011 Sixth International Conference, 343 – 347, DOI: 10.1109/BIC-TA.2011.76, 2011
[8] M. D. Okpor, “Machine Translation Approaches: Issues and Challenges”, IJCSI International Journal of Computer Science Issues, Vol. 11, Issue 5, No 2, September 2014
[9] Shantanoo Dubey, “Survey of Machine Translation Techniques”, International Journal of Advance Research in Computer Science and Management Studies, Special Issue, Volume 5, Issue 2, February 2017
[10] Krishnamurthy, Parameswari, “Development of Telugu-Tamil Transfer-Based Machine Translation System: An Improvization Using Divergence Index”, Journal of Intelligent Systems, DOI: 10.1515/jisys-2018-0214, 2018
[11] Dash, Niladri & Ramamoorthy, L., “Corpus and Machine Translation”, In book: Utility and Application of Language Corpora, pp, 193-217, DOI: 10.1007/978-981-13-1801-6_12, 2019
[12] Mahata, Sainik Kumar & Mandal, Soumil & Das, Dipankar & Bandyopadhyay, Sivaji, “SMT vs NMT: A Comparison over Hindi & Bengali Simple Sentences”, Proc. of ICON-2018, Patiala, India, pages 175–182, December 2018
[13] Carl, Michael & Way, Andy & Daelemans, Walter, “Recent Advances in Example-Based Machine Translation”, Computational Linguistics, 30, 516-520, DOI: 10.1162/0891201042544866, 2004