Alsharif, A., Kapfhammer, G.M. and McMinn, P.S. orcid.org/0000-0001-9137-7433 (2018) DOMINO: Fast and effective test data generation for relational database schemas. In: 2018 IEEE 11th International Conference on Software Testing, Verification and Validation (ICST). International Conference on Software Testing, Validation And Verification (ICST 2018), 09-13 Apr 2018, Västerås, Sweden. IEEE , pp. 12-22. ISBN 978-1-5386-5012-7
Abstract
An organization's databases are often one of its most valuable assets. Data engineers commonly use a relational database because its schema ensures the validity and consistency of the stored data through the specification and enforcement of integrity constraints. To ensure their correct specification, industry advice recommends the testing of the integrity constraints in a relational schema. Since manual schema testing is labor-intensive and error-prone, this paper presents DOMINO, a new automated technique that generates test data according to a coverage criterion for integrity constraint testing. In contrast to more generalized search-based approaches, which represent the current state of the art for this task, DOMINO uses tailored, domain-specific operators to efficiently generate test data for relational database schemas. In an empirical study incorporating 34 relational database schemas hosted by three different database management systems, the results show that DOMINO can not only generate test suites faster than the state-of-the-art search-based method but that its test suites can also detect more schema faults.
Metadata
Item Type: | Proceedings Paper |
---|---|
Authors/Creators: |
|
Copyright, Publisher and Additional Information: | © 2018 IEEE. Personal use of this material is permitted. Permission from IEEE must be obtained for all other users, including reprinting/ republishing this material for advertising or promotional purposes, creating new collective works for resale or redistribution to servers or lists, or reuse of any copyrighted components of this work in other works. Reproduced in accordance with the publisher's self-archiving policy. |
Keywords: | Relational databases; Testing; Database systems; Standards; Tools; Search problems |
Dates: |
|
Institution: | The University of Sheffield |
Academic Units: | The University of Sheffield > Faculty of Engineering (Sheffield) > Department of Computer Science (Sheffield) |
Depositing User: | Symplectic Sheffield |
Date Deposited: | 02 Mar 2018 14:16 |
Last Modified: | 24 Jul 2018 09:15 |
Published Version: | https://doi.org/10.1109/ICST.2018.00012 |
Status: | Published |
Publisher: | IEEE |
Refereed: | Yes |
Identification Number: | 10.1109/ICST.2018.00012 |
Open Archives Initiative ID (OAI ID): | oai:eprints.whiterose.ac.uk:127821 |