Prioritizing Test Cases For Regression Testing
IEEE Transactions on Software Engineering
Visualization of test information to assist fault localization
Proceedings of the 24th International Conference on Software Engineering
Automatic Generation of Database Instances for White-box Testing
COMPSAC '01 Proceedings of the 25th International Computer Software and Applications Conference on Invigorating Software Development
Using an SQL coverage measurement for testing database applications
Proceedings of the 12th ACM SIGSOFT twelfth international symposium on Foundations of software engineering
Locating causes of program failures
Proceedings of the 27th international conference on Software engineering
An AGENDA for testing relational database applications: Research Articles
Software Testing, Verification & Reliability
A Safe Regression Test Selection Technique for Database-Driven Applications
ICSM '05 Proceedings of the 21st IEEE International Conference on Software Maintenance
Empirical evaluation of the tarantula automatic fault-localization technique
Proceedings of the 20th IEEE/ACM international Conference on Automated software engineering
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
A framework for efficient regression tests on database applications
The VLDB Journal — The International Journal on Very Large Data Bases
Impact analysis of database schema changes
Proceedings of the 30th international conference on Software engineering
On the provenance of non-answers to queries over extracted data
Proceedings of the VLDB Endowment
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
How to ConQueR why-not questions
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Constraint-based test database generation for SQL queries
Proceedings of the 5th Workshop on Automation of Software Test
Qex: symbolic SQL query explorer
LPAR'10 Proceedings of the 16th international conference on Logic for programming, artificial intelligence, and reasoning
Generating test data for killing SQL mutants: A constraint-based approach
ICDE '11 Proceedings of the 2011 IEEE 27th International Conference on Data Engineering
Hi-index | 0.00 |
Diagnosing faults in embedded queries in database applications is a daunting process. When test cases fail, the traditional way of diagnosing faults is to follow possible execution paths, either mentally or step-by-step in a debugger, to locate the problematic area. The diagnosis problem becomes even harder when you have embedded language with quite different semantics and properties. Our focus is on a specific problem: diagnosing failed test cases caused by embedded queries in database applications which are syntactically correct but semantically incorrect (i.e., they produce incomplete or incorrect results). Much research literature is available on database applications and databases but the diagnosis problem for embedded queries that cause failure of test cases has not been tackled. We perform an experiment to see how far existing techniques could be useful in proposing a new technique for this problem. We identify the additional components that need to be developed to take us to a full solution and describe our tentative conclusions so far.