Identifying database request sources in multi-database systems

• US 8,527,473 B1
• Filed: 12/29/2008
• Issued: 09/03/2013
• Est. Priority Date: 10/20/2005
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Brown, Douglas P., Morris, John Mark, Richards, Anita
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Hoffler, Raheem
• Application Number:
  US12/344,991
• Time in Patent Office: 1,709 Days
• Field of Search: None
• US Class Current: 707/682
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Recovering from a failure of a soon-to-fail database system among a plurality of database systems in a multi-database system in processing a request submitted to the multi-database system through a multi-database system session is accomplished. A query band is created for the request. The query band is defined to be an identifier that uniquely identifies the session and the request among the plurality of sessions and plurality of requests being processed by the multi-database system at the time that the request was submitted. The query band is attached to a transaction issued by the multi-database system to the soon-to-fail database system to execute the query. The status concerning execution of the transaction is reported by the soon-to-fail database system. The status includes the query band. The status is logged. The failure of the soon-to-fail database system is detected. The state of the soon-to-fail database system is reconstructed from the logged status as the state related to the processing of the transaction using the query band. The reconstructed state is used to continue processing of the transaction by an alternative database system. The alternative database system is one of the plurality of database systems in the multi-database system. The request is processed to produce a result and the result is stored.

Claims

1. A method for recovering from a failure of a soon-to-fail database system among a plurality of database systems in a multi-database system in processing a request submitted to the multi-database system through a multi-database system session, the method comprising:

creating a query band for the request, the query band being defined to be an identifier that uniquely identifies the session and the request among the plurality of sessions and plurality of requests being processed by the multi-database system at the time that the request was submitted;

attaching the query band to a transaction issued by the multi-database system to the soon-to-fail database system to execute the request;

reporting a status concerning execution of the transaction by the soon-to-fail database system, the status including the query band;

logging the status;

detecting the failure of the soon-to-fail database system;

reconstructing a state of the soon-to-fail database system from the logged status as the state related to the processing of the transaction using the query band;

using the reconstructed state to continue processing of the transaction by an alternative database system, the alternative database system being one of the plurality of database systems in the multi-database system;

processing the request to produce a result; and

storing the result.

2. The method of claim 1 further comprising:

selecting the soon-to-fail database system to perform a transaction required to execute the query, the selection being between the soon-to-fail database system and the alternative database system, the soon-to-fail database system and the alternative database system having the access to data necessary to perform the transaction.

3. The method of claim 1 wherein reporting the status concerning execution of the transaction by the soon-to-fail database system comprises:

reporting the status to a logging subsystem.

4. The method of claim 1 wherein creating the query band for the request comprises deriving an arbitrary string of characters from an identification of the session and an identification of the request.

5. The method of claim 4 wherein deriving the arbitrary string of characters comprises concatenating the identification of the session and the identification of the request.

6. The method of claim 4 wherein deriving the arbitrary string of characters comprises using a hash operation.

7. The method of claim 4 wherein deriving the arbitrary string of characters comprises using the time the request was submitted.

8. A database system, the system comprising:

one or more nodes;

a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;

a plurality of virtual processes, each of the one or more CPUs providing access to one or more virtual processes;

each virtual process configured to manage data, including rows from the set of database table rows, stored in one of a plurality of data-storage facilities;

a process for recovering from a failure of a soon-to-fail database system among a plurality of database systems in a multi-database system in processing a request submitted to the multi-database system through a multi-database system session by;

creating a query band for the request, the query band being defined to be an identifier that uniquely identifies the session and the request among the plurality of sessions and plurality of requests being processed by the multi-database system at the time that the request was submitted;

attaching the query band to a transaction issued by the multi-database system to the soon-to-fail database system to execute the request;

reporting a status concerning execution of the transaction by the soon-to-fail database system, the status including the query band;

logging the status;

detecting the failure of the soon-to-fail database system;

reconstructing a state of the soon-to-fail database system from the logged status as the state related to the processing of the transaction using the query band;

using the reconstructed state to continue processing of the transaction by an alternative database system, the alternative database system being one of the plurality of database systems in the multi-database system;

processing the request to produce a result; and

storing the result.

9. The database system of claim 8 wherein the process further comprises:

selecting the soon-to-fail database system to perform a transaction required to execute the query, the selection being between the soon-to-fail database system and the alternative database system, the soon-to-fail database system and the alternative database system having the access to data necessary to perform the transaction.

10. The database system of claim 8 wherein reporting the status concerning execution of the transaction by the soon-to-fail database system comprises:

reporting the status to a logging subsystem.

11. The database system of claim 8 wherein creating the query band for the request comprises deriving an arbitrary string of characters from an identification of the session and an identification of the request.

12. The database system of claim 11 wherein deriving the arbitrary string of characters comprises concatenating the identification of the session and the identification of the request.

13. The database system of claim 11 wherein deriving the arbitrary string of characters comprises using a hash operation.

14. The database system of claim 11 wherein deriving the arbitrary string of characters comprises using the time the request was submitted.

15. A non-transitory computer-readable storage medium, for recovering from a failure of a soon-to-fail database system among a plurality of database systems in a multi-database system in processing a request submitted to the multi-database system through a multi-database system session, the program comprising executable instructions that cause a computer to:

create a query band for the request, the query band being defined to be an identifier that uniquely identifies the session and the request among the plurality of sessions and plurality of requests being processed by the multi-database system at the time that the request was submitted;

attach the query band to a transaction issued by the multi-database system to the soon-to-fail database system to execute the request;

report a status concerning execution of the transaction by the soon-to-fail database system, the status including the query band;

log the status;

detect the failure of the soon-to-fail database system;

reconstruct a state of the soon-to-fail database system from the logged status as the state related to the processing of the transaction using the query band;

use the reconstructed state to continue processing of the transaction by an alternative database system, the alternative database system being one of the plurality of database systems in the multi-database system;

process the request to produce a result; and

store the result.

16. The non-transitory computer-readable storage medium of claim 15 further comprising executable instructions that cause the computer to:

select the soon-to-fail database system to perform a transaction required to execute the query, the selection being between the soon-to-fail database system and the alternative database system, the soon-to-fail database system and the alternative database system having the access to data necessary to perform the transaction.

17. The non-transitory computer-readable storage medium of claim 15 wherein when reporting the status concerning execution of the transaction by the soon-to-fail database system the computer:

reports the status to a logging subsystem.

18. The non-transitory computer-readable storage medium of claim 15 wherein when creating the query band for the request the computer derives an arbitrary string of characters from an identification of the session and an identification of the request.

19. The non-transitory computer-readable storage medium of claim 18 wherein when deriving the arbitrary string of characters the computer concatenates the identification of the session and the identification of the request.

20. The non-transitory computer-readable storage medium of claim 18 wherein when deriving the arbitrary string of characters the computer uses a hash operation.

21. The non-transitory computer-readable storage medium of claim 18 wherein when deriving the arbitrary string of characters the computer uses the time the request was submitted.