Data processing: database and file management or data structures – Database design – Data structure types
Patent
1995-11-08
1998-05-26
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707200, 707206, 395401, 395405, 395800, G06F 1730
Patent
active
057583455
ABSTRACT:
A method and program for use with a massively parallel processor (MPP) system or a distributed computer system for providing a physical design layout database across several nodes of the system. A user inputs a first datafile representing the physical configuration of the distributed processor system, and inputs a second datafile representing application tablespaces and/or database system files to be stored in the distributed processor system. The program optionally assigns the tablespaces in the second datafile to the physical configuration of the distributed processor system as specified in the first datafile and per the number of nodes, number of disks per node, and the size of the disks. The user may optionally use the physical design layout of the program, may change a portion of the intermediate physical design layout, or may provide the entire physical database design layout, as desired. The program generates a logical volume map for the tablespaces distributed over the distributed processor system, and further generates scripts to implement the tablespace structure into a physical database.
REFERENCES:
patent: 4887204 (1989-12-01), Johnson et al.
patent: 5121494 (1992-06-01), Dias et al.
patent: 5129088 (1992-07-01), Auslander et al.
patent: 5179702 (1993-01-01), Spix et al.
patent: 5216592 (1993-06-01), Mann et al.
patent: 5237691 (1993-08-01), Robinson et al.
patent: 5249270 (1993-09-01), Stewart et al.
patent: 5437032 (1995-07-01), Wolf et al.
patent: 5448727 (1995-09-01), Annevelink
patent: 5551027 (1996-08-01), Choy et al.
Lu et al. "Dynamic and Load-balanced Task-Oriented Database query Processing in Parallel Systems" pp. 357-372, Jan. 1992.
SUN "SPARCstorage Array User's Guide" pp. 1-1-2-13, May 1994.
Stamos et al. "A Symmetric fragment and replicate algorithm for distributed" IEEE vol. 4 pp. 1345-1354, Dec. 1993.
Hua et al. "Dynamic load balancing in very large sharednothing hypercub" vol. 42, pp. 1425-1439, Dec. 1993.
Wolf et al. "A parallel hash join algorithm for managing data shew" IEEE vol. 4 No. 12 pp. 1355-1371, Dec. 1993.
Wolf et al. "A parallel sort merge join algorithm for managing data skew" IEEE vol. 4 No. 1 pp. 70-86, Jan. 1993.
Dewwit et al. "The future of high performance database systems" ACM vol. 35, No. 6 pp. 85-97, Jun. 1992.
Wolf et al. "An Effective Algorithm for Parallelizing Sort Merge joins in the Presence of Data Skew" IEEE, pp. 103-115, Jan. 1990.
"Automating Database Implementation", G. E. Bryans, IBM Technical Disclosure Bulletin, vol. 38, No. 4, Apr. 1995, pp. 265-266.
Black Thomas G.
Corrielus Jean M.
Gonzalez Floyd A.
International Business Machines - Corporation
LandOfFree
Program and method for establishing a physical database layout o does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Program and method for establishing a physical database layout o, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Program and method for establishing a physical database layout o will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1978774