Dynamic synchronization of tables

Details Dynamic synchronization of tables Dynamic synchronization of tables

2008-04-22

2008-04-22

Hung, Pham Q (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10379605

ABSTRACT:
Each node in a network accessing a common database caches a copy of the database tables it uses and updates those tables based on changes made by other nodes in a coherent cache, i.e., those node that also have a copy of the tables in their cache. When a new node joins the coherent cache, dynamic synchronization of the table is performed by having one of the existing nodes act as a source to populate the table(s) required on the new (destination) node from its own copy. The dynamic synchronization controls the population operation and allows for the populating of tables on the destination node from partially populated tables on the source node. The dynamic synchronization of the tables permits database updates to continue to be made to the tables by the existing nodes in the coherent cache and provides a mechanism to propagate the committed updates to the tables on the destination node. Once the tables on the destination node are fully populated, all pending updates are suspended while a snapshot of the state of the table on the source node is taken. Once the destination node has processed the snapshot, active transactions on the source node are initiated on the destination node, and all transactions are allowed to modify the table on the destination node.

REFERENCES:
patent: 4914569 (1990-04-01), Levine et al.
patent: 5544347 (1996-08-01), Yanai et al.
patent: 5745904 (1998-04-01), King et al.
patent: 5781910 (1998-07-01), Gostanian et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 5832508 (1998-11-01), Sherman et al.
patent: 5835766 (1998-11-01), Iba et al.
patent: 5870765 (1999-02-01), Bauer et al.
patent: 5878410 (1999-03-01), Zbikowski et al.
patent: 5966706 (1999-10-01), Biliris et al.
patent: 5991771 (1999-11-01), Falls et al.
patent: 6029177 (2000-02-01), Sadiq et al.
patent: 6032158 (2000-02-01), Mukhopadhyay et al.
patent: 6052695 (2000-04-01), Abe et al.
patent: 6122630 (2000-09-01), Strickler et al.
patent: 6151602 (2000-11-01), Hejlsberg et al.
patent: 6157991 (2000-12-01), Arnon
patent: 6208990 (2001-03-01), Suresh et al.
patent: 6212531 (2001-04-01), Blea et al.
patent: 6247038 (2001-06-01), Banks et al.
patent: 6529921 (2003-03-01), Berkowitz et al.
patent: 6535892 (2003-03-01), LaRue et al.
patent: 7143177 (2006-11-01), Johnson et al.
patent: 7165213 (2007-01-01), Busey
Leverenz et al., “Oracle 8i Concepts”, Feb. 1999, Oracle Corporation, 26 pages, <http://www.csee.umbc.edu/help/oracle8/server.815/a67781/toc.htm>.
Leverenz et al., “Oracle 8i Concepts”, Feb. 1999, Oracle Corporation, 22 pages, <http://www.csee.umbc.edu/help/oracle8/server.815/a67781/toc.htm>.
“TimesTen 3.7—In—Memory Database for 32—bit and 64—bit Operating Systems,” TimesTen Performance Software, http://www.timesten.com/products/ttdatasheet.html, p. 11 Jun. 1999).
“TimeTen In—Memory Data Management—Technical White Paper,” Technical White Paper, TimesTen Performance Software, http://www.timesten.com/products/wp.html, p. 15 (2000).

Affiliated with

Also associated with

Rating

Dynamic synchronization of tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic synchronization of tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic synchronization of tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3947792