Database system with improved methodology for page allocation

Abstract

A database system providing a methodology for optimized page allocation is described. During page allocation in the system, once an allocation page with free space has been located in the system's global allocation map or GAM (i.e., using routine page allocation steps), the page identifier for that allocation page is stored in a hint array, as part of that object's (i.e., table's) object descriptor or des. For a table undergoing a lot of splits (i.e., insert-intensive object), the system may store an array of allocation page “hints” (allocation page identifiers) in the des for that object (e.g., table). The array itself comprises a cache of slots (e.g., eight slots), each of which stores an allocation page identifier (“hint”) obtained from the GAM (from a GAM traversal occurring during the page allocation process) or is empty (i.e., has not been filled from the GAM and is therefore set to the initial value of null). For example, the first slot may store the page identifier for one allocation page. A second slot may store the page identifier for another, completely different allocation page, and so forth and so on. On subsequent passes through the page allocation process, the system can, rather than going to the GAM, randomly select (e.g., randomly hash on) a particular slot of the cache. In this manner, the incoming clients will, instead of competing for the same first-available allocation page, randomly select among multiple available allocation pages. Since each allocation page itself is protected by a separate latch, the system is able to decrease contention during the page allocation process by randomly accessing different elements of the “hint” array. In this manner, the system can avoid the computationally-expensive process of page allocation that is usually required as well as avoid contention for the first-available allocation page.