In many business and consumer applications, queries have cardinality constraints. However, current database systems provide minimal support for cardinality assurance. Consequently, users must adopt a cumbersome trial-and-error approach to find queries that are close to the original query but also attain the desired cardinality. In this demonstration, we present QRelX a novel framework to automatically generate alternate queries that meet the cardinality and closeness criteria. QRelX employs an innovative query space transformation strategy, proximity-based search and incremental cardinality estimation to efficiently find alternate queries. Our demonstration is an interactive game that allows the audience to compete with QRelX via manual query refinement. We illustrate the importance of cardinality assurance through real-time comparisons between manual refinement and QRelX. We also highlight the novelty of our solution by visualizing the core algorithms of QRelX.
[1]
Anthony K. H. Tung,et al.
Relaxing join and selection queries
,
2006,
VLDB.
[2]
Surajit Chaudhuri,et al.
Generating Queries with Cardinality Constraints for DBMS Testing
,
2006,
IEEE Transactions on Knowledge and Data Engineering.
[3]
Michael J. Carey,et al.
On saying “Enough already!” in SQL
,
1997,
SIGMOD '97.
[4]
Nick Koudas,et al.
Generating targeted queries for database testing
,
2008,
SIGMOD Conference.
[5]
Ion Muslea,et al.
Machine learning for online query relaxation
,
2004,
KDD.
[6]
Gang Luo.
Efficient detection of empty-result queries
,
2006,
VLDB.
[7]
Nick Koudas,et al.
Interactive query refinement
,
2009,
EDBT '09.