Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique
Uložené v:
| Názov: | Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique |
|---|---|
| Zdroj: | International Journal of Innovative Technology and Exploring Engineering. 9:222-228 |
| Informácie o vydavateľovi: | Blue Eyes Intelligence Engineering and Sciences Engineering and Sciences Publication - BEIESP, 2019. |
| Rok vydania: | 2019 |
| Popis: | In Structured Query Language (SQL), complex queries are difficult to write or understand by a user, because every user is not familiar with SQL. A common user can able to retrieve the information from the query databases using natural language is considered as an important research area. To improve the communication between databases application and naive user, an enhanced application with intelligent interface are needed. A fuzzy system with matching and elimination technique is designed in this research study, where SQL queries are formed from the input given by the user through several steps like noise removal, lexicon normalization and query formation. Then, the system uses the Latent Dirichlet Allocation (LDA) to extract the keywords from the input query. Finally, matching and elimination techniques are used to find the data, which is related to the input query given by end-user. When compared with the existing SQL techniques, the proposed fuzzy method achieved 91% and 90.5% accuracy, 95% and 93% precision, and 0.10 and 0.12 error rate for both 28 and 50 queries. |
| Druh dokumentu: | Article |
| Jazyk: | English |
| ISSN: | 2278-3075 |
| DOI: | 10.35940/ijitee.b1132.1292s19 |
| Prístupové číslo: | edsair.doi...........099bf0d69ed6004d2b85d25cb2bae367 |
| Databáza: | OpenAIRE |
Nájsť tento článok vo Web of Science | Abstrakt: | In Structured Query Language (SQL), complex queries are difficult to write or understand by a user, because every user is not familiar with SQL. A common user can able to retrieve the information from the query databases using natural language is considered as an important research area. To improve the communication between databases application and naive user, an enhanced application with intelligent interface are needed. A fuzzy system with matching and elimination technique is designed in this research study, where SQL queries are formed from the input given by the user through several steps like noise removal, lexicon normalization and query formation. Then, the system uses the Latent Dirichlet Allocation (LDA) to extract the keywords from the input query. Finally, matching and elimination techniques are used to find the data, which is related to the input query given by end-user. When compared with the existing SQL techniques, the proposed fuzzy method achieved 91% and 90.5% accuracy, 95% and 93% precision, and 0.10 and 0.12 error rate for both 28 and 50 queries. |
|---|---|
| ISSN: | 22783075 |
| DOI: | 10.35940/ijitee.b1132.1292s19 |