Title :
SQL translator using artificial neural networks
Author :
Prakas, N. ; Garg, K. ; Chopra, Y.C.
Abstract :
The paper presents a novel approach to convert natural language database requests into SQL. The SQL translator acts as a frontend to any information system and provides a natural language interface (NLI) to the end user. The translator is designed to understand everyday English requests and invoke appropriate database reporting tool for a valid query. Each valid query is mapped onto an appropriate SQL command through a neural net based converter/translator. A special class of recurrent neural network paradigm suggested by M.I. Jordan (1988) has been successfully used for this purpose. The query is read one word at a time and clamped at the input of the recurrent network. After recognising the valid sequences of words the output of the network stabilises and indicates the category of the SQL command. The biggest advantage of using a neural net approach is the trainable and adaptive behaviour of the translator. The translator can be trained to recognise queries in other languages and domain by designing a domain dependent training set and incorporating a dictionary of related words. The dictionary of commonly used words and synonyms required for this purpose is an ordinary DOS file that can be shared by multiple users in a network
Keywords :
SQL; language translation; natural language interfaces; natural languages; query languages; recurrent neural nets; word processing; DOS file; NLI; SQL command; SQL translator; adaptive behaviour; artificial neural networks; commonly used words; database reporting tool; domain dependent training set; everyday English requests; frontend; information system; multiple users; natural language database requests; natural language interface; neural net approach; neural net based converter/translator; query recognition; recurrent neural network paradigm; Artificial neural networks; Australia; Data structures; Databases; Dictionaries; Information systems; Natural languages; Neural networks; Pattern matching; Recurrent neural networks;
Conference_Titel :
Intelligent Information Systems, 1996., Australian and New Zealand Conference on
Conference_Location :
Adelaide, SA
Print_ISBN :
0-7803-3667-4
DOI :
10.1109/ANZIIS.1996.573892