×

Method of buffering data objects in a database

  • US 5,680,573 A
  • Filed: 07/12/1994
  • Issued: 10/21/1997
  • Est. Priority Date: 07/12/1994
  • Status: Expired due to Term
First Claim
Patent Images

1. A method of buffering data objects in a database of a computer system, the computer system having one or more storage devices on which the data objects of the database are stored, the computer system also having a memory on which the data objects may be stored temporarily and accessed relatively faster than from the one or more storage devices, the computer system also supporting an on line transaction processing (OLTP) environment in which data objects are retrieved randomly and a decision support system (DSS) environment in which data objects are retrieved non-randomly, the method comprising the following steps:

  • (a) allocating a portion of the memory as a buffer cache;

    (b) allocating at least a first memory pool and a second memory pool each having a user configurable size within the buffer cache, the first memory pool having multiple identical storage blocks, each having a first storage capacity, and the second memory pool also having multiple identical storage blocks, each having a second storage capacity, the second storage capacity being greater than the first storage capacity;

    (c) identifying a selected data object;

    (d) determining whether the selected data object is selected randomly;

    (e) based upon whether the selected data object is selected randomly or non-randomly, determining in which memory pool to copy the selected data object; and

    (f) storing the data object in the memory pool identified in step (e)wherein the step of determining in which memory pool of the buffer cache to copy the data object determines that the data object should be copied to the first memory pool if the selected that object is randomly selected, and that the data object should be copied to the second memory pool if the selected data object is not randomly, selected.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×