Invention Grant
US08244675B2 Method and apparatus for updating a database using table staging and queued relocation and deletion
有权
使用表格分级和排队重定位和删除来更新数据库的方法和装置
- Patent Title: Method and apparatus for updating a database using table staging and queued relocation and deletion
- Patent Title (中): 使用表格分级和排队重定位和删除来更新数据库的方法和装置
-
Application No.: US11134030Application Date: 2005-05-20
-
Publication No.: US08244675B2Publication Date: 2012-08-14
- Inventor: John Walter Moore , Richard Bruce Gough , Jared Moran , Joseph Wenger
- Applicant: John Walter Moore , Richard Bruce Gough , Jared Moran , Joseph Wenger
- Applicant Address: US NY Islandia
- Assignee: CA, Inc.
- Current Assignee: CA, Inc.
- Current Assignee Address: US NY Islandia
- Agency: Baker Botts L.L.P.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00
Abstract:
Methods and systems for updating a database with one or more update records are provided in the present application. A staged table corresponding to a primary table of the database is generated. The update record is processed to validate the update record to determine whether there is an error in the update record and to add the update record to the staged table. The update record is copied from the staged table to the primary table when there is no error in the update record. The update record is deleted from the staged table after the update record is processed.
Public/Granted literature
- US20050267914A1 Method and apparatus for updating a database using table staging and queued relocation and deletion Public/Granted day:2005-12-01
Information query
