A Novel IR for Relational Database using Optimize Query Building

Abstract

The different type search engine like Google, binge, AltaVista is used to fetch the information from the database by easy language. The non-technical employee they don’t understand the database and query cannot access the database. The proposed system is performing work as a search engine where users can fetch the information from the database by natural human sounding language. The previous existing system doesn’t able to solve queries in one easy statement. The structured query approach, while expressive and powerful, is not easy for naive users. The keyword-based approach is very friendly to use, but cannot express complex query intent accurately. This paper emphasis on Natural Language based query processor. We have proposed the use of query optimization approach to convert complex NLP query to SQL query, SPAM word removal, POS tagger applied over NL query and concluded that execution time lesser when query size increases.