The Community for Technology Leaders
Green Image
ISSN: 1041-4347
Liang Tang , Florida International University, Miami
Tao Li , Florida International University, Miami
Yexi Jiang , Florida International University, Miami
Zhiyuan Chen , University of Maryland Baltimore County, Baltimore
Modern scientific and web databases maintain large and heterogeneous data. These real-world database schemas contain over hundreds or even thousands of attributes and relations. Traditional predefined query forms are not able to satisfy various ad-hoc queries from users. This paper proposes 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 rank query form components. The generation of the query form is an iterative process and is guided by the user. At each iteration, the system automatically generates ranking lists of form components and the user then adds the desired form components into the query form. The ranking of form components is based on the captured user preference. The user can also fill the query form and submit queries to view the query result at each iteration. In this way, the query form could be dynamically refined until the user satisfies with the query results. We propose a metric for measuring the goodness of a query form. A probabilistic model is developed for estimating the goodness of a query form in DQF. Our experimental evaluation and user study demonstrate the effectiveness and efficiency of the system.
Dynamic Query Form, Information Technology and Systems, Database Management, Database Applications, Miscellaneous

L. Tang, T. Li, Y. Jiang and Z. Chen, "Dynamic Query Forms for Database Queries," in IEEE Transactions on Knowledge & Data Engineering.
87 ms
(Ver 3.3 (11022016))