Systems and methods for data source management

• US 8,255,504 B1
• Filed: 10/03/2006
• Issued: 08/28/2012
• Est. Priority Date: 10/03/2006
• Status: Active Grant

• Current Assignee: United Services Automobile Association
• Original Assignee: United States Automobile Association (United Services Automobile Association)
• Inventors: Kaewlium, Anantrachai, Lutz, James, Thornton, Shannon
• Primary Examiner(s): Dwivedi, Mahesh
• Application Number:
  US11/538,430
• Time in Patent Office: 2,156 Days
• Field of Search: 707100-1041, 707/102, 707/782, 707/610, 705/3.39, 345/473, 709/223, 709/224, 719/328
• US Class Current: 709/223
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Systems and methods for data source management using custom data sources are described. The system includes a custom data source created in response to a data source request, and a number of configuration modules to handle obtaining a connection with a data source. Other embodiments are also described.

Claims

1. A system comprising:

a processor and a memory;

a server executed by the processor and deployed within the memory to detect a data source lookup request from a requestor for a first data source; and

a custom data source generated dynamically and deployed within the memory to transmit by the processor a lookup request response to the data source lookup request from the custom data source, the custom data source being separate from the server and having a preset configuration defining connectivity acceptance for the first data source and a number of alternate data sources, and receive a custom data source connection request,

wherein the system is configured to;

determine by the processor whether the first data source is available for a first data source connection based on whether the first data source is open for a new connection and based on the preset configuration and the custom data source connection request, wherein the preset configuration includes load balancing, fail over, throttle management, and combinations thereof,

determine by the processor whether one of the number of alternate data sources is available for a second data source connection by iteratively searching the number of alternate data sources for an available one of the number of alternate data sources, wherein the determination whether one of the number of alternate data sources is available for the second data source connection is based on the preset configuration and the customer data source connection request,

when the first data source is determined to be available for the first data source connection, establish by the processor the first data source connection between the custom data source and the first data source in response to receiving the custom data source connection request, manage the connection using the custom data source, and close the connection using the custom data source; and

when the first data source is determined to be unavailable for first data source connection and one of the number of alternate data sources is determined to be available for the second data source connection, establish by the computer processor the one of the number of alternate data sources connection between the custom data source and the second data source in response to the receiving of the custom data source connection request, manage the connection using the custom data source, and close the connection using the custom data source.

4. The system of claim 1, wherein determination of whether one of the number of alternate data sources is available is performed when the first data source is determined to be unavailable.

5. The system of claim 1, wherein the custom data source further generates the custom data source based on the data source lookup request,

wherein transmitting the lookup request response is based on generation of the custom data source.

6. The system of claim 5, wherein generation of the custom data source comprises:

generating the custom data source based on the data source lookup request and an identity of the requestor.

2. A method comprising:

detecting by a server a data source lookup request from a requestor for a first data source;

transmitting by a computer processor a lookup request response to the data source lookup request from a dynamically generated custom data source, the custom data source being separate from the server and having a preset configuration defining connectivity acceptance for the first data source and a number of alternate data sources;

receiving a custom data source connection request on the custom data source;

determining on the custom data source by the computer processor whether the first data source is available for a first data source connection based on whether the first data source is open for a new connection and based on the preset configuration and the custom data source connection request, wherein the preset configuration includes load balancing, fail over, throttle management, and combinations thereof;

determining on the custom data source by the computer processor whether one of the number of alternate data sources is available for a second data source connection by iteratively searching the number of alternate data sources for an available one of the number of alternate data sources, wherein the determination whether one of the number of alternate data sources is available for the second data source connection is based on the preset configuration and the customer data source connection request;

when the first data source is determined to be available for the first data source connection, establishing by the computer processor the first data source connection between the custom data source and the first data source in response to the receiving of the custom data source connection request, managing the connection using the custom data source, and closing the connection using the custom data source; and

when the first data source is determined to be unavailable for first data source connection and one of the number of alternate data sources is determined to be available for the second data source connection, establishing on the custom data source by the computer processor the second data source connection between the custom data source and the one of the number of alternate data sources in response to the receiving of the custom data source connection request, managing the connection using the custom data source, and closing the connection using the custom data source.

7. The method of claim 2, wherein the determining of whether one of the number of alternate data sources is available is performed when the first data source is determined to be unavailable.

8. The method of claim 2, further comprising:

generating the custom data source based on the data source lookup request,

wherein the transmitting of the lookup request response is based on the generating of the custom data source.

9. The method of claim 8, wherein the generating of the custom data source comprises:

generating the custom data source based on the data source lookup request and an identity of the requestor.

3. An article including a machine-accessible medium having associated information, wherein the information results in a machine performing a method comprising:

detecting by a server a data source lookup request from a requestor for a first data source;

transmitting a lookup request response to the data source lookup request from a dynamically generated custom data source, the custom data source being separate from the server and having a preset configuration defining connectivity acceptance for the first data source and a number of alternate data sources;

receiving a custom data source connection request on the custom data source;

determining on the custom data source whether the first data source is available for a first data source connection based on whether the first data source is open for a new connection and based on the preset configuration and the custom data source connection request, wherein the preset configuration includes load balancing, fail over, throttle management, and combinations thereof;

determining on the custom data source whether one of the number of alternate data sources is available for a second data source connection by iteratively searching the number of alternate data sources for an available one of the number of alternate data sources, wherein the determination whether one of the number of alternate data sources is available for the second data source connection is based on the preset configuration and the customer data source connection request;

when the first data source is determined to be available for the first data source connection, establishing the first data source connection between the custom data source and the first data source in response to the receiving of the custom data source connection request, managing the connection using the custom data source, and closing the connection using the custom data source; and

when the first data source is determined to be unavailable for first data source connection and one of the number of alternate data sources is determined to be available for the second data source connection, establishing on the custom data source by the computer processor the second data source connection between the custom data source and the one of the number of alternate data sources in response to the receiving of the custom data source connection request, managing the connection using the custom data source, and closing the connection using the custom data source.

10. The article of claim 3, wherein the determining of whether one of the number of alternate data sources is available is performed when the first data source is determined to be unavailable.

11. The article of claim 3, further comprising:

generating the custom data source based on the data source lookup request,

wherein the transmitting of the lookup request response is based on the generating of the custom data source.

12. The article of claim 11 wherein the generating of the custom data source comprises:

generating the custom data source based on the data source lookup request and an identity of the requestor.