VIRTUAL MEMORY MANAGEMENT FOR DATABASE SYSTEMS.

Abstract

In this paper, two particular approaches to database system design are discussed and it is explained how and why they interface to file systems as they do. The potential advantages and implications of working more closely with virtual memory management are examined and some of the functions and constraints that would have to be supported by a generalized page manager are described. The first database approach is called 'shadow paging,' and is described in the context of a relational database system called System R. The second is called 'write ahead log. ' Although these appraoches are not the only ones, they have some interesting properties and differences which help to understand issues like recovery and performance in a more general context.