Dynamic database memory management policies

Details Dynamic database memory management policies Dynamic database memory management policies

2006-10-30

2010-11-23

Krofcheck, Michael C (Department: 2186)

Electrical computers and digital processing systems: memory

Storage accessing and control

Specific memory composition

C711S122000, C711S135000, C711SE12017, C707S705000

Reexamination Certificate

active

07840752

ABSTRACT:
A database engine is provided with memory management policies to dynamically configure an area of memory called a buffer pool into which data pages are held during processing. The data pages are also buffered as an I/O (input/output) stream when read and written to a persistent storage medium, such as a hard disk, through use of a system file cache that is managed by the computer's operating system. The memory management policies implement capping the amount of memory used within the buffer pool to minimize the number of data pages that are double-buffered (i.e., held in both the buffer pool and system file cache). In addition, trimming data pages from the buffer pool, after the database engine completes all pending operations and requests, frees additional memory and further minimizes the number of processes associated with the database.

REFERENCES:
patent: 5574902 (1996-11-01), Josten et al.
patent: 5613125 (1997-03-01), Nguyen et al.
patent: 5822749 (1998-10-01), Agarwal
patent: 5826253 (1998-10-01), Bredenberg
patent: 5895488 (1999-04-01), Loechel
patent: 6351749 (2002-02-01), Brown et al.
patent: 6470423 (2002-10-01), Ho et al.
patent: 6567823 (2003-05-01), Rothschild
patent: 6795898 (2004-09-01), Weinreb et al.
patent: 6968424 (2005-11-01), Danilak
patent: 7039765 (2006-05-01), Wilkes
patent: 7124252 (2006-10-01), Khare et al.
patent: 7337281 (2008-02-01), Jin et al.
patent: 2002/0046204 (2002-04-01), Hayes
patent: 2002/0065948 (2002-05-01), Morris et al.
patent: 2003/0140198 (2003-07-01), Ninose et al.
patent: 2004/0088336 (2004-05-01), Pasupathy
patent: 2004/0111557 (2004-06-01), Nakatani et al.
patent: 2005/0044311 (2005-02-01), Lahiri et al.
patent: 2005/0050074 (2005-03-01), Jain et al.
patent: 2006/0036655 (2006-02-01), Lastovica, Jr.
patent: 2006/0074872 (2006-04-01), Gordon
patent: 2006/0085489 (2006-04-01), Tomic et al.
patent: 2006/0149892 (2006-07-01), McFarling
Chou, Hong-Tai, “An Evaluation of Buffer Management Strategies for Relational Database Systems”, http://www.cs.berkeley.edu/˜brewer/cs262/DBBufMgmt.pdf, Date: 1985.
Cornell et al., “Integration of Buffer Management and Query Optimization in Relational Database Environment”, Date: 1989, http://www.vldb.org/conf/1989/P247.PDF.
Stonebraker, Michael, “Operating System Support for Database Management”, Date; Jul. 1981, vol. 24, No. 7, http://www.ics.uci.edu/˜ics214a/handouts/stonebraker pdf.

Affiliated with

Also associated with

Rating

Dynamic database memory management policies does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic database memory management policies, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic database memory management policies will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4216856