I recently hosted an episode of Software Engineering Radio called "Will McGugan on Text-Based User Interfaces"!

  • Home
  • Teaching
    • Overview
    • Data Abstraction
    • Operating Systems
  • Research
    • Overview
    • Papers
    • Presentations
  • Outreach
    • Software
    • Service
    • Blog
  • About
    • Biography
    • Schedule
    • Contact
    • Blog
    • Service
    • Papers
    • Presentations

Contents

  • Introduction
  • Insights
  • Future

Streamlining database application testing with STICCER

post
database testing
empirical study
How can we quickly test database applications?
Author

Gregory M. Kapfhammer

Published

2020

Introduction

Are you tired of the time-consuming processes associated with testing database schemas? Our latest research published in (Alsharif, Kapfhammer, and McMinn 2020) introduces STICCER, a technique designed to enhance the way you approach database test suite reduction.

Insights

Here are some of the key insights from this paper:

  • Automated Efficiency: STICCER intelligently identifies and merges similar test cases, significantly reducing the size of your test suite without compromising coverage.

  • Enhanced Speed: Our experiments with 34 real-world relational database schemas revealed that STICCER can make test suites up to 5 times faster than the original, and 2.5 times faster compared to traditional reduction methods.

  • Maintained Effectiveness: Despite the reduction in the number of tests, STICCER ensures that the effectiveness of the test suite is preserved, with minimal impact on fault detection.

  • Real-World Application: Whether you’re working with SQLite, PostgreSQL, or transitioning between different DBMSs, STICCER adapts to your needs, maintaining the integrity and consistency of your relational database through an approach to efficient schema testing.

Future

By leveraging STICCER, you can streamline your database testing process, ensuring faster and more efficient testing cycles. Please read the full paper to explore the full potential of STICCER and stay ahead in the field of database testing! You can try out STICCER with the schemaanalyst tool and replicate this paper’s empirical results by using the sticcer-replicate package.

Further Details

If you have ideas on how to refine this test suite reduction method for database applications, please contact me! Furthermore, if you wish to stay informed about new developments and blog posts related to STICCER and other similar topics, please consider subscribing to my mailing list.

Return to Blog Post Listing

References

Alsharif, Abdullah, Gregory M. Kapfhammer, and Phil McMinn. 2020. “STICCER: Fast and Effective Database Test Suite Reduction Through Merging of Similar Test Cases.” In Proceedings of the 13th International Conference on Software Testing, Verification and Validation.

GMK

Top