Multiple uses of Query Optimization Technique
Tarun Dhar Diwan, Bhoopendra Dhar Diwan, Somen Roy · CiiT international journal of artificial intelligent systems and machine learning · 2013
Query optimization is the process of selecting the most efficient query-evaluation plan from many strategies usually possible for processing a given query if the query is complex. Where the system attempts to-find an expression that is equivalent to given application, but more efficient to execute.. Human queries are rarely crisp which poses challenges in efficient answer formation and data retrieval. Now various work is shifting toward hybrid methods that combine new empirical corpus-based methods, including the use of probabilistic and information theoretic techniques, with traditional symbolic methods. Need of Natural Language Query Processing is for an English sentence to be interpreted by the computer and appropriate action taken. Question answering to any databases in natural language is a very convenient and easy method of data access, especially for casual users who do not understand complicated database query languages such as SQL so this paper proposes the architecture for translating English Query into SQL using Semantic Grammar.