Database virtualization: A new frontier for database tuning and physical design

Ahmed A. Soror, Ashraf Aboulnaga, Kenneth Salem

Research output: Chapter in Book/Report/Conference proceedingConference contribution

17 Citations (Scopus)

Abstract

Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increasingly be run in virtualized environments, inside virtual machines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we discuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new "tuning knobs" that control resource allocation to virtual machines in the virtualized environment. We present a formulation of the virtualization design problem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solution to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware "what-if" mode. We also discuss the next steps in solving this problem, and present some long-term research directions.

Original languageEnglish
Title of host publicationProceedings - International Conference on Data Engineering
Pages387-394
Number of pages8
DOIs
Publication statusPublished - 1 Dec 2007
Externally publishedYes
EventWorkshops in Conjunction with the 23rd International Conference on Data Engineering - ICDE 2007 - Istanbul, Turkey
Duration: 15 Apr 200720 Apr 2007

Other

OtherWorkshops in Conjunction with the 23rd International Conference on Data Engineering - ICDE 2007
CountryTurkey
CityIstanbul
Period15/4/0720/4/07

Fingerprint

Tuning
Resource allocation
Knobs
Costs
Virtualization
Virtual machine

ASJC Scopus subject areas

  • Software
  • Engineering(all)
  • Engineering (miscellaneous)

Cite this

Soror, A. A., Aboulnaga, A., & Salem, K. (2007). Database virtualization: A new frontier for database tuning and physical design. In Proceedings - International Conference on Data Engineering (pp. 387-394). [4401021] https://doi.org/10.1109/ICDEW.2007.4401021

Database virtualization : A new frontier for database tuning and physical design. / Soror, Ahmed A.; Aboulnaga, Ashraf; Salem, Kenneth.

Proceedings - International Conference on Data Engineering. 2007. p. 387-394 4401021.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Soror, AA, Aboulnaga, A & Salem, K 2007, Database virtualization: A new frontier for database tuning and physical design. in Proceedings - International Conference on Data Engineering., 4401021, pp. 387-394, Workshops in Conjunction with the 23rd International Conference on Data Engineering - ICDE 2007, Istanbul, Turkey, 15/4/07. https://doi.org/10.1109/ICDEW.2007.4401021
Soror AA, Aboulnaga A, Salem K. Database virtualization: A new frontier for database tuning and physical design. In Proceedings - International Conference on Data Engineering. 2007. p. 387-394. 4401021 https://doi.org/10.1109/ICDEW.2007.4401021
Soror, Ahmed A. ; Aboulnaga, Ashraf ; Salem, Kenneth. / Database virtualization : A new frontier for database tuning and physical design. Proceedings - International Conference on Data Engineering. 2007. pp. 387-394
@inproceedings{5843bc3fb99b46cb96cf466d9e7e3fde,
title = "Database virtualization: A new frontier for database tuning and physical design",
abstract = "Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increasingly be run in virtualized environments, inside virtual machines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we discuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new {"}tuning knobs{"} that control resource allocation to virtual machines in the virtualized environment. We present a formulation of the virtualization design problem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solution to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware {"}what-if{"} mode. We also discuss the next steps in solving this problem, and present some long-term research directions.",
author = "Soror, {Ahmed A.} and Ashraf Aboulnaga and Kenneth Salem",
year = "2007",
month = "12",
day = "1",
doi = "10.1109/ICDEW.2007.4401021",
language = "English",
isbn = "1424408326",
pages = "387--394",
booktitle = "Proceedings - International Conference on Data Engineering",

}

TY - GEN

T1 - Database virtualization

T2 - A new frontier for database tuning and physical design

AU - Soror, Ahmed A.

AU - Aboulnaga, Ashraf

AU - Salem, Kenneth

PY - 2007/12/1

Y1 - 2007/12/1

N2 - Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increasingly be run in virtualized environments, inside virtual machines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we discuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new "tuning knobs" that control resource allocation to virtual machines in the virtualized environment. We present a formulation of the virtualization design problem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solution to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware "what-if" mode. We also discuss the next steps in solving this problem, and present some long-term research directions.

AB - Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increasingly be run in virtualized environments, inside virtual machines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we discuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new "tuning knobs" that control resource allocation to virtual machines in the virtualized environment. We present a formulation of the virtualization design problem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solution to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware "what-if" mode. We also discuss the next steps in solving this problem, and present some long-term research directions.

UR - http://www.scopus.com/inward/record.url?scp=48349090699&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=48349090699&partnerID=8YFLogxK

U2 - 10.1109/ICDEW.2007.4401021

DO - 10.1109/ICDEW.2007.4401021

M3 - Conference contribution

AN - SCOPUS:48349090699

SN - 1424408326

SN - 9781424408320

SP - 387

EP - 394

BT - Proceedings - International Conference on Data Engineering

ER -