Kenneth Salem
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Kenneth Salem has a total of 9 co-authors. Here are the top co-authors by number of shared publications:
- Ashraf Aboulnaga
University of Waterloo
3 shared publications - Ahmed A. Soror
David R. Cheriton School of Computer Science, University of Waterloo
1 shared publication - Andrew Warfield
University of British Columbia
1 shared publication - Anil K Goel
Sybase iAnywhere, Waterloo, Ontario, Canada
1 shared publication - Brendan Cully
University of British Columbia
1 shared publication Rui Liu
University of Waterloo
1 shared publication
Latest Publications
- Open Access
- 1 February 2013
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 6 (4) , 253-264
DAX
- 1 February 2013
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 6 (4) , 253-264
Open AccessDAX
- 18 October 2012
- Published by Springer Nature in The VLDB Journal
- Vol. 22 (1) , 29-45
RemusDB: transparent high availability for database systems
- 18 October 2012
- Published by Springer Nature in The VLDB Journal
- Vol. 22 (1) , 29-45
RemusDB: transparent high availability for database systems
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 469-477
Towards Adaptive Costing of Database Access Methods
Most database query optimizers use cost models to identify good query execution plans. Inaccuracies in the cost models can cause query optimizers to select poor plans. In this paper, we consider the problem of accurately estimating the I/O costs of database access methods, such as index scans. We present some experimental results which show that existing analytical I/O cost models can be very inaccurate. We also present a simple analysis which shows that larger cost estimation errors can cause the query optimizer to make larger mistakes in plan selection. We propose the use of an adaptive black-box statistical cost estimation methodology to achieve better estimates.
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 469-477
Towards Adaptive Costing of Database Access Methods
Most database query optimizers use cost models to identify good query execution plans. Inaccuracies in the cost models can cause query optimizers to select poor plans. In this paper, we consider the problem of accurately estimating the I/O costs of database access methods, such as index scans. We present some experimental results which show that existing analytical I/O cost models can be very inaccurate. We also present a simple analysis which shows that larger cost estimation errors can cause the query optimizer to make larger mistakes in plan selection. We propose the use of an adaptive black-box statistical cost estimation methodology to achieve better estimates.
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 388-394
Database Virtualization: A New Frontier for Database Tuning and Physical Design
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 visualization 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.
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 388-394
Database Virtualization: A New Frontier for Database Tuning and Physical Design
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 visualization 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.