Systems and methods for data source management

• US 9,015,305 B1
• Filed: 08/28/2012
• Issued: 04/21/2015
• Est. Priority Date: 10/03/2006
• Status: Active Grant

• Current Assignee: United Services Automobile Association
• Original Assignee: United Services Automobile Association
• Inventors: Thornton, Shannon, Kaewlium, Anantrachai, Lutz, James
• Primary Examiner(s): DWIVEDI, MAHESH H
• Application Number:
  US13/596,665
• Time in Patent Office: 966 Days
• Field of Search: 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;

a lookup module containing a listing of data sources that the server is in communication and using the processor to determine whether the first data source is in the listing;

a factory for dynamically generating, in response to determining the first data source is in the listing, a custom data source separate from the server and configured with modules to manage a connection between the custom data source and the first data source and a number of alternate data sources, the modules including load balancing, fail over, and throttle management; and

a connection module for connecting the requestor with the first data source when the first data source is determined to be available, and for connecting to one of the number of alternate data sources when the first data source is unavailable.

2. The system of claim 1, wherein the system is configured to, 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.

3. The system of claim 1, wherein the system is configured to 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 customer data source connection request.

4. The system of claim 3, wherein the system is configured to, when one of the number of alternate data sources is determined to be available for the second data source connection, establish by the 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.

5. The system of claim 1, wherein the custom data source is generated dynamically based on the data source lookup request.