A new algorithm for page access sequencing in join processing

Abstract

One of the fundamental problems in relational database management is the handling of the join operation. Two of the problems are: 1) finding a page access sequence which requires the minimum number of bu er pages if there are no page reaccesses, and 2) finding a page access sequence which requires the minimum number of page reaccesses given a fixed bu er size. In general, a heuristic for the first problem can be converted to a corresponding heuristic to the second problem. In this paper, a new heuristic is proposed. The experimental results show that the new heuristic performs significantly better than existing heuristics for data which is modelled with geometric graphs, and no worse in others, for the first problem. It performs similarly better for the second problem if the fixed bu er size is not much less than the maximum bu er size generated in the first problem.