Invention Grant
- Patent Title: Adding a key column to a table to be replicated
- Patent Title (中): 向要复制的表添加键列
-
Application No.: US13194393Application Date: 2011-07-29
-
Publication No.: US08554730B2Publication Date: 2013-10-08
- Inventor: Prasad S. Mujumdar , Clarence M. Pruet, III
- Applicant: Prasad S. Mujumdar , Clarence M. Pruet, III
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F9/46

Abstract:
Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.
Public/Granted literature
- US20130031051A1 ADDING A KEW COLUMN TO A TABLE TO BE REPLICATED Public/Granted day:2013-01-31
Information query