Article

Free access

A framework for testing database applications

Authors:

Phyllis G. Frankl,

Filippos I. Vokolos,

Elaine J. WeyukerAuthors Info & Claims

ISSTA '00: Proceedings of the 2000 ACM SIGSOFT international symposium on Software testing and analysis

Pages 147 - 157

https://doi.org/10.1145/347324.348954

Published: 01 August 2000 Publication History

Abstract

Database systems play an important role in nearly every modern organization, yet relatively little research effort has focused on how to test them. This paper discusses issues arising in testing database systems and presents an approach to testing database applications. In testing such applications, the state of the database before and after the user's operation plays an important role, along with the user's input and the system output. A tool for populating the database with meaningful data that satisfy database constraints has been prototyped. Its design and its role in a larger database application testing tool set are discussed.

References

[1]

G. Bernot, M. Gaudel, and B. Marre. Software testing based on formal speci~cations: a theory and a tool. Software Engineering Journal, 6(6):387{405, Nov. 1991.

Digital Library

[2]

M. J. Carey, D. J. DeWitt, and J. F. Naughton. The 007 benchmark. In Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 26-28, 1993, pages 12{21. ACM Press, 1993.

Digital Library

[3]

J. Chang, S. Sankar, and D. J. Richardson. Automated test selection from adl speci~cations. In Proceedings of the 1996 International Symposium on Software Testing and Analysis. ACM Press, Jan. 1996.

[4]

H. Y. Chen, T. Tse, F. Chan, and T. Chen. In black and white: An integrated approach to class level testing of object-oriented programs. ACM Transactions on Software Engineering Methodology, 7(3):250{295, July 1998.

Digital Library

[5]

S. Dalal, A. Jain, N. Karunanithi, J. Leaton, C. Lott, and G. Patton. Model-based testing in practice. In International Conference on Software Engineering. ACM Press, May 1999.

Digital Library

[6]

C. Date and H. Darwen. A Guide to the SQL Standard. Addison-Wesley, New York, 1997.

Digital Library

[7]

R. A. Davies, R. J. A. Beynon, and B. F. Jones. Automating the testing of databases. In Proceedings of the First International Workshop on Automated Program Analysis, Testing and Veri~cation, June 2000.

[8]

R. A. DeMillo and A. J. O~utt. Experimental results from an automatic test case generator. ACM Transactions on Software Engineering Methodology, 2(2):109{127, April 1993.

Digital Library

[9]

R. Doong and P. G. Frankl. The ASTOOT approach to testing object-oriented programs. ACM Transactions on Software Engineering Methodology, 3(2):101{130, 1994.

Digital Library

[10]

R. Elmasri and S. B. Navanthe. Fundamentals of Database Systems, Third Edition. Addison-Wesley, New York, 2000.

Digital Library

[11]

A. Gotlieb, B. Botella, and M. Rueher. Automatic test data generation using constraint solving techniques. In Proceedings of the 1998 International Symposium on Software Testing and Analysis, pages 53{62. ACM Press, Mar. 1998.

Digital Library

[12]

J. Gray, P. Sundaresan, S. Englert, K. Baclawski, and P. J. Weinberger. Quickly generating billion-record synthetic databases. SIGMOD Record (ACM Special Interest Group on Management of Data), 23(2):243{252, June 1994.

Digital Library

[13]

N. Gupta, A. Mathur, and M. L. So~a. Automated test data generation using an iterative relaxation method. In Proceedings Foundations of Software Engineering. ACM Press, Nov. 1998.

Digital Library

[14]

B. Korel. Automated software test generation. IEEE Transactions on Software Engineering, 16(8):870{879, Aug. 1990.

Digital Library

[15]

N. R. Lyons. An automatic data generating system for data base simulation and testing. Database, 8(4):10 {13, 1977.

Digital Library

[16]

T. J. Ostrand and M. J. Balcer. The category-partition method for specifying and generating functional tests. Commun. ACM, 31(6):676{686, June 1988.

Digital Library

[17]

D. Slutz. Massive stochastic testing of SQL. In VLDB, pages 618{622. Morgan Kaufmann, Aug. 1998.

Digital Library

[18]

M. Stonebraker and L. Rowe. The design of postgres. In Proc. ACM-SIGMOD International Conference on the Management of Data. ACM Press, June 1986.

Digital Library

[19]

Transaction Processing Performance Council. TPC-Benchmark C. 1998.

[20]

E. J. Weyuker, T. Goradia, and A. Singh. Automatically generating test data from a boolean speci~cation. IEEE Transactions on Software Engineering, 20(5):353{363, May 1994.

Digital Library

Cited By

Staegemann DPohl MHaertel CDaase CAbdallah MTurowski K(2023)An Overview of the Approaches for Generating Test Data in the Context of the Quality Assurance of Big Data Applications2023 17th International Conference on Signal-Image Technology & Internet-Based Systems (SITIS)10.1109/SITIS61268.2023.00015(30-37)Online publication date: 8-Nov-2023
https://doi.org/10.1109/SITIS61268.2023.00015
Gobert MNagy CRocha HDemeyer SCleve A(2023)Best practices of testing database manipulation codeInformation Systems10.1016/j.is.2022.102105111:COnline publication date: 1-Jan-2023
https://dl.acm.org/doi/10.1016/j.is.2022.102105
Gobert MNagy CRocha HDemeyer SCleve A(2021)Challenges and Perils of Testing Database Manipulation CodeAdvanced Information Systems Engineering10.1007/978-3-030-79382-1_14(229-245)Online publication date: 24-Jun-2021
https://doi.org/10.1007/978-3-030-79382-1_14
Show More Cited By

Index Terms

A framework for testing database applications
1. Information systems
  1. Data management systems
    1. Database administration
  2. Information systems applications
2. Software and its engineering
  1. Software creation and management
    1. Software verification and validation
      1. Software defect analysis
        Software testing and debugging
  2. Software notations and tools
    1. General programming languages
      1. Language features
        Frameworks

Recommendations

Using an SQL coverage measurement for testing database applications

Many software applications have a component based on database management systems in which information is generally handled through SQL queries embedded in the application code. When automation of software testing is mentioned in the research, this is ...
An AGENDA for testing relational database applications: Research Articles

Database systems play an important role in nearly every modern organization, yet relatively little research effort has focused on how to test them. This paper discusses issues arising in testing database systems, presents an approach to testing database ...
A framework for testing database applications

Database systems play an important role in nearly every modern organization, yet relatively little research effort has focused on how to test them. This paper discusses issues arising in testing database systems and presents an approach to testing ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

ISSTA '00: Proceedings of the 2000 ACM SIGSOFT international symposium on Software testing and analysis

August 2000

211 pages

ISBN:1581132662

DOI:10.1145/347324

Chairman:
Debra J. Richardson
Univ. of California, Irvine, CA
,
Editor:
Mary Jean Harold
Georgia Inst. of Technology, Atlanta, GA

ACM SIGSOFT Software Engineering Notes Volume 25, Issue 5
Sept. 2000
211 pages
ISSN:0163-5948
DOI:10.1145/347636
Editor:
Mary Jean Harrold
Georgia Institute of Technology
Issue’s Table of Contents

Copyright © 2000 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGSOFT: ACM Special Interest Group on Software Engineering

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 August 2000

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

ISSTA00

Sponsor:

SIGSOFT

ISSTA00: International Symposium on Software Testing and Analysis

August 21 - 24, 2000

Oregon, Portland, USA

Acceptance Rates

Overall Acceptance Rate 58 of 213 submissions, 27%

Upcoming Conference

ISSTA '25

Sponsor:
sigsoft

34th ACM SIGSOFT International Symposium on Software Testing and Analysis

June 25 - 28, 2025

Trondheim , Norway

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

83
Total Citations
View Citations
2,436
Total Downloads

Downloads (Last 12 months)135
Downloads (Last 6 weeks)19

Reflects downloads up to 17 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Staegemann DPohl MHaertel CDaase CAbdallah MTurowski K(2023)An Overview of the Approaches for Generating Test Data in the Context of the Quality Assurance of Big Data Applications2023 17th International Conference on Signal-Image Technology & Internet-Based Systems (SITIS)10.1109/SITIS61268.2023.00015(30-37)Online publication date: 8-Nov-2023
https://doi.org/10.1109/SITIS61268.2023.00015
Gobert MNagy CRocha HDemeyer SCleve A(2023)Best practices of testing database manipulation codeInformation Systems10.1016/j.is.2022.102105111:COnline publication date: 1-Jan-2023
https://dl.acm.org/doi/10.1016/j.is.2022.102105
Gobert MNagy CRocha HDemeyer SCleve A(2021)Challenges and Perils of Testing Database Manipulation CodeAdvanced Information Systems Engineering10.1007/978-3-030-79382-1_14(229-245)Online publication date: 24-Jun-2021
https://doi.org/10.1007/978-3-030-79382-1_14
Wang YDong JShah RDillig IMcKinley KFisher K(2019)Synthesizing database programs for schema refactoringProceedings of the 40th ACM SIGPLAN Conference on Programming Language Design and Implementation10.1145/3314221.3314588(286-300)Online publication date: 8-Jun-2019
https://dl.acm.org/doi/10.1145/3314221.3314588
Wang YDillig ILahiri SCook W(2017)Verifying equivalence of database-driven applicationsProceedings of the ACM on Programming Languages10.1145/31581442:POPL(1-29)Online publication date: 27-Dec-2017
https://dl.acm.org/doi/10.1145/3158144
Chandrasekaran JFeng HLei YKuhn DKacker R(2017)Applying Combinatorial Testing to Data Mining Algorithms2017 IEEE International Conference on Software Testing, Verification and Validation Workshops (ICSTW)10.1109/ICSTW.2017.46(253-261)Online publication date: Mar-2017
https://doi.org/10.1109/ICSTW.2017.46
Theodorou VJovanovic PAbelló ANakuçi E(2017)Data generator for evaluating ETL process qualityInformation Systems10.1016/j.is.2016.04.00563(80-100)Online publication date: Jan-2017
https://doi.org/10.1016/j.is.2016.04.005
Li NLei YKhan HLiu JGuo YLo DApel SKhurshid S(2016)Applying combinatorial test data generation to big data applicationsProceedings of the 31st IEEE/ACM International Conference on Automated Software Engineering10.1145/2970276.2970325(637-647)Online publication date: 25-Aug-2016
https://dl.acm.org/doi/10.1145/2970276.2970325
Tuya JRiva CSuarez-Cabal MBlanco R(2016)Coverage-Aware Test Database ReductionIEEE Transactions on Software Engineering10.1109/TSE.2016.251903242:10(941-959)Online publication date: 1-Oct-2016
https://dl.acm.org/doi/10.1109/TSE.2016.2519032
Tsumura KWashizaki HFukazawa YOshima KMibe R(2016)Pairwise Coverage-Based Testing with Selected Elements in a Query for Database Applications2016 IEEE Ninth International Conference on Software Testing, Verification and Validation Workshops (ICSTW)10.1109/ICSTW.2016.19(92-101)Online publication date: Apr-2016
https://doi.org/10.1109/ICSTW.2016.19
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents