Generating Queries with Cardinality Constraints for DBMS Testing
- Nicolas Bruno ,
- Surajit Chaudhuri ,
- Dilys Thomas
Transactions on Knowledge and Data Engineering |
Published by IEEE Computer Society
Good testing coverage of novel database techniques, such as multidimensional histograms or changes in the execution engine, is a complex problem. In this work, we argue that this task requires generating query instances, not randomly, but based on a given set of constraints. Specifically, obtaining query instances that satisfy cardinality constraints on their sub-expressions is an important challenge. We show that this problem is inherently hard, and develop heuristics that effectively find approximate solutions.
Copyright © 2007 IEEE. Reprinted from IEEE Computer Society.This material is posted here with permission of the IEEE. Internal or personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution must be obtained from the IEEE by writing to [email protected] choosing to view this document, you agree to all provisions of the copyright laws protecting it.