International Journal of Research in Signal Processing, Computing & Communication System Design

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

Speech to SQL Generator-A Voice Based Approach


Affiliations
1 B. V. Bhoomaraddi College of Engineering and Technology, Hubli, Karnataka, India
     

   Subscribe/Renew Journal


Recent developments in speech recognition system and natural language processing have given rise to a new generation of powerful voice-based interfaces. In this proposed system, a user interacts with the system through a voice-based user interface to fetch the desired results. To make the system smooth and interactive, the query is based on casual human speech / conversation. The spoken query undergoes many steps to arrive at the final results. It includes synonym table which is used to convert the spoken query into SQL keywords. The proposed work produce good results for simple and complex queries. The accuracy of the system depends on the complexity of the database. This system will show that the voice-based user interface is an effective means of querying and fetching data from the stored database.

Keywords

NLP, Speech, Speech to SQL, SQL, SQL Generator, Synonym Table.
User
Subscription Login to verify subscription
Notifications
Font Size

  • J. Weizenbaum, “ELIZA - A computer program for the study of natural language communication between man and machine,” Communications of the ACM, vol. 9, no. 1, pp. 36-45, January 1966.

  • T. Winograd, “Procedures as a representation for data in a computer program for understanding natural language,” MIT AI Technical Report 235, February 1971.

  • B.-B. Huang, G. Zang, and P. C.-Y. Sheu, “A natural language database interface based on probabilistic context free grammar,” IEEE International Workshop on Semantic Computing and Systems, Huangshan, China, 14-15 July 2008.

  • G. G. Hendrix, E. D. Sacerdoti, D. Sagalowicz, and J. Slocum, “Developing a natural language interface to complex data,” in ACM Transactions on Database Systems, vol. 3, no. 2, pp. 105-147, June 1978.

  • N. T. Dang, and D. T. T. Tuyen, “Natural language question answering model applied to document retrieval system,” World Academy of Science, Engineering and Technology, vol. 51, pp. 36-39, 2009.

  • S. Kumar, A. Kumar, P. Mitra, and G. Sundaram, “System and method for converting speech to SQL,” 2013. Available: arXiv preprint arXiv:1308.3106.

  • S. Jamoussi, K. Smali, and J.-P. Haton, “From speech to SQL queries: A speech understanding system,” The Twentieth National Conference on Artificial Intelligence Workshop on Spoken Language Understanding, Pittsburg, United States, 2005.

  • L. Blunschi, C. Jossen, D. Kossmann, M. Mori, and K. Stockinger, “Soda: Generating SQL for business users,” Proceedings of the VLDB Endowment, vol. 5, no. 10, pp. 932-943, 2012.

  • G. Singh, and A. Solanki, “An algorithm to transform natural language into SQL queries for relational databases,” Selforganizology, vol. 3, no. 3, pp. 100-116, 2016.

  • P. K. Ghosh, S. Dey, and S. Sengupta, “Automatic SQL query formation from natural language query,” in International Journal of Computer Applications, (0975-8887) International Conference on Microelectronics, Circuits and Systems (MICRO-2014).

  • P. P. Chaudhari, “Natural language statement to SQL query translator,” International Journal of Computer Applications, vol. 82, no. 5, pp. 18-22, 2013.

  • A. M. Bhadgale, R. Gavas, M. M. Patil, and P. R. Goyal, “Natural language to SQL conversion system,” IJCSEITR, vol. 3, no. 2, pp. 161-166, 2013.

  • D. V. Jose, A. Mustafa, and Sharan R., “A novel model for speech to text conversion,” International Refereed Journal of Engineering and Science (IRJES), vol. 3, no. 1, pp. 39-41, January 2014.

  • N. A. Nafis, and Md. S. Hossain, “Speech to text conversion in real time,” International Journal of Innovation and Scientific Research, vol. 17, no. 2, pp. 271-277, August 2015.

  • P. Khilari, and V. P. Bhope, “A review on speech to text conversion methods,” International Journal of Advanced Research in Computer Engineering & Technology, vol. 4, no. 7, pp. 3067-3072, July 2015.


Abstract Views: 148

PDF Views: 0




  • Speech to SQL Generator-A Voice Based Approach

Abstract Views: 148  |  PDF Views: 0

Authors

Shravankumar Hiregoudar
B. V. Bhoomaraddi College of Engineering and Technology, Hubli, Karnataka, India
Manjunath Gonal
B. V. Bhoomaraddi College of Engineering and Technology, Hubli, Karnataka, India
K. G. Karibasappa
B. V. Bhoomaraddi College of Engineering and Technology, Hubli, Karnataka, India

Abstract


Recent developments in speech recognition system and natural language processing have given rise to a new generation of powerful voice-based interfaces. In this proposed system, a user interacts with the system through a voice-based user interface to fetch the desired results. To make the system smooth and interactive, the query is based on casual human speech / conversation. The spoken query undergoes many steps to arrive at the final results. It includes synonym table which is used to convert the spoken query into SQL keywords. The proposed work produce good results for simple and complex queries. The accuracy of the system depends on the complexity of the database. This system will show that the voice-based user interface is an effective means of querying and fetching data from the stored database.

Keywords


NLP, Speech, Speech to SQL, SQL, SQL Generator, Synonym Table.

References