Invention Grant
- Patent Title: Method and apparatus for propagating tables while preserving cyclic foreign key relationships
- Patent Title (中): 在保留循环外键关系的同时传播表的方法和装置
-
Application No.: US11427930Application Date: 2006-06-30
-
Publication No.: US08285677B2Publication Date: 2012-10-09
- Inventor: James E. Bostick , Randolph M. Forlenza , John P. Kaemmerer , Raghuraman Kalyanaraman
- Applicant: James E. Bostick , Randolph M. Forlenza , John P. Kaemmerer , Raghuraman Kalyanaraman
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Yee & Associates, P.C.
- Agent Mark C. Vallone
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The invention meeting the need identified above is the “Enhanced Database Propagation Program” or (EDPP). EDPP uses a cyclic member table that identifies a first source table in a cyclic relationship with a second source table. The first source table, identified in the cyclic member table, propagates first. EDPP replaces all foreign keys with “NULL” in the first target table. After the second source table in the subscription set has propagated to a second target table, EDPP updates first target table with the foreign keys from the first source table.
Public/Granted literature
- US20080005183A1 Method And Apparatus for Propagating Tables While Preserving Cyclic Foreign Key Relationships Public/Granted day:2008-01-03
Information query