Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system

Claim 2

A multi-node relational database management system for managing a database comprising: a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; and a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 3

The multi-node relational database management system of claim 1 wherein said coordinator node maintains for said application a list of said declared temporary tables being dropped.

Claim 4

The multi-node relational database management system of claim 1 wherein said coordinator node maintains for said application a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed.

Claim 5

The multi-node relational database management system of claim 1 wherein said coordinator node maintains for said application a transaction node list indicating identification of those nodes involved in a current transaction.

Claim 6

The multi-node relational database management system of claim 1 wherein said coordinator node maintains for said applications an application node list for indicating identification of all nodes that have participated in execution of said application.

Claim 7

The multi-node relational database management system of claim 1 wherein the said declared temporary table manager causes said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 8

The multi-node relational database management system of claim 1 wherein a node failure list is provided for identifying nodes that have failed.

Claim 9

The multi-node relational database management system of claim 1 wherein the declared temporary table manager also causes: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and; an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 10

The multi-node relational database management system of claim 1 wherein said coordinator node for an application is located at said catalog node; and wherein said at least one subordinate node for an application can be at any node except said application's coordinator node.

Claim 11

The multi-node relational database management system of claim 8 wherein said coordinator node for an application is located at said catalog node; and wherein said at least one subordinate node for an application can be at any node except said application's coordinator node.

Claim 12

A computer readable storage medium comprising program instructions for establishing a multi-node relational database management system for managing a database comprising, the program instructions for: establishing a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; establishing a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; and establishing a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 13

A computer readable storage medium comprising program instructions for establishing a multi-node relational database management system for managing a database comprising, the program instructions for: establishing a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; establishing a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; and establishing a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 14

The computer readable medium of claim 11 wherein said coordinator node maintains for said application a list of said declared temporary tables being dropped.

Claim 15

The computer readable medium of claim 11 wherein said coordinator node maintains for said application a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed.

Claim 16

The computer readable medium of claim 11 wherein said coordinator node maintains for said application a transaction node list indicating identification of those nodes involved in a current transaction.

Claim 17

The computer readable medium of claim 11 wherein said coordinator node maintains for said applications an application node list for indicating identification of all nodes that have participated in execution of said application.

Claim 18

The computer readable medium of claim 11 wherein the said declared temporary manager causes said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 19

The computer readable medium of claim 11 wherein a node failure list is provided for identifying nodes that have failed.

Claim 20

The computer readable medium of claim 11 wherein the declared temporary table manager also causes (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and, an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 21

The computer readable medium of claim 11 wherein said coordinator node for an application is located at said catalog node; and wherein said at least one subordinate node for an application can be at any node except said application's coordinator node.

Claim 22

A computer readable storage medium comprising program instructions to establish a multi-node relational database management system for managing a database, the program instructions for: establishing a node failure list identifying nodes that have failed; establishing a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; establishing a coordinator node for an said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables being dropped; a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed; a transaction node list indicating identification of those nodes involved in a current transaction; and an application node list for indicating identification of all nodes that have participated in execution of said application; and; (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 23

A computer readable storage medium comprising program instructions to establish a multi-node relational database management system for managing a database, the program instructions for: establishing a node failure list identifying nodes that have failed; establishing a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; establishing a coordinator node for an said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables being dropped; a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed; a transaction node list indicating identification of those nodes involved in a current transaction; and an application node list for indicating identification of all nodes that have participated in execution of said application; and; (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 24

The computer readable storage medium of claim 20 further comprising program instructions for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and, an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup.

Claim 25

In a multi-node relational database management system a method for managing a database, the method comprising the steps of: (a) using a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; (b) associating a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; (c) using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; and (d) using a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 26

In a multi-node relational database management system a method for managing a database, the method comprising the steps of: (a) using a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; (b) associating a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; (c) using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables; and (d) using a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 27

The method of claim 22 wherein the declared temporary table manager is used for managing said declared temporary tables for causing: a transaction node list indicating identification of those nodes involved in a current transaction; an application node list for indicating identification of all nodes that have participated in execution of said application; and wherein said subordinate node for said application is used to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 28

The method of claim 22 wherein said declared temporary table manager is used for managing said declared temporary tables for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 29

A multi-node relational database management system for managing a database, the system comprising: a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; at least one partition of said declared temporary tables on said coordinator node; and a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 30

A multi-node relational database management system for managing a database, the system comprising: a catalog node for reserving identifiers for declared temporary tables associated with an application, wherein the catalog node maintains a list of said reserved identifiers; a coordinator node for said application, wherein said coordinator node receives said reserved identifiers from said catalog node, and wherein said coordinator node maintains a list of said declared temporary tables; at least one partition of said declared temporary tables on said coordinator node; and a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 31

A computer readable storage medium comprising program instructions to establish a multi-node relational database management system for managing a database having declared temporary tables associated with respective applications, the program instructions for: establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; establishing a coordinator node for an application; establishing at least one partition of said declared temporary tables of said application on said coordinator node; and program instructions for establishing a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 32

A computer readable storage medium comprising program instructions to establish a multi-node relational database management system for managing a database having declared temporary tables associated with respective applications, the program instructions for: establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; establishing a coordinator node for an application; establishing at least one partition of said declared temporary tables of said application on said coordinator node; and program instructions for establishing a declared temporary table manager for causing said coordinator node to maintain said list of said declared temporary tables.

Claim 35

A multi-node relational database management system for managing a database, the system comprising: a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein the declared temporary table manager also causes: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 36

A multi-node relational database management system for managing a database, the system comprising: a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein the declared temporary table manager also causes: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 37

A multi-node relational database management system for managing a database comprising: a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application, wherein said coordinator node for an application is located at said catalog node; and wherein said at least one subordinate node for an application can be at any node except said application's coordinator node; and a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein the declared temporary table manager also causes: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 38

A multi-node relational database management system for managing a database comprising: a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application, wherein said coordinator node for an application is located at said catalog node; and wherein said at least one subordinate node for an application can be at any node except said application's coordinator node; and a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein the declared temporary table manager also causes: (a) said coordinator node to maintain for said application: a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 39

A computer readable storage medium containing program instructions to establish a multi-node relational database management system for managing a database comprising: establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; establishing a coordinator node for an application; program instructions for establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and, establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 40

A computer readable storage medium containing program instructions to establish a multi-node relational database management system for managing a database comprising: establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; establishing a coordinator node for an application; program instructions for establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and, establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 41

A computer readable storage medium for containing program instructions to establish a multi-node relational database management system for managing a database comprising: a node failure list identifying nodes that have failed; program instructions for establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; program instructions for establishing a coordinator node for an application; program instructions for establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; program instructions for establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; an application node list for indicating identification of all nodes that have participated in execution of said application; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 42

A computer readable storage medium for containing program instructions to establish a multi-node relational database management system for managing a database comprising: a node failure list identifying nodes that have failed; program instructions for establishing a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; program instructions for establishing a coordinator node for an application; program instructions for establishing at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; program instructions for establishing a declared temporary table manager for causing: (a) said coordinator node to maintain for said application: a list of said declared temporary tables; a list of said declared temporary tables for tracking said temporary tables; a list of said declared temporary tables being dropped; a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; a list of action entries indicating identification of tables on which actions are to be performed, and actions to be performed; a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; a transaction node list indicating identification of those nodes involved in a current transaction; a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; an application node list for indicating identification of all nodes that have participated in execution of said application; and an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 43

In a multi-node relational database management system a method for managing a database comprising: using a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; associating a coordinator node for an application; using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and using a declared temporary table manager for causing: (a) said coordinator node to maintain for said application a list of said declared temporary tables; wherein the declared temporary table manager is used for managing said declared temporary tables for causing: a transaction node list indicating identification of those nodes involved in a current transaction; and an application node list for indicating identification of all nodes that have participated in execution of said application; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 44

In a multi-node relational database management system a method for managing a database comprising: using a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; associating a coordinator node for an application; using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; and using a declared temporary table manager for causing: (a) said coordinator node to maintain for said application a list of said declared temporary tables; wherein the declared temporary table manager is used for managing said declared temporary tables for causing: a transaction node list indicating identification of those nodes involved in a current transaction; and an application node list for indicating identification of all nodes that have participated in execution of said application; and (b) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node.

Claim 45

In a multi-node relational database management system a method for managing a database, the method comprising the steps of: (a) using a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; (b) associating a coordinator node for an application; (c) using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; (d) using a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein said declared temporary table manager is used for managing said declared temporary tables for causing: (d1) said coordinator node to maintain for said application: (d1i) a list of said declared temporary tables for tracking said temporary tables; (d1ii) a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; (d1iii) a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; (d1iv) a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and (d1v) an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (d2) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.

Claim 46

In a multi-node relational database management system a method for managing a database, the method comprising the steps of: (a) using a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; (b) associating a coordinator node for an application; (c) using at least one subordinate node for said application, said subordinate node having at least one partition of said declared temporary tables of said application; (d) using a declared temporary table manager for causing said coordinator node to maintain for said application a list of said declared temporary tables, wherein said declared temporary table manager is used for managing said declared temporary tables for causing: (d1) said coordinator node to maintain for said application: (d1i) a list of said declared temporary tables for tracking said temporary tables; (d1ii) a list of said declared temporary tables being dropped containing information to be sent to said catalog node to inform it of declared temporary tables being dropped so said catalog node can release the identification of said declared temporary tables being dropped or add said identification to its deferred drop list to release said identification when execution of said application ends; (d1iii) a list of action entries indicating identification of tables on which actions are to be performed, and any actions to be performed to be used to inform subordinate nodes to maintain their partitions of said declared temporary tables in synchronization; (d1iv) a transaction node list indicating identification of those nodes involved in a current transaction to inform the subordinate nodes involved in said current transaction to appropriately end a transaction as required for rollback or commit; and (d1v) an application node list for indicating identification of all nodes that have participated in execution of the application, to identify all subordinate nodes participating in the application so that they can perform node specific application termination processing including cleanup; and (d2) said subordinate node for said application to maintain a list of said declared temporary tables that are partitioned at said subordinate node for synchronization.