Abstract | ||
---|---|---|
We discuss the problem of resource provisioning for database management systems operating on top of an Infrastructure-As-A-Service (IaaS) cloud. To solve this problem, we describe an extensible framework that, given a target query workload, continually optimizes the system's operational cost, estimated based on the IaaS provider's pricing model, while satisfying QoS expectations. Specifically, we describe two different approaches, a ¿white-box¿ approach that uses a fine-grained estimation of the expected resource consumption for a workload, and a ¿black-box¿ approach that relies on coarse-grained profiling to characterize the workload's end-to-end performance across various cloud resources. We formalize both approaches as a constraint programming problem and use a generic constraint solver to efficiently tackle them. We present preliminary experimental numbers, obtained by running TPC-H queries with PostsgreSQL on Amazon's EC2, that provide evidence of the feasibility and utility of our approaches. We also briefly discuss the pertinent challenges and directions of on-going research. |
Year | DOI | Venue |
---|---|---|
2010 | 10.1109/ICDEW.2010.5452746 | Data Engineering Workshops |
Keywords | Field | DocType |
Internet,constraint handling,database management systems,IaaS cloud,PostsgreSQL,TPC-H queries,black box approach,cloud databases,coarse grained profiling,constraint programming problem,database management systems,end-to-end performance,fine grained estimation,generic auto provisioning framework,generic constraint solver,infrastructure as a service,white box approach | Data mining,Profiling (computer programming),Workload,Computer science,Constraint programming,Server,Quality of service,Constraint satisfaction problem,Provisioning,Database,Distributed computing,Cloud computing | Conference |
ISSN | ISBN | Citations |
1943-2895 | 978-1-4244-6521-7 | 19 |
PageRank | References | Authors |
1.04 | 13 | 3 |
Name | Order | Citations | PageRank |
---|---|---|---|
Jennie Rogers | 1 | 57 | 6.32 |
Olga Papaemmanouil | 2 | 431 | 27.21 |
Ugur Çetintemel | 3 | 3099 | 208.64 |