Hindi Language Interface to Databases

Abstract

Database management systems have been widely used for storing and retrieving data. However, databases are often hard to use since their interface is quite rigid in cooperating with users. The analysis of existing Natural Language Interface to Databases has been carried out. Most of the systems are based on pattern-matching, syntax based, semantic based, intermediate representation languages architectures. The Employee database has been identified as a case study for developing Hindi language interface to databases. This Employee database contains Employee and Department tables. A system has been developed in which user can input query in Hindi language and can see the result in the same language. The proposed system can handle single and multiple column retrieval queries, conditional queries and join queries. A graphical user interface has been designed for this system with the use of JAVA Swings. MYSQL has been used as database and it is connected to JAVA using mysqlconnector- java. The proposed system can work on UNIX platform. It has been tested thoroughly on 50 Hindi queries which includes select query, update and delete queries. The results of testing are very encouraging.