Journal of the ACM (JACM)
View updates in relational databases with an independent scheme
ACM Transactions on Database Systems (TODS)
New Generation Computing
Consistent query answers in inconsistent databases
PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
A framework for testing database applications
Proceedings of the 2000 ACM SIGSOFT international symposium on Software testing and analysis
Using Constraint Satisfaction for View Update
Journal of Intelligent Information Systems
SQL:1999: understanding relational language components
SQL:1999: understanding relational language components
Adapting integrity enforcement techniques for data reconciliation
Information Systems - Data extraction, cleaning and reconciliation
On the decidability and complexity of query answering over inconsistent and incomplete databases
Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
A family of test adequacy criteria for database-driven applications
Proceedings of the 9th European software engineering conference held jointly with 11th ACM SIGSOFT international symposium on Foundations of software engineering
A Logical Framework for Querying and Repairing Inconsistent Databases
IEEE Transactions on Knowledge and Data Engineering
A cost-based model and effective heuristic for repairing constraints by value modification
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
An AGENDA for testing relational database applications: Research Articles
Software Testing, Verification & Reliability
JUnit: Unit Testing and Coding in Tandem
IEEE Software
A Safe Regression Test Selection Technique for Database-Driven Applications
ICSM '05 Proceedings of the 21st IEEE International Conference on Software Maintenance
Logic programs for consistently querying data integration systems
IJCAI'03 Proceedings of the 18th international joint conference on Artificial intelligence
On the computational complexity of minimal-change integrity maintenance in relational databases
Inconsistency Tolerance
Information and Software Technology
Scalable automatic test data generation from modeling diagrams
Proceedings of the twenty-second IEEE/ACM international conference on Automated software engineering
Query-based test generation for database applications
Proceedings of the 1st international workshop on Testing database systems
Building test cases and oracles to automate the testing of web database applications
Information and Software Technology
Scalable satisfiability checking and test data generation from modeling diagrams
Automated Software Engineering
Query-aware shrinking test databases
Proceedings of the Second International Workshop on Testing Database Systems
White-box testing for database-driven applications: a requirements analysis
Proceedings of the Second International Workshop on Testing Database Systems
Query-Aware Test Generation Using a Relational Constraint Solver
ASE '08 Proceedings of the 2008 23rd IEEE/ACM International Conference on Automated Software Engineering
A lightweight framework for testing database applications
Proceedings of the 2010 ACM Symposium on Applied Computing
Constraint-based test database generation for SQL queries
Proceedings of the 5th Workshop on Automation of Software Test
The test data challenge for database-driven applications
Proceedings of the Third International Workshop on Testing Database Systems
MODA: automated test generation for database applications via mock objects
Proceedings of the IEEE/ACM international conference on Automated software engineering
Automated SQL query generation for systematic testing of database engines
Proceedings of the IEEE/ACM international conference on Automated software engineering
A unit test approach for database schema evolution
Information and Software Technology
Qex: symbolic SQL query explorer
LPAR'10 Proceedings of the 16th international conference on Logic for programming, artificial intelligence, and reasoning
Test data provisioning for database-driven applications
BNCOD'10 Proceedings of the 27th British national conference on Data Security and Security Data
Generating program inputs for database application testing
ASE '11 Proceedings of the 2011 26th IEEE/ACM International Conference on Automated Software Engineering
Test input generation for database programs using relational constraints
DBTest '12 Proceedings of the Fifth International Workshop on Testing Database Systems
Proceedings of the 2013 International Symposium on Software Testing and Analysis
Guided test generation for database applications via synthesized database interactions
ACM Transactions on Software Engineering and Methodology (TOSEM)
| Hi-index | 0.00 |
When testing database applications, in addition to creating in-memory fixtures it is also necessary to create an initial database state that is appropriate for each test case. Current approaches either require exact database states to be specified in advance, or else generate a single initial state (under guidance from the user) that is intended to be suitable for execution of all test cases. The first method allows large test suites to be executed in batch, but requires considerable programmer effort to create the test cases (and to maintain them). The second method requires less programmer effort, but increases the likelihood that test cases will fail in non-fault situations, due to unexpected changes to the content of the database. In this paper, we propose a new approach in which the database states required for testing are specified intensionally, as constrained queries, that can be used to prepare the database for testing automatically. This technique overcomes the limitations of the other approaches, and does not appear to impose significant performance overheads.