Patent US5758345A successfully refreshed from Google Patents.
US5758345A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Program and method for establishing a physical database layout on a distributed processor system
Assignee: International Business Machines Corp
•
Filing: 1995-11-08
•
Granted: 1998-05-26
•
Expires: 2015-11-08
Abstract
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.
Inventors
- 👤 James Chien Wang
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 15:35
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 34
Claim 1
Independent Claim
237 words
A method for establishing a physical database layout for use with a distributed processor system, the method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into a logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; selecting the nodes on which the tablespaces are going to be assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map.
Claim 2
Independent Claim
237 words
A method for establishing a physical database layout for use with a distributed processor system, the method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into a logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; selecting the nodes on which the tablespaces are going to be assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map.
Claim 3
Dependent Claim
24 words
The method of claim 1 wherein the selecting of nodes comprises spreading said tablespaces evenly across all of the nodes in said first datafile.
Claim 4
Dependent Claim
23 words
The method of claim 1 wherein the selecting of nodes comprises assigning each node in said first datafile with its own unique tablespace.
Claim 5
Dependent Claim
27 words
The method of claim 1 wherein the selecting of nodes comprises selecting a subset of nodes from the first datafile to be used with a designated tablespace.
Claim 6
Dependent Claim
29 words
The method of claim 1 wherein the EASY DESIGN phase includes striping a very large tablespace wherein the very large tablespace is evenly spread out over the selected nodes.
Claim 7
Dependent Claim
24 words
The method of claim 1 wherein the EASY DESIGN phase includes allocating the logical volumes in accordance with a logical volume allocation (LVM) policy.
Claim 8
Dependent Claim
20 words
The method of claim 6 wherein the LVM allocation policy allocates the logical volume across a designated set of disks.
Claim 9
Dependent Claim
21 words
The method of claim 6 wherein the LVM allocation policy allocates the logical volume across all available disks in a node.
Claim 10
Dependent Claim
17 words
The method of claim 6 wherein the LVM allocation policy allocates the logical volume on one disk.
Claim 11
Dependent Claim
29 words
The method of claim 1 further comprising designating whether the tablespaces are to be spread among the nodes in either a round robin fashion or a range partition fashion.
Claim 12
Dependent Claim
41 words
The method of claim 1 further comprising designating whether each tablespace is to be a read based or a write based tablespace, and wherein said DETAIL DESIGN phase assigns distributed lock manager locks for each tablespace designated as a write tablespace.
Claim 13
Dependent Claim
38 words
The method of claim 1 further comprising designating a size for the initial and next extents of a desired tablespace, and further comprises spreading the desired tablespace across disks dependent on the designated initial and next extent sizes.
Claim 14
Dependent Claim
76 words
The method of claim 1 wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively.
Claim 15
Dependent Claim
31 words
The method of claim 1 wherein said EASY DESIGN phase creates a disk report including disk capacity, disk space allocated and disk space available for every node in said first datafile.
Claim 16
Independent Claim
372 words
A method for implementing a physical database layout for use with a distributed processor system, the method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into a logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map; and designating a size for the initial and next extents of a desired tablespace, and spreading the desired tablespace across disks dependent on the designated initial and next extent sizes; wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively, and wherein said application layer is an Oracle layer, said parallel operating layer is a PSSP and VSD layer, and said node operating system layer is an AIX layer, and said DETAIL DESIGN layer generates AIX command scripts, VSD scripts, and Oracle scripts, in that order.
Claim 17
Independent Claim
372 words
A method for implementing a physical database layout for use with a distributed processor system, the method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into a logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map; and designating a size for the initial and next extents of a desired tablespace, and spreading the desired tablespace across disks dependent on the designated initial and next extent sizes; wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively, and wherein said application layer is an Oracle layer, said parallel operating layer is a PSSP and VSD layer, and said node operating system layer is an AIX layer, and said DETAIL DESIGN layer generates AIX command scripts, VSD scripts, and Oracle scripts, in that order.
Claim 18
Dependent Claim
248 words
A program recorded on a computer readable medium, said program for establishing a physical database layout for use with a distributed processor system by a method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into at least one logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; selecting the nodes on which the tablespaces are going to be assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map.
Claim 19
Dependent Claim
248 words
A program recorded on a computer readable medium, said program for establishing a physical database layout for use with a distributed processor system by a method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into at least one logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; selecting the nodes on which the tablespaces are going to be assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map.
Claim 20
Dependent Claim
24 words
The program of claim 16 wherein the selecting of nodes comprises spreading said tablespaces evenly across all of the nodes in said first datafile.
Claim 21
Dependent Claim
23 words
The program of claim 16 wherein the selecting of nodes comprises assigning each node in said first datafile with its own unique tablespace.
Claim 22
Dependent Claim
27 words
The program of claim 16 wherein the selecting of nodes comprises selecting a subset of nodes from the first datafile to be used with a designated tablespace.
Claim 23
Dependent Claim
29 words
The program of claim 16 wherein the EASY DESIGN phase includes striping a very large tablespace wherein the very large tablespace is evenly spread out over the selected nodes.
Claim 24
Dependent Claim
24 words
The program of claim 16 wherein the EASY DESIGN phase includes allocating the logical volumes in accordance with a logical volume allocation (LVM) policy.
Claim 25
Dependent Claim
20 words
The program of claim 21 wherein the LVM allocation policy allocates the logical volume across a designated set of disks.
Claim 26
Dependent Claim
21 words
The program of claim 21 wherein the LVM allocation policy allocates the logical volume across all available disks in a node.
Claim 27
Dependent Claim
17 words
The program of claim 21 wherein the LVM allocation policy allocates the logical volume on one disk.
Claim 28
Dependent Claim
29 words
The program of claim 16 further comprising designating whether the tablespaces are to be spread among the nodes in either a round robin fashion or a range partition fashion.
Claim 29
Dependent Claim
42 words
The program of claim 16 further comprising designating whether each tablespace is to be a read based or a write based tablespace, and wherein said DETAIL DESIGN phase assign distributed lock manager locks for each tablespace designated as a write based tablespace.
Claim 30
Dependent Claim
38 words
The program of claim 16 further comprising designating a size for the initial and next extents of a desired tablespace, and further comprises spreading the desired tablespace across disks dependent on the designated initial and next extent sizes.
Claim 31
Dependent Claim
76 words
The program of claim 16 wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively.
Claim 32
Dependent Claim
354 words
A program recorded on a computer readable medium, said program for implementing a physical database layout for use with a distributed processor system by a method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into at least one logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map; and wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively, and wherein said application layer is an Oracle layer, said parallel operating layer is a PSSP and VSD layer, and said node operating system layer is an AIX layer, and said DETAIL DESIGN layer generates AIX command scripts, VSD scripts, and Oracle scripts, in that order.
Claim 33
Dependent Claim
354 words
A program recorded on a computer readable medium, said program for implementing a physical database layout for use with a distributed processor system by a method comprising the steps of: inputting a first datafile representing the physical configuration of the distributed processor system; inputting a second datafile representing tablespaces to be stored in the distributed processor, said second datafile including a name and size of each tablespace in said second datafile; determining from said first datafile the number of nodes available in the distributed processor system, the number of disks per available node, and the size of each of the disks in the distributed processor system; performing a PROGRAM DESIGN phase for automatically allocating the tablespaces to the nodes and disks in the nodes determined to be available and updating the second datafile with the allocations; providing for the modification of the allocation of the tablespaces in said second datafile by a user; performing an EASY DESIGN phase for automatically assigning each tablespace into at least one logical volume in disk space of the disks in the distributed processor system, and generating therefrom a logical volume map including an indication of the node, disk, volume group and size of the tablespaces thus assigned; providing for the modification of the logical volume map by a user; and performing a DETAIL DESIGN phase for automatically generating scripts for implementing the physical database layout from said logical volume map; and wherein said distributed processor system has layers of software for operating said distributed processor system, said layers including an application layer for implementing a database, a parallel operating layer for operating the distributed processor system in a parallel fashion, and a node operating system layer for operating each node, said DETAIL DESIGN phase for generating scripts for the node operating system layer, the parallel operating layer, and the application layer, respectively, and wherein said application layer is an Oracle layer, said parallel operating layer is a PSSP and VSD layer, and said node operating system layer is an AIX layer, and said DETAIL DESIGN layer generates AIX command scripts, VSD scripts, and Oracle scripts, in that order.
Claim 34
Dependent Claim
31 words
The program of claim 16 wherein said EASY DESIGN phase creates a disk report including disk capacity, disk space allocated and disk space available for every node in said first datafile.
References Cited (Backward Citations)
US4887204A
Cited
US5129088A
Cited
US5121494A
Cited
US5179702A
Cited
US5237691A
Cited
US5249270A
Cited
US5216592A
Cited
US5448727A
Cited
US5551027A
Cited
US5437032A
Cited
JPH08137910A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-05-25 | 2001-11-24 | 2002-05-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-05-25 | 2005-11-24 | 2006-05-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-05-25 | 2009-11-24 | 2010-05-26 | $7700.00 | Window Closed / Lapsed |