Optimized constraint and index maintenance for non updating updates
US7801882B2 · kind B2 · utility
12Cited by
7References
29Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Oct 1, 2004 |
| Grant date | Sep 21, 2010 |
| Priority date | — |
| Expiry date | Dec 3, 2025 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/221
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Database management systems allow modification of existing table rows through update statements or other data modification commands. For example, a user may specify, via a command statement, the table to update, the columns to modify and their respective new value(s), and qualify the rows to be updated. Optimized constraint and index maintenance for data modification statements and commands is provided where the new value being assigned to the columns is actually the same as the current value, e.g., update commands that actually leave the columns unchanged.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.