Cost-Based Database Scaling

Abstract

Scaling database is one of the important aspects of testing the database engines. Traditionally, scaling performed in the most of the databases is with respect to the size of the database. That is, given a scaling factor, the row cardinality of each relation is scaled up by a factor. In this paper, we describe a new method of scaling database called cost based scaling. The cost is the time taken to execute a query workload on scaled database. The goal of cost based scaling is to scale the database so that time taken for executing queries on scaled database is some multiple of time for executing the queries on original database. This cost based scaling can be used as an alternative to the traditional size based scaling for testing the database engines.