Data processing: database and file management or data structures – File or database maintenance – Synchronization
Reexamination Certificate
2008-10-17
2011-10-04
Wassum, Luke S (Department: 2167)
Data processing: database and file management or data structures
File or database maintenance
Synchronization
C707S694000, C707S704000, C707S966000
Reexamination Certificate
active
08032488
ABSTRACT:
A system for improved data sharing within a cluster of nodes having a database management system. The system defines a virtual replicated table as being useable in a hybrid of a shared-cache and shared-nothing architecture. The virtual replicated table is a physically single table sharable among a plurality of cluster nodes for data read operations and not sharable with other cluster nodes for data modification operations. Default owner node is assigned for each virtual replicated table to ensure the page validity and provide requested pages to the requesting node.
REFERENCES:
patent: 5222217 (1993-06-01), Blount et al.
patent: 5815649 (1998-09-01), Utter et al.
patent: 6115790 (2000-09-01), Schimmel
patent: 6182282 (2001-01-01), Stoodley et al.
patent: 6233668 (2001-05-01), Harvey et al.
patent: 6321238 (2001-11-01), Putzolu
patent: 6341340 (2002-01-01), Tsukerman et al.
patent: 6529906 (2003-03-01), Chan
patent: 6542926 (2003-04-01), Zalewski et al.
patent: 6625593 (2003-09-01), Leung et al.
patent: 6643711 (2003-11-01), Bracha et al.
patent: 6711571 (2004-03-01), Putzolu
patent: 6741997 (2004-05-01), Liu et al.
patent: 7107270 (2006-09-01), Putzolu
patent: 7120651 (2006-10-01), Bamford et al.
patent: 7139772 (2006-11-01), Bamford et al.
patent: 7277897 (2007-10-01), Bamford et al.
patent: 7457796 (2008-11-01), Lashley et al.
patent: 2001/0029502 (2001-10-01), Oeda
patent: 2002/0038437 (2002-03-01), Hogdal et al.
patent: 2002/0052914 (2002-05-01), Zalewski et al.
patent: 2002/0138628 (2002-09-01), Tingley et al.
patent: 2002/0174142 (2002-11-01), Demers et al.
patent: 2003/0018876 (2003-01-01), Zahir et al.
patent: 2003/0158868 (2003-08-01), Zoltan
patent: 2003/0182319 (2003-09-01), Morrison
patent: 2004/0030731 (2004-02-01), Iftode et al.
patent: 2004/0030739 (2004-02-01), Yousefi'zadeh
patent: 2004/0133538 (2004-07-01), Amiri et al.
patent: 2004/0133591 (2004-07-01), Holenstein et al.
patent: 2004/0215883 (2004-10-01), Bamford et al.
patent: 2005/0187977 (2005-08-01), Frost
patent: 2005/0283658 (2005-12-01), Clark et al.
Li, K. and P. Hudak, “Memory Coherence in Shared Virtual Memory Systems”, ACM Transactions on Computer Systems, vol. 7, No. 4, Nov. 1989, pp. 321-359.
Cheriton, D.R., H.A. Goosen and P.D. Boyle, “ParaDiGM: A Highly Scalable Shared-Memory Multi-Computer Architecture”, Report No. STAN-CS-90-1344, Stanford University, Department of Computer Science, Nov. 1990.
Rys, M. and G. Weikum, “Heuristic Optimization of Speedup and Benefit/Cost for Parallel Database Scans on Shared-Memory Multiprocessors”, Proceedings of the Eighth International Parallel Processing Symposium, Apr. 26-29, 1994, pp. 894-901.
Mohan, C., H. Pirahesh, W.G. Tang and Y. Wang, “Parallelism in Relational Database Management Sysytems”, IBM Systems Journal, vol. 33, No. 2, 1994, pp. 349-371.
Brinkhoff, T., H-P. Kriegel and B. Seeger, “Parallel Processing of Spatial Joins Using R-trees”, Proceedings of the 12th International Conference on Data Engineering, Feb. 26-Mar. 1, 1996, pp. 258-265.
Nick, J.M., J-Y. Chung and N.S. Bowen, “Overview of IBM System/390 Parallel Sysples—A Commercail Parallel Processing System”, Proceedings of the 10th International Parallel Processing Symposium (IPPS 96), Apr. 15-19, 1996, pp. 488-495.
Hallmark, G. “Oracle Parallel Warehouse Server”, Proceedings of the 13th International Conference on Data Engineering, Apr. 7-11, 1997, pp. 314-320.
Ronstrom, M. “Design and Modeling of a Parallel Data Server for Telecom Applications”, PhD Thesis, Linkoping University, Dissertation No. 520, 1997.
Adam, R.N.; Tewari, R. “Regeneration with Virtual Copies for Replicated Databases”, 1991 IEEE, p. 429-436, CH2996-7/91/0000/0429, 1991.
Teuhola, J.; “Deferred Maintenance of Replicated Objects in Single-Site Database”, 1996, IEEE, p 476-481, 0-8186-7662-0/96, Sep. 9, 1996.
Sokolinksy, L.B., “Choosing Multiprocessor System Architecture for Parallel Database Systems”, Proceedings of the Workshop on Computer Science and Information Technologies (CSIT'2000) Ufa, Russia, 2000.
Jones, J., “Not-So-Silent Strengths of DB2 Universal Database: An Examination of the Strengths of the Strengths of the IBM DB2 Family”, IBM Corporation, Apr. 2001.
Lahiri, T., V. Srihari, W. Chan, N. Macnaughton and S. Chandrasekaran, “Cache Fusion: Extending Shared-Disk Clusters with Shared Cahes”, Proceedings of the 27th VLDB Conference, 2001.
Sokolinksy, L.B., “Organization of Parallel Query Processing in Multiprocessor Database Machines with Hierarchical Architecture”, Programming and Computer Software, vol. 27, No. 6, 2001, pp. 297-308, Aug. 2000.
Oracle, “Oracle9i Real Application Clusters Concepts, Release 1 (9.0.1)”, Part No. A89867-02, Chapter 5.
DeMel, S., M. Holt and M. Bauer, “Oracle9i Real Application Clusters: Cache Fusion Delivers Scalability”, Oracle White Paper, Feb. 2002.
Josten, J., C. Cotner and C. Young, “DB2 for zSeries on Parallel Sysplex: Your Key to Application Availability, Scalability and High Performance”, white paper, Aug. 2002.
Chandrasekaran, S., B. Kehoe, V. Buch, R. Greenwald, G. Lumpkin and M. Reddy, “Techinical Comparison of Oracle9i Real Application Clusters vs. IBM DB2 EEE v8. 1”, white paper, Oct. 2002.
Chandrasekaran, S. and R. Bamford, “Shared Cache—The Future of Parallel Database”, Proceedings of the 19th International Conference on Data Engineering (ICDE'03), 2003, pp. 840-850.
DeWitt, D.J., S. Madden and M. Stonebraker, “How to Build a High-Performance Data Warehouse”, Downloaded from db.lcs.mit.edu/madden/high—perf.pdf, 2006.
Brinkoff et al., “Paralell Processing of Spatial Joins Using R-Trees”, Abstract, IEEE Xplore Release 2.5, Feb. 26-Mar. 1, 1996, current version published Aug. 6, 2002.
Hallmark, “Oracle Parallel Warehouse Server”, Abstract, IEEE Xplore Release 2.5, Apr. 7-11, 1997, current version published Aug. 6, 2002.
Nick et al., “Overview of IBM system/390 Parallel Sysplex-a Commercial Parallel Processing System”, Abstract, IEEE Xplore Release 2.5, Apr. 15-19, 1996, current version published Aug. 6, 2002.
“8th International Parallel Processing Symposium”, cover page, Apr. 26-29, 1994, Cancun, Mexico, downloaded on Feb. 5, 2009 from IEEE Xplore.
Lashley Scott David
Taylor Paul Sherwood
International Business Machines - Corporation
Kunzler Needham Massey & Thorpe
Wassum Luke S
LandOfFree
System using virtual replicated tables in a cluster database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System using virtual replicated tables in a cluster database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System using virtual replicated tables in a cluster database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4274967