AUTO COMMIT n option in a relational database
US7650358B2 · kind B2 · utility
1Cited by
8References
14Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Sep 22, 2005 |
| Grant date | Jan 19, 2010 |
| Priority date | — |
| Expiry date | Jan 15, 2027 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.