Generating Shifting Workloads to Benchmark Adaptability in Relational Database Systems

  • Tilmann Rabl
  • Andreas Lang
  • Thomas Hackl
  • Bernhard Sick
  • Harald Kosch
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5895)

Abstract

A large body of research concerns the adaptability of database systems. Many commercial systems already contain autonomic processes that adapt configurations as well as data structures and data organization. Yet there is virtually no possibility for a just measurement of the quality of such optimizations. While standard benchmarks have been developed that simulate real-world database applications very precisely, none of them considers variations in workloads produced by human factors. Today’s benchmarks test the performance of database systems by measuring peak performance on homogeneous request streams. Nevertheless, in systems with user interaction access patterns are constantly shifting. We present a benchmark that simulates a web information system with interaction of large user groups. It is based on the analysis of a real online eLearning management system with 15,000 users. The benchmark considers the temporal dependency of user interaction. Main focus is to measure the adaptability of a database management system according to shifting workloads. We will give details on our design approach that uses sophisticated pattern analysis and data mining techniques.

Keywords

Benchmarking Adaptability Polynomial Approximation Time Series Generation 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Tilmann Rabl
    • 1
  • Andreas Lang
    • 1
  • Thomas Hackl
    • 2
  • Bernhard Sick
    • 3
  • Harald Kosch
    • 1
  1. 1.Chair of Distributed Information Systems 
  2. 2.InteLeC-Zentrum 
  3. 3.Computationally Intelligent Systems GroupUniversity of PassauGermany

Personalised recommendations