International Journal of Applied Information Systems |
Foundation of Computer Science (FCS), NY, USA |
Volume 4 - Number 6 |
Year of Publication: 2012 |
Authors: Ali El-matarawy |
10.5120/ijais12-450776 |
Ali El-matarawy . Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications. International Journal of Applied Information Systems. 4, 6 ( December 2012), 40-43. DOI=10.5120/ijais12-450776
This research presents an optimization for generic query mode for any database application. It is an enhancement for a previously research "Improving the Query Mode and its Interface for Relational Database Applications". The research improved its intelligence more than expected. In the previous research the algorithm was intelligent in the sense that it answers most of the possible queries or questions that may arise in the user's mind without the need or support of the application developer but there was a restriction for that which is the user can't query about any computed field. This research added this feature to the algorithm regardless the depth of the computed field. The meaning of the depth of the computed field is how many times of the computed field in an equation needs to be transformed so that it contains no computed fields. It has been implemented using PowerBuilder (release 11. 5) as a front end tool and Adaptive Server Anywhere (one of Sybase products) as a database engine. This research describes the design of the optimized intelligent generic query mode and its interface.