Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-04-10
2007-04-10
Gafrin, Jeffrey (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10789625
ABSTRACT:
A method and system for asynchronously replicating data changes in a database system captures update information for a data update in a source table from a database log, where the data value from the data update is not in the database log. A query is built to obtain the data value from the source table using the update information, including a key column value that identifies the row of the source table in which the data resides. When the key column is also updated in the same or different transaction, the data update information is stored, and the updated key column value is replaced with a later captured key column update value. The query is built and executed, and the data update is replicated at a target table. In this manner, data objects whose values are not recorded in a database log can be asynchronously replicated in a database system.
REFERENCES:
patent: 5890154 (1999-03-01), Hsiao et al.
patent: 5920860 (1999-07-01), Maheshwari et al.
patent: 6061689 (2000-05-01), Chang et al.
patent: 6067541 (2000-05-01), Raju et al.
patent: 6073140 (2000-06-01), Morgan et al.
patent: 6105017 (2000-08-01), Kleewein et al.
patent: 6144966 (2000-11-01), Roberts
patent: 6209000 (2001-03-01), Klein et al.
patent: 6466950 (2002-10-01), Ono
patent: 6490595 (2002-12-01), Candee et al.
patent: 6738082 (2004-05-01), Dong et al.
patent: 6889231 (2005-05-01), Souder et al.
patent: 6993539 (2006-01-01), Federwisch et al.
patent: 7031974 (2006-04-01), Subramaniam
patent: 7076481 (2006-07-01), Osborne et al.
patent: 7076508 (2006-07-01), Bourbonnais et al.
Doug Stacey, Replication: DB2, Oracle, or Sybase?, Dec. 1995, ACM Sigmod record, vol. 24, issue 4, pp. 95-101.
Calton Pu et al., Replica Control in Distributed System: An Asynchronous Approach, Apr. 1991, ACM Press, vol. 20, issue 2, pp. 377-386.
Rober haskin et al., Recovery management in QuickSilver, Feb. 1988, ACM Press, vol. 6, issue 1, pp. 82-108.
Lei Gao et al., Application Specific Data Replication for Edge Services,May 2003, ACM Press, pp. 449-460.
Carino, F. et al., “StorHouse Metanoia—New Applications for Database, Storage & Data Warehousing,” 2001, 521-531.
Hartisa, J. et al., “Value-Based Scheduling in Real Time Database Systems,” 1993, 117-126.
Bernstein, P. et al., “Context-Based Prefetch—an Optimization for Implementing Objects on Relations,” 2000, 177-189.
Connell, W. et al., “Optimizer and Parallel Engine Extensions for Handling Expensive Methods Based on Large Objects,” 1999, 304-313.
Jennings, R., “SQL Server 2000 Gains on Oracle,” Visual Basic Progammer's Journal, vol. 10, 2000, pp. 20-29.
Adiba Nicolas G.
Anaya Jaime F.
Lindsay Bruce G.
Rost Guido
Surjanto Budi
Gafrin Jeffrey
Sawyer Law Group LLP
Veillard Jacques
LandOfFree
Algorithm to find LOB value in a relational table after key... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Algorithm to find LOB value in a relational table after key..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Algorithm to find LOB value in a relational table after key... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3752007