We give formulas for estimating the number of disk accesses when accessing a file randomly with buffering. We present the layered hot set model which quantifies the locality of page references when executing a query using a DBMS. We presented the ABLE buffer management algorithms for DBMS's. We give cost models for both relational DBMS's and network DBMS's. We also give some of the results of our experiments for testing the performance of the ABLE buffer management algorithm and the accuracy of the cost model.U of I OnlyETDs are only available to UIUC Users without author permissio
During the last two decades, computer hardware has experienced remarkable developments. Especially C...
Accurate prediction of operator execution time is a prerequisite fordatabase query optimization. Alt...
Parallel servers offer improved processing power for relational database systems and provide system ...
We give formulas for estimating the number of disk accesses when accessing a file randomly with buff...
The hot-set model, characterizing the buffer requirements of relational queries, is presented. This ...
[[abstract]]It is well known that the behavior of page reference in a database environment is differ...
AbstractÐPast R-tree studies have focused on the number of nodes visited as a metric of query perfor...
This paper introduces a new approach to database disk buffering, called the LRU-K method. The basic ...
Abstract: Buffer memory allocation is one of the most important, but also one of the most difficult ...
Abstract. This paper introduces a new approach to database disk buffering, called the LFU-K method. ...
Accurate prediction of operator execution time is a prerequisite for database query optimization. Al...
Due to the recent improvements in the price/performance characteristics of workstations and the netw...
This paper presents a systematic survey of the existing database system performance evaluation model...
The problem of database buffer management has extensively been studied for nearly three decades. In ...
A database management system (DBMS) is a software tool that serves as an intermediary between the da...
During the last two decades, computer hardware has experienced remarkable developments. Especially C...
Accurate prediction of operator execution time is a prerequisite fordatabase query optimization. Alt...
Parallel servers offer improved processing power for relational database systems and provide system ...
We give formulas for estimating the number of disk accesses when accessing a file randomly with buff...
The hot-set model, characterizing the buffer requirements of relational queries, is presented. This ...
[[abstract]]It is well known that the behavior of page reference in a database environment is differ...
AbstractÐPast R-tree studies have focused on the number of nodes visited as a metric of query perfor...
This paper introduces a new approach to database disk buffering, called the LRU-K method. The basic ...
Abstract: Buffer memory allocation is one of the most important, but also one of the most difficult ...
Abstract. This paper introduces a new approach to database disk buffering, called the LFU-K method. ...
Accurate prediction of operator execution time is a prerequisite for database query optimization. Al...
Due to the recent improvements in the price/performance characteristics of workstations and the netw...
This paper presents a systematic survey of the existing database system performance evaluation model...
The problem of database buffer management has extensively been studied for nearly three decades. In ...
A database management system (DBMS) is a software tool that serves as an intermediary between the da...
During the last two decades, computer hardware has experienced remarkable developments. Especially C...
Accurate prediction of operator execution time is a prerequisite fordatabase query optimization. Alt...
Parallel servers offer improved processing power for relational database systems and provide system ...