Artemis: An Automatic Test Suite Generator for Large Scale OLAP Database

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

1 Scopus citations

Abstract

We design an automatic test suite generation tool Artemis for functionality test of Online Analytical Processing Databases (OLAP DBs). This is the first work which accomplishes the work of DB test by integrating three artifacts, i.e., data generation, workload generation and oracle generation, but promises the scalability, effectiveness and efficiency. The key idea of our approach is to design a deterministic random data generation mechanism, based on which we can instantiate the parameterized queries and calculate the oracles simultaneously by resolving the constraint chains along query trees. Since we provide deterministic random functions for data generations corresponding to a predefined schema, repetitive test and data migration become a trivial job. Random workload generation and automatic oracle calculation instead of differential comparison make abundant and massive scale of test possible. We finally provide extensive experiments to show the performance of Artemis.

Original languageEnglish
Title of host publicationBenchmarking, Measuring, and Optimizing - Third BenchCouncil International Symposium, Bench 2020, Revised Selected Papers
EditorsFelix Wolf, Wanling Gao
PublisherSpringer Science and Business Media Deutschland GmbH
Pages74-89
Number of pages16
ISBN (Print)9783030710576
DOIs
StatePublished - 2021
Event3rd BenchCouncil International Symposium on Benchmarking, Measuring, and Optimizing, Bench 2020 - Virtual, Online
Duration: 15 Nov 202016 Nov 2020

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume12614 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference3rd BenchCouncil International Symposium on Benchmarking, Measuring, and Optimizing, Bench 2020
CityVirtual, Online
Period15/11/2016/11/20

Keywords

  • Data generation
  • Query generation
  • Result verification

Fingerprint

Dive into the research topics of 'Artemis: An Automatic Test Suite Generator for Large Scale OLAP Database'. Together they form a unique fingerprint.

Cite this