Method for repairing constraint violations in a database management system
US6189010A · kind A · utility
17Cited by
15References
18Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Jun 10, 1998 |
| Grant date | Feb 13, 2001 |
| Priority date | — |
| Expiry date | Jun 10, 2018 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99938
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In response to a constraint violation in a row of a database table, an output file is generated including the characteristics of the table containing the row in error as well as an SQL UPDATE statement for the row. The SQL UPDATE statement includes the column values in the row which can be corrected by the user, the user modified SQL UPDATE statement being subsequently executed to repair the constraint violation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.