An approach to the Optimization of menu-based Natural Language Interfaces to Databases
Fiaz Majeed, Muhammad Shoaib, Fasiha Ashraf · 2011
Natural language interfaces to databases (NLIDB) facilitate the user to state query to database in natural language. NLIDB then interprets the natural language query into Structured Query Language (SQL) to perform action on target database. Menubased NLIDB provides restricted set of elements on screen that are utilized to build natural language query. The latest menubased NLIDB’s use WYSIWYM interfaces that focus on automatic formation of popup menus relevant to typed word on editor. The automatic functionality has made the NLIDB more complex with heavy resource requirement to load and execute multiple processes simultaneously. This paper proposes an optimization approach to efficiently use system memory by menu-based NLIDB. It suggests the order of loading and unloading processes in memory at right time. Finally, proposed approach is evaluated on a real dataset. The application following this approach runs efficiently even on low resources system.