NLKBIDB - Natural language and keyword based interface to database

One of the major source of information is database which plays an important role in computer field. Almost all IT applications are storing and retrieving information from databases. There are various interfaces available to retrieve data such as form based, natural language and keyword based. Data retrieval from the database requires knowledge of database language like SQL [1]. The need of natural language arises from the fact that common people (other than SQL experts) are not used to writing SQL query. Therefore researchers have identified a new system called Natural Language Interface to Database (NLIDB) and Keyword Based Interface to Database (KBIDB). In this paper we have proposed architecture of a Natural Language and Keyword Based Interface for Database (NLKBIDB) which provides solution for syntactically correct and incorrect natural language input query. Our partial experiment of Lexical Analyzer and Keyword based interface on agriculture survey database solves 53% of syntactically incorrect query which will not be solved by natural language interface resulting in increase of rate of SQL query conversion.