Dynamic adjustment of commit frequency

Details Dynamic adjustment of commit frequency Dynamic adjustment of commit frequency

2006-07-11

2006-07-11

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07076480

ABSTRACT:
An interface between a relational database application program and a database management system that reduces application program execution time by reducing the number of commit operations performed by the commit facility of the database management system. Repeatedly, commit statements issued by the application program are suppressed until a time interval based on a time interval parameter has elapsed, and then the next commit statement issued by the application program is passed on to the database management system.

REFERENCES:
patent: 5319773 (1994-06-01), Britton et al.
patent: 5369764 (1994-11-01), Blair
patent: 5940827 (1999-08-01), Hapner et al.
patent: 5950212 (1999-09-01), Anderson et al.
patent: 6286004 (2001-09-01), Yoshiura et al.
patent: 6751753 (2004-06-01), Nguyen et al.
patent: 1 394 700 (2004-03-01), None
European Search Report mailed Jun. 22, 2004 and prepared May 12, 2004 in corresponding European Application No. EP 03251302 (published as No. EP 1 394 700 A2 on Mar. 3, 2004), European Patent Office—Berlin, (2 pages plus cover).
Adams S.: “Oracle Advanced Performance Tuning Script—Redo Log Scripts” Internet Publication, Online! May 15, 2002, XP002278874 Retrieved from the Internet: <URL:http://www.ixora.com.au/scripts/redo—log.htm#commit—every > re-retrieved on Jul. 15, 2004.
International Technical Support Organization: “DB2 for OS/390 Application Design Guidelines for High Performance” Internet Publication, Online! Aug. 1997, XP002278875 Retrieved from the Internet: <URL:http://www.frc.utn.edu.ar/campus/ibm/pdfs/sg242233.pdf> re-retrieved on Jul. 15, 2004 section “5.7.4 Commit Frequency”.
Dunn S: “Commit Frequency” Internet Publication, Online! Apr. 14, 1995, XP002278876 Retrieved from the Internet: <URL: http://groups.google.de/groups?q=commit+frequency+elapsed&hl=de&lr=&ie=UTF-8&selm=797898111snz%40lilydale.demon.co.uk&mum=1> re-retrieved on Jul. 15, 2004.
Adams S: “How to speed up an update” Internet Publication, Online! Apr. 5, 2001, XP002278877 Retrieved from the Internet: <URL:http://www.ixora.com.au/q+a/0104/05144430.htm>re-retrieved on May 3, 2004! *the whole document*.
Baker B: “The Woes of Commitment” Internet Publication- DB2 Magazine, Online! 1998, XP002278878 Retrieved from the Internet: <URL:http://www.db2mag.com/db—area/archives/1998/q3/98fprog.shtml> re-retrieved on Jul. 15, 2004 section “Too Many Commits” section “and this is just Right”.

Affiliated with

Also associated with

Rating

Dynamic adjustment of commit frequency 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 adjustment of commit frequency, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic adjustment of commit frequency will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3537774