This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Dynamic Query Forms for Database Queries
PrePrint
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.
Index Terms:
Dynamic Query Form,Information Technology and Systems,Database Management,Database Applications,Miscellaneous
Citation:
Liang Tang, Tao Li, Yexi Jiang, Zhiyuan Chen, "Dynamic Query Forms for Database Queries," IEEE Transactions on Knowledge and Data Engineering, 19 April 2013. IEEE computer Society Digital Library. IEEE Computer Society, <http://doi.ieeecomputersociety.org/10.1109/TKDE.2013.62>
Usage of this product signifies your acceptance of the Terms of Use.