Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-07-08
2008-11-25
Wassum, Luke S (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07457796
ABSTRACT:
A method for improved data sharing within a cluster of nodes having a database management system. The method 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: 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 Systems”, 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 12thInternational 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 Commercial Parallel Processing System”, Proceedings of the 10thInternational Parallel Processing Symposium (IPPS '96), Apr. 15-19, 1996, pp. 488-495.
Hallmark, G. “Oracle Parallel Warehouse Server”, Proceedings of the 13thInternational Conference on Data Engineering, Apr. 7-11, 1997, pp. 314-320.
Ronström, M. “Design and Modelling of a Parallel Data Server for Telecom Applications”, PhD Thesis, Linköping, University, Dissertation No. 520, 1998.
Sokolinsky, 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 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 Caches”, Proceedings of the 27thVLDB Conference, 2001.
Sokolinsky, 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.
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, M. Bauer, R. Greenwald, G. Lumpkin and M. Reddy “Technical Comparison of Oracle9i Real Application Clusters vs. IBM DB2 UDB EEE v8.1”, white paper, Oct. 2002.
Chandrasekaran, S. and R. Bamford “Shared Cache—The Future of Parallel Databases”, Proceedings of the 19thInternational 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.
Adam, R. N.; Tewari, R.:“Regeneration with Virtual Copies for Replicated Databases”, 1991, IEEE, p. 429-436, CH2996-7/91/0000/0429.
Teuhola, J.:“Deferred Maintenance of Replicated Objects in Single-Site Databases”, 1996, IEEE, p. 476-481, 0-8186-7662-0/96, and no more.
Lashley Scott David
Taylor Paul Sherwood
International Business Machines - Corporation
Kunzler & McKenzie
Wassum Luke S
LandOfFree
Method 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 Method 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 Method using virtual replicated tables in a cluster database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4033997