Online repair of a replicated table

Details Online repair of a replicated table Online repair of a replicated table

2005-02-18

2011-10-11

Mofiz, Apu (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Search engines

C707S634000, C707S696000

Reexamination Certificate

active

08037056

ABSTRACT:
A method repairs a table. A replication environment has a first replicate comprising a source table on a source server and a target table on a target server. The source server transmits replication data from the source server with repair data from the source server to the target table in accordance with a commit order of the replication data and the repair data. The target server applies the repair data and the replication data to the target table based on the commit order.

REFERENCES:
patent: 5170480 (1992-12-01), Mohan et al.
patent: 5381545 (1995-01-01), Baker et al.
patent: 5423037 (1995-06-01), Hvasshovd
patent: 5675727 (1997-10-01), Watanabe
patent: 5684984 (1997-11-01), Jones et al.
patent: 5737601 (1998-04-01), Jain et al.
patent: 5745753 (1998-04-01), Mosher, Jr.
patent: 5781912 (1998-07-01), Demers et al.
patent: 5799306 (1998-08-01), Sun et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 5884327 (1999-03-01), Cotner et al.
patent: 5884328 (1999-03-01), Mosher, Jr.
patent: 5926819 (1999-07-01), Doo et al.
patent: 5937415 (1999-08-01), Sheffield et al.
patent: 6058401 (2000-05-01), Stamos et al.
patent: 6061769 (2000-05-01), Kapulka et al.
patent: 6119130 (2000-09-01), Nguyen et al.
patent: 6122630 (2000-09-01), Strickler et al.
patent: 6216136 (2001-04-01), Ronström
patent: 6216137 (2001-04-01), Nguyen et al.
patent: 6351795 (2002-02-01), Hagersten
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6377959 (2002-04-01), Carlson
patent: 6408163 (2002-06-01), Fik
patent: 6421686 (2002-07-01), Martin, Jr.
patent: 6460052 (2002-10-01), Thomas et al.
patent: 6507880 (2003-01-01), Arimilli et al.
patent: 6510421 (2003-01-01), Ganesh et al.
patent: 6529917 (2003-03-01), Zoltan
patent: 6529932 (2003-03-01), Dadiomov et al.
patent: 6532479 (2003-03-01), Souder et al.
patent: 6553442 (2003-04-01), Arimilli et al.
patent: 6584477 (2003-06-01), Mosher, Jr.
patent: 6587856 (2003-07-01), Srinivasan et al.
patent: 6615223 (2003-09-01), Shih et al.
patent: 6668260 (2003-12-01), Zoltan
patent: 6681226 (2004-01-01), Bretl et al.
patent: 6721765 (2004-04-01), Ghosh et al.
patent: 6732122 (2004-05-01), Zoltan
patent: 6738971 (2004-05-01), Chandrasekaran et al.
patent: 6748374 (2004-06-01), Madan et al.
patent: 6877016 (2005-04-01), Hart et al.
patent: 6915287 (2005-07-01), Felsted et al.
patent: 6983277 (2006-01-01), Yamaguchi et al.
patent: 7003531 (2006-02-01), Holenstein et al.
patent: 7162689 (2007-01-01), Demers et al.
patent: 7200620 (2007-04-01), Gupta
patent: 7200624 (2007-04-01), He et al.
patent: 7376675 (2008-05-01), Pruet, III
patent: 2001/0007103 (2001-07-01), Breiter et al.
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2002/0016793 (2002-02-01), Keith, Jr.
patent: 2002/0065999 (2002-05-01), Kikuchi et al.
patent: 2002/0078231 (2002-06-01), Chang et al.
patent: 2002/0087586 (2002-07-01), Yamagishi
patent: 2002/0091716 (2002-07-01), Yokouchi
patent: 2002/0099728 (2002-07-01), Lees et al.
patent: 2002/0169788 (2002-11-01), Lee et al.
patent: 2002/0174142 (2002-11-01), Demers et al.
patent: 2002/0198899 (2002-12-01), Yamaguchi et al.
patent: 2003/0046342 (2003-03-01), Felt et al.
patent: 2003/0149709 (2003-08-01), Banks
patent: 2003/0154238 (2003-08-01), Murphy et al.
patent: 2003/0158868 (2003-08-01), Zoltan
patent: 2003/0182308 (2003-09-01), Ernst et al.
patent: 2003/0208511 (2003-11-01), Earl et al.
patent: 2003/0212789 (2003-11-01), Hamel et al.
patent: 2003/0225760 (2003-12-01), Ruuth et al.
patent: 2003/0236786 (2003-12-01), Shi et al.
patent: 2004/0006563 (2004-01-01), Zwiegincew et al.
patent: 2004/0025079 (2004-02-01), Srinivasan et al.
patent: 2004/0030703 (2004-02-01), Bourbonnais et al.
patent: 2004/0078379 (2004-04-01), Hinshaw et al.
patent: 2004/0103342 (2004-05-01), Moser et al.
patent: 2004/0133591 (2004-07-01), Holenstein et al.
patent: 2004/0158588 (2004-08-01), Pruet, III
patent: 2004/0205066 (2004-10-01), Bhattacharjee et al.
patent: 2005/0021567 (2005-01-01), Holenstein et al.
patent: 2005/0125423 (2005-06-01), Chou et al.
patent: 2005/0165818 (2005-07-01), Cole et al.
patent: 2005/0193024 (2005-09-01), Beyer et al.
patent: 2005/0193035 (2005-09-01), Byrne
patent: 2005/0193040 (2005-09-01), Adiba et al.
patent: 2005/0193041 (2005-09-01), Bourbonnais et al.
patent: 2005/0278394 (2005-12-01), Oks et al.
patent: 2006/0031811 (2006-02-01), Ernst et al.
patent: 2006/0047713 (2006-03-01), Gornshtein et al.
patent: 2006/0190497 (2006-08-01), Inturi et al.
patent: 2006/0190498 (2006-08-01), Pruet, III
patent: 2006/0190504 (2006-08-01), Pruet, III
patent: 2007/0226218 (2007-09-01), Chatterjee et al.
patent: 2008/0059469 (2008-03-01), Pruet
patent: 2008/0215586 (2008-09-01), Pruet
patent: 07210435 (1995-08-01), None
patent: 03044697 (2003-05-01), None
Dominic J. Delmolino, “Strategies and Techniques for Using Oracle7 Replication: Part 1”, Archives, Oracle Magazine Interactive, Methodology [online], May/Jun. 1995, [retrieved on: Jul. 16, 2004] Retrieved from the Internet: <URL: http://arthemis.na.astro.it/oracle/oramag/archives/55METH.html>. 11 pages.
Fabio A.M. Porto et al. “Persistent Object Synchronization with Active Relational Databases”, IEEE/ACM AN-6364906, pp. 53-62; Technology of Object-Oriented Languages and Systems, Aug. 1-5, 1999, Santa Barbara, California, IEEE Computer Society.
T.N. Vijaykumar et al, “Transient-Fault Recovery Using Simultaneous Multithreading,” Proceedings of the 29th Annual International Symposium on Computer Architecture (ISCA '02), 1063-6897/02, copyright 2002 IEEE, IEEE Computer Society, 12 pages.
IBM Technical Disclosure Bulletin, “Referential Integrity Implementation Details and Advantages,” Mar. 1995, pp. 477-488, [online] [retrieved on: Jun. 4, 2004] Retrieved from the Internet: <URL: https//www.delphion.com/tdbs/tdb?o=95A%2060598>. 6 pages.
“Informix Guide to SQL Syntax, Chapter 1: SQL Statements, Alter Table,” [online] copyright 1998, Informix Software, Inc., [Retrieved on Jan. 17, 2005]. Retrieved from the Internet: <URL: http://www-306.ibm.com/software/data/informix/pubs/library/datablade/dbdk/sqls/01alter.fm1.html>. 22 pages.
Al-Karmi el al., IBM Technical Disclosure Bulletin, “Type Modification in Object Oriented database Using Exception Handling,” IBMTDBS#AAA93A063495, v36n12 12-93, pp. 579-580. [online] Dec. 1993 [Retrieved on Aug. 30, 2004] Retrieved from the Internet <URL: https://www.delphion.com/tdbs/tdb?order=93A+63495>. 2 pages.
Teresa K. Ge, Wayne W. Lee, Brenda M. Lam, United States Patent Application titled “Differential Management of Database Schema Changes,” Filed Dec. 17, 2004, Assigned to International Business Machines Corporation, IBM Docket No. CA9200400048US1. 23 pages.
Cuenca-Acuna et al., “Autonomous Replication for High Availability in Unstructured P2P Systems”, Proceedings of the 22nd International Symposium on Reliable Distributed Systems (SRDS'03), 2003, 10 pages.
Ghandeharizadeh et al., “Placement of Continuous Media in Wireless Peer-to-Peer Networks,” IEEE Transactions on Multimedia, vol. 6, No. 2, Apr. 2004, pp. 335-342.
Joshi et al., “ShadowObjects: A Programming Model for Service Replication in Distributed Object Systems,” Journal of Parallel and Distributed Computing, vol. 59, No. 1, Oct. 1999. 16 pages.
“Technique for Replicating Distributed Directory Information”, May 1991, IBM Technical Disclosure Bulletin, pp. 113-120, [online] [retrieved on Jun. 4, 2004] Retrieved from the Internet<URL: https://www.delphion.com/tdbs/tdb?o=91A%2061241>. 6 pages.
IBM Informix Dynamic Server Enterprise Replication Guide, Version 9.4, Mar. 2003, Part No. CT1T2NA, pp. i-ix, pp. 1 to 9-22.
IBM Informix Dynamic Server Enterprise Replication Guide, Version 9.4, Mar. 2003, Part No. CT1T2NA, pp. i-ii, pp. Appendix A-1 to G-4, Index pp. 1-18.
Non-Final Office Action of Jun. 22, 2007 for U.S. Appl. No. 11/061,071 <10 pages>.
Notice of Allowance of Jan. 14, 2008 for U.S. Appl. No. 1

Affiliated with

Also associated with

Rating

Online repair of a replicated table does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Online repair of a replicated table, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Online repair of a replicated table will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4260833