AUTO COMMIT n option in a relational database

AUTO COMMIT n option in a relational database

Methods and systems are provided for executing a statement to make changes to data in a relational database while preventing the statement from failing due to the transaction log file becoming filled up. An AUTO COMMIT n option is provided for statements such as SQL statements in order to execute n...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: HU TENG S, LEE DAVID, DINH HUNG T, PHAM PHONG A
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Methods and systems are provided for executing a statement to make changes to data in a relational database while preventing the statement from failing due to the transaction log file becoming filled up. An AUTO COMMIT n option is provided for statements such as SQL statements in order to execute n data elements at a time. Each group of n data elements is committed after having been successfully executed in order to avoid filling up the transaction log file and causing the statement to fail.