Abstract: The digital India program encourages Indian citizens to become conversant with e-services which are primarily English language-based services. However, the vast majority of the Indian population is comfortable with vernacular languages like Bengali, Assamese, Hindi, etc. The rural villagers are not able to interact with the Relational Database Management system in their native language. Therefore, create a system that produces SQL queries from natural language queries in Bengali, containing ambiguous words. This paper proposes a Bengali Query Processor named Extended Bengali language Query Processing System (XBLQPS) to handle queries containing ambiguous words posted to a Healthcare Information database in the electronic domain. The Healthcare Information database contains doctor, hospital and department details in the Bengali language. The proposed system provides support for the Bengali-speaking Indian rural population to efficiently fetch required information from the database. The proposed system extracts the Bengali root word by removing the inflectional part and categorizing them to a specific part of speech (POS) using modified Bengali WordNet. The proposed system uses manually annotated parts of speech detection of a word based on Bengali WordNet. Patterns of noun phrases are generated to detect the correct noun phrase as well as entity and attribute(s). Entity and attributes are used to prepare the semantic table which is utilized to create the Structured Query Language (SQL). The simplified LESK method is utilized to resolve ambiguous Bengali phrases in this query processing system. The accuracy, precision, recall and F1 score of the system is measured as 70%, 74%, 73%, and 73% respectively.

Kailash Pati Mandal, Prasenjit Mukherjee, Atanu Chattopadhyay and Baisakhi Chakraborty, “XBLQPS: An Extended Bengali Language Query Processing System for e-Healthcare Domain” International Journal of Advanced Computer Science and Applications(IJACSA), 13(7), 2022. http://dx.doi.org/10.14569/IJACSA.2022.0130761

@article{Mandal2022,
title = {XBLQPS: An Extended Bengali Language Query Processing System for e-Healthcare Domain},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2022.0130761},
url = {http://dx.doi.org/10.14569/IJACSA.2022.0130761},
year = {2022},
publisher = {The Science and Information Organization},
volume = {13},
number = {7},
author = {Kailash Pati Mandal and Prasenjit Mukherjee and Atanu Chattopadhyay and Baisakhi Chakraborty}
}