Evaluating the Performance of Dynamic Database Applications

Zhen He (1) , Jérôme Darmont (2)

1 La Trobe University Bundoora
2 ERIC - Equipe de Recherche en Ingénierie des Connaissances

This chapter explores the effect that changing access patterns has on the performance of database management systems. Changes in access patterns play an important role in determining the efficiency of key performance optimization techniques, such as dynamic clustering, prefetching, and buffer replacement. However, all existing benchmarks or evaluation frameworks produce static access patterns in which objects are always accessed in the same order repeatedly. Hence, we have proposed the Dynamic Evaluation Framework (DEF) that simulates access pattern changes using configurable styles of change. DEF has been designed to be open and fully extensible (e.g., new access pattern change models can also be added easily). In this chapter, we instantiate DEF into the Dynamic object Evaluation Framework (DoEF) which is designed for object databases, i.e., object-oriented or object-relational databases such as multimedia databases or most XML databases.

Domaines: Base de données [cs.DB]

Zhen He, Jérôme Darmont. Evaluating the Performance of Dynamic Database Applications. Advanced Topics in Database Research, 5, Idea Group Publishing, pp.294-319, 2006, ⟨10.4018/978-1-59140-935-9.ch016⟩. ⟨hal-01446911⟩