A Survey on Database Queries by using Dynamic Query Forms

Large and Heterogeneous data is maintained by modern scientific databases and web databases. Over hundreds or sometimes thousands of relations and attributes are contained by these real world databases. Various ad-hoc queries are executed by the user on those databases. But the traditional predefined query forms are not sufficient to solve these ad-hoc query problems. Thus, this paper proposes Dynamic Query Forms (DQF), a new interface for database query forms. This is able to generate the query forms dynamically. The prime functions of DQF includes: 1) capture the preferences of users and rank those query form components.2) Assist users to make their decisions. The invention of a query form is a user guided and an iterative process. At the end of iteration, the ranking list of form components is automatically generated by the system and the query form is added with the desired form components by the user. The rankings of form components are made using the captured user preferences. After the iteration, a user can fill the query form and view the query result after submitting queries. In such a way, a query form will be dynamically improved till the user satisfaction with the results of the queries. The expected F-measure for the query form goodness measuring is utilized in this approach. In DFQ, for estimating the goodness of a query form, a probabilistic model is developed. The effectiveness and the efficiency of DQF are proved after experimental evaluation and user study.