Chronos: Feedback control of a real database system performance

Kyoung Don Kang, Jisu Oh, Sang H. Son

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

35 Scopus citations

Abstract

It is challenging to process transactions in a timely fashion using fresh data, e.g., current stock prices, since database workloads may considerably vary due to dynamic data/resource contention. Further, transaction timeliness and data freshness requirements may compete for system resources. In this paper, we propose a novel feedback control model to support the desired data service delay by managing the size of the ready queue, which indicates the amount of the backlog in the database. We also propose a new self-adaptive update policy to adapt the freshness of cold data in a differentiated manner based on temporal data access and update patterns. Unlike most existing work on feedback control of real-time database (RTDB) performance, we actually implement and evaluate feedback control and database workload adaptation techniques in a real database testbed modeling stock trades. For performance evaluation, we undertake experiments in the testbed, which consists of thousands of client threads concurrently requesting database services for stock quotes, trades, and portfolio updates in a bursty manner. In these experiments, our database system supports the desired response time bound and data freshness, while processing a significantly larger number of transactions in time compared to the tested baselines.

Original languageEnglish
Title of host publicationProceedings - 28th IEEE International Real-Time Systems Symposium, RTSS 2007
Pages267-276
Number of pages10
DOIs
StatePublished - 2007
Event28th IEEE International Real-Time Systems Symposium, RTSS 2007 - Tucson, AZ, United States
Duration: 3 Dec 20076 Dec 2007

Publication series

NameProceedings - Real-Time Systems Symposium
ISSN (Print)1052-8725

Conference

Conference28th IEEE International Real-Time Systems Symposium, RTSS 2007
Country/TerritoryUnited States
CityTucson, AZ
Period3/12/076/12/07

Fingerprint

Dive into the research topics of 'Chronos: Feedback control of a real database system performance'. Together they form a unique fingerprint.

Cite this