Dynamic adjustment of commit frequency
AssigneeSoftbase Systems, Inc.
InventorsWilliam E. Scardo, Gary L. Blair
Life of this patent
Estimating the term…
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.
Claims48
In an interface between a relational database application program and a database management system, the interface selectively passing statements issued by the application program on to the database management system, the database application program including commit statements, and the database management system including a commit facility to effect a commit operation to commit pending database changes and release locks, a method of reducing application program execution time by reducing the number of commit operations performed by the commit facility, said method comprising repeatedly:
- suppressing commit statements issued by the application program until a time interval based on a time interval parameter has elapsed;
- and
- passing the next commit statement issued by the application program on to the database management system.
For an interface between a relational database application program and a database management system, the interface selectively passing statements issued by the application program on to the database management system, the database application program including commit statements, and the database management system including a commit facility to effect a commit operation to commit pending database changes and release locks, a method comprising providing for repeatedly:
- suppressing commit statements issued by the application program until a time interval based on a time interval parameter has elapsed;
- and
- passing on to the database management system every nth commit statement issued by the application program.
A computer system for interfacing between a relational database application program that includes commit statements and a database management system that includes a commit facility to effect a commit operation to commit pending database changes and release locks, said computer system comprising a selection component that suppresses commit statements issued by the application program until a time interval based on a time interval parameter has elapsed, and passes the next commit statement issued by the application program on to the database management system.
An article of manufacture comprising:
- a computer usable medium having computer readable program code means embodied thereon for providing an interface between a relational database application program that includes commit statements and a database management system that includes a commit facility to effect a commit operation to commit pending database changes and release locks, said computer readable program code means in said article of manufacture comprising means for repeatedly causing commit statements issued by the application program to be suppressed until a time interval based on a time interval parameter has elapsed, and causing the next commit statement issued by the application program to be passed on to the database management system.
Dependencies are inferred from the claim text.