Method and apparatus for concurrent DBMS table operations

A computer readable medium having computer instructions stored thereon that, when loaded into a computer exhibiting a symmetrical multi-processing environment having a plurality of CPU's, cause the computer to reorganize database tables, by performing the steps of:

• launching a number of threads to process said database tables;
• assigning each of said database tables to a different corresponding thread of said threads;
• unloading each respective database table by a process of the corresponding thread, wherein said threads operate on different CPU's in parallel;
• and
• loading said database tables.

An apparatus for reorganizing database tables maintained in a system exhibiting a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• means for launching a number of threads to process said database tables;
• means for assigning each of said database tables to a different corresponding thread of said threads;
• means for unloading each respective database table by a process of the corresponding thread, wherein said threads operate on different CPU's in parallel;
• and
• means for loading said database tables.

An apparatus for reorganizing database tables in a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• a launching device configured to initiate a number of threads to process said database tables;
• an assignor configured to assign each of said database tables to a different corresponding thread of said threads launched;
• an unloader installed on each corresponding thread, each respective unloader configured to unload each of said database tables by a process of said corresponding thread of said unloader, wherein said threads operate on different CPU's in parallel;
• and
• a loader configured to load said database tables.

A method for reorganizing database tables residing on different storage devices in a symmetrical multi-processing environment having a plurality of CPU's, at least one of said tables residing on a plurality of storage devices, comprising the steps of:

• launching a number of threads to process said database tables;
• assigning each respective portion of said database tables residing on a different storage device to a different corresponding thread of said threads;
• unloading each respective portion of said database tables by a process of said corresponding thread, wherein said threads operate on different CPU's in parallel;
• and
• loading said database tables.

A computer readable medium having computer instructions stored thereon that, when loaded into a computer exhibiting a symmetrical multi-processing environment having a plurality of CPU's, cause the computer to reorganize database tables residing on different storage devices, at least one of said tables residing on a plurality of storage devices, by performing the steps of:

• launching a number of threads to process said database tables;
• assigning each respective portion of said database tables residing on a different storage device to a different corresponding thread of said threads;
• unloading each respective portion of said database tables by a process of the corresponding thread, wherein said threads operate on different CPU's in parallel;
• and
• loading said database tables.

An apparatus for reorganizing database tables residing on different storage devices maintained in a system exhibiting a symmetrical multi-processing environment having a plurality of CPU's, at least one of said tables residing on a plurality of storage devices, comprising:

• means for launching a number of threads to process said database tables;
• means for assigning each respective portion of said database tables residing on a different storage device to a different corresponding thread of said threads;
• means for unloading each respective portion of said database tables by a process of the corresponding thread, wherein said threads operate on different CPU's in parallel;
• and
• means for loading said database tables.

An apparatus for reorganizing database tables residing on different storage devices in a symmetrical multi-processing environment having a plurality of CPU's, at least one of said tables residing on a plurality of storage devices, comprising:

• a launching device configured to initiate a number of threads to process said database tables;
• an assignor configured to assign each respective portion of said database tables residing on a different storage device to a different corresponding thread of said threads launched;
• an unloader installed on each corresponding thread, each respective unloader configured to unload each respective portion of said database tables by a process of said corresponding thread of the unloader, wherein said threads operate on different CPU's in parallel;
• and
• a loader configured to load said database tables.

A method for reorganizing database tables in a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• launching a first set of threads to unload said database tables;
• assigning each of said database tables to a different corresponding thread of said first set of threads;
• unloading each of said database tables to a separate export directory by a process of said corresponding thread, said first set of threads operate in parallel on a first set of CPU's, said database tables assigned to said export directories using a best fit method, said assignment performed by a reorganization utility running on a CPU separate from said first set of CPU's;
• creating temporary database tables;
• launching a second set of threads to load said temporary database tables;
• and
• loading each of said temporary database tables with data from at least one of said export directories, each of said temporary database tables loaded by a separate thread of said second set of threads, said second set of threads operate in parallel on a second set of CPU's, said data loaded using a best fit method.

A computer readable medium having computer instructions stored thereon that, when loaded into a computer exhibiting a symmetrical multi-processing environment having a plurality of CPU's, cause the computer to reorganize database tables by performing the steps of:

• launching a first set of threads to unload said database tables;
• assigning each of said database tables to a different corresponding thread of said first set of threads;
• unloading each of said database tables to a separate export directory by a process of said corresponding thread, said first set of threads operate in parallel on a first set of CPU's, said database tables assigned to said export directories using a best fit method, said assignment performed by a reorganization utility running on a CPU separate from said first set of CPU's;
• creating temporary database tables;
• launching a second set of threads to load said temporary database tables;
• and
• loading each of said temporary database tables with data from at least one of said export directories, each of said temporary database tables loaded by a separate thread of said second set of threads, said second set of threads operate in parallel on a second set of CPU's, said data loaded using a best fit method.

An apparatus for reorganizing database tables maintained in a system exhibiting a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• means for launching a first set of threads to unload said database tables;
• means for assigning each of said database tables to a different corresponding thread of said first set of threads;
• means for unloading each of said database tables to a separate export directory by a process of said corresponding thread, said first set of threads operate in parallel on a first set of CPU's, said database tables assigned to said export directories using a best fit method, said assignment performed by a reorganization utility running on a CPU separate from said first set of CPU's;
• means for creating temporary database tables;
• means for launching a second set of threads to load said temporary database tables;
• and
• means for loading each of said temporary database tables with data from at least one of said export directories, each of said temporary database tables loaded by a separate thread of said second set of threads, said second set of threads operate in parallel on a second set of CPU's, said data loaded using a best fit method.

An apparatus for reorganizing database tables in a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• a first launching device configured to initiate a first set of threads to unload said database tables;
• an assignor configured to assign each of said database tables to a different corresponding thread of said first set of threads launched;
• an unloader installed on each thread of said first set of threads, each unloader configured to unload at least one of said database tables to a separate export directory by a process of said corresponding thread of said unloader, said first set of threads operate in parallel on a first set of CPU's, said database tables assigned to said export directories using a best fit method, said assignment performed by a reorganization utility running on a CPU separate from said first set of CPU's;
• a table allocation device configured to create temporary database tables;
• a second launching device configured to initiate a second set of threads to load said temporary database tables;
• and
• a loader installed on each thread of said second set of threads, each loader configured to load at least one of said temporary database tables with data from at least one of said export directories, each of said temporary database tables loaded by a process of said corresponding thread of said loader, said second set of threads operate in parallel on a second set of CPU's, said loaders using a best fit method.

A machine-implemented method for reorganizing database tables in a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• launching a plurality of threads;
• assigning each of said threads to a database table;
• unloading said tables concurrently, wherein data of each table is unloaded to an export directory by a process of said thread assigned to said table;
• creating new tables;
• and
• loading said new tables concurrently, wherein data of said export directories is loaded to said new tables by a process of said thread assigned to said table.

A machine-implemented method for reorganizing database tables in a symmetrical multi-processing environment having a plurality of CPU's, comprising:

• launching a plurality of threads;
• assigning each of said threads to a database table;
• unloading said tables concurrently, wherein data of each table is unloaded to an export directory by a process of said thread assigned to said table;
• and
• creating new tables.