16-02-2017, 09:43 AM
Modern scientific databases and web databases maintain large and heterogeneous data. These real-world databases contain hundreds or even thousands of relationships and attributes. Traditional predefined query forms can not satisfy multiple ad-hoc queries from the users of those databases. In this article we propose DQF, a novel database query form interface, which is able to dynamically generate query forms. The essence of DQF is to capture the user's preference and classify the components of the query form, helping them make decisions. The generation of a query form is an iterative process and is guided by the user.
At each iteration, the system automatically generates form classification lists from the form and the user adds the desired form components to the query form. The classification of the components of the form is based on the preference of the captured user. A user can also fill out the query form and send queries to see the result of the query at each iteration. In this way, a query form could be refined dynamically until the user is satisfied with the results of the query. We use the expected F-measure to measure the goodness of a query form. A probabilistic model is developed to estimate the goodness of a query form in DQF. Our experimental evaluation and the user's study demonstrate the effectiveness and efficiency of the system.
At each iteration, the system automatically generates form classification lists from the form and the user adds the desired form components to the query form. The classification of the components of the form is based on the preference of the captured user. A user can also fill out the query form and send queries to see the result of the query at each iteration. In this way, a query form could be refined dynamically until the user is satisfied with the results of the query. We use the expected F-measure to measure the goodness of a query form. A probabilistic model is developed to estimate the goodness of a query form in DQF. Our experimental evaluation and the user's study demonstrate the effectiveness and efficiency of the system.