16th International Conference on Data Engineering (ICDE'00) Developing Cost Models with Qualitative Variables for Dynamic Multidatabase Environments San Diego, California February 28-March 03 ISBN: 0-7695-0506-6
A major challenge for global query optimization in a multidatabase system (MDBS) is lack of local cost information at the global level due to local autonomy. A number of methods to derive local cost models have been suggested in the literature recently. However, these methods are only suitable for a static multidatabase environment.In this paper, we propose a new multi-states query sampling method to develop local cost models for a dynamic environment. The system contention level at a dynamic local site is divided into a number of discrete contention states based on the costs of a probing query.To determine an appropriate set of contention states for a dynamic environment, two algorithms based on iterative uniform partition and data clustering, respectively, are introduced. A qualitative variable is used to indicate the contention states for the dynamic environment.The techniques from our previous (static) query sampling method, including query sampling, automatic variable selection, regression analysis, and model validation, are extended so as to develop a cost model incorporating the qualitative variable for a dynamic environment. Experimental results demonstrate that this new multi-states query sampling method is quite promising in developing useful cost models for a dynamic multidatabase environment.
Index Terms:
multidatabase, global query optimization, cost model, regression analysis, data clustering, dynamic environment
Citation:
Qiang Zhu, Yu Sun, S. Motheramgari, "Developing Cost Models with Qualitative Variables for Dynamic Multidatabase Environments," icde, pp.413, 16th International Conference on Data Engineering (ICDE'00), 2000 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||