Method and system of database divisional management for...

Details Method and system of database divisional management for... Method and system of database divisional management for...

2000-09-19

2009-10-06

Corrielus, Jean M (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07599910

ABSTRACT:
A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.

REFERENCES:
patent: 4344134 (1982-08-01), Barnes
patent: 5283731 (1994-02-01), Lalonde et al.
patent: 5283897 (1994-02-01), Georgiadis et al.
patent: 5423037 (1995-06-01), Hvasshovd
patent: 5485607 (1996-01-01), Lomet et al.
patent: 5504894 (1996-04-01), Furguson et al.
patent: 5515531 (1996-05-01), Fujiwara et al.
patent: 5524257 (1996-06-01), Koike et al.
patent: 5544313 (1996-08-01), Shachnai et al.
patent: 5548761 (1996-08-01), Balasundaram et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5555404 (1996-09-01), Torbjørnsen
patent: 5625815 (1997-04-01), Maier et al.
patent: 5813005 (1998-09-01), Tsuchida et al.
patent: 5822780 (1998-10-01), Schutzman
patent: 6101495 (2000-08-01), Tsuchida et al.
patent: 6192359 (2001-02-01), Tsuchida et al.
patent: 6510428 (2003-01-01), Tsuchida et al.
patent: 6801921 (2004-10-01), Tsuchida et al.
patent: 6829623 (2004-12-01), Tsuchida et al.
patent: 7321907 (2008-01-01), Tsuchida et al.
patent: 63318628 (1988-12-01), None
patent: 02028877 (1990-01-01), None
patent: 02247748 (1990-10-01), None
patent: 05036343 (1993-02-01), None
patent: 6314299 (1993-04-01), None
patent: 05261085 (1993-10-01), None
patent: 05265954 (1993-10-01), None
Wolf et al, “A Hybrid Data Sharing-Data Partitioning Architecture for Transaction Processing” IEEE, pp. 520-527.
David et al, “Parallel Database Systems: The Future of High Performance Database Systems” ACM, vol. 35, No. 6, p. 85 (14).
Osman et al, “A Load Balancing Aproach for Parallel Database Machines”, IEEE, Nov. 1995, pp. 51-58.
Yu et al, Dynamic Transaction Routing in Distributed Database Systems, IEEE, Nov. 1988, pp. 1307-1318.
Oracle 8TM Server SQL Reference, Release 8.0, Jun. 1997, pp. 4-139 to 4-142 and 4-148 to 4-153.
Lu, et al, “Dynamic and Load-balanced Task-Oriented Database Query Processing in Parallel Systems”, Department of Information Systems and Computer Science National University of Singapore, Mar. 1992, pp. 356-373.
Nikkei Electronics, Jul. 19, 1993, pp. 104-105 (Eng. Translation attached of most relevant portion).
T. Asano et al, An Architecture of a High Speed Database Machine: HDM, Information systems and Electronics Development Lab., of Mitsubishi Electric Corporation, Sep. 19, 1989 (89-ARC-78), pp. 1-8.
D. Dewitt, “Query Execution in Direct”, National Science Fundation, Mar. 1979.
Hachem et al “Back End Architecture based on Transformed Inverted Lists, A Surrogate File Structure for a Very Large Data/Knowledge Base” IEEE, pp. 10-19.
Parashar et al, “On Partitioning Dynamic Adaptive Grip Hierarchies” IEEE, pp. 604-613.
Pande et al “Compiling Functional Parallelism on Distributed-Memory Systems”, IEEE, pp. 64-76.
Hua et al, “Dynamic Load Balancing in Multicomputer Database Systems using Partion Tuning” IEEE, pp. 968-983.
K. A. Hus, et al “Data Partitioning for Multicomputer Database Systems: A Cell-Based Approach”, Information Systems, vol. 18, No. 5, pp. 329-542, Jul. 1993.

Affiliated with

Also associated with

Rating

Method and system of database divisional management for... 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 and system of database divisional management for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system of database divisional management for... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4056307