Understanding and validating database system administration

Fábio Oliveira, Kiran Nagaraja, Rekha Bachwani, Ricardo Bianchini, Richard P. Martin, Thu D. Nguyen

Research output: Contribution to conferencePaperpeer-review

27 Scopus citations

Abstract

A large number of enterprises need their commodity database systems to remain available at all times. Although administrator mistakes are a significant source of unavailability and cost in these systems, no study to date has sought to quantify the frequency of mistakes in the field, understand the context in which they occur, or develop system support to deal with them explicitly. In this paper, we first characterize the typical administrator tasks, testing environments, and mistakes using results from an extensive survey we have conducted of 51 experienced administrators. Given the results of this survey, we next propose system support to validate administrator actions before they are made visible to users. Our prototype implementation creates a validation environment that is an extension of a replicated database system, where administrator actions can be validated using real workloads. The prototype implements three forms of validation, including a novel form in which the behavior of a database replica can be validated even without an example of correct behavior for comparison. Our results show that the prototype can detect the major classes of administrator mistakes.

Original languageEnglish (US)
Pages213-228
Number of pages16
StatePublished - Jan 1 2006
Event2006 USENIX Annual Technical Conference - Boston, United States
Duration: May 30 2006Jun 3 2006

Conference

Conference2006 USENIX Annual Technical Conference
CountryUnited States
CityBoston
Period5/30/066/3/06

All Science Journal Classification (ASJC) codes

  • Computer Science(all)

Fingerprint Dive into the research topics of 'Understanding and validating database system administration'. Together they form a unique fingerprint.

Cite this