Abstract database query

• US 8,812,472 B2
• Filed: 05/09/2013
• Issued: 08/19/2014
• Est. Priority Date: 12/16/2009
• Status: Active Grant

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Schade, Adam
• Primary Examiner(s): THAI, HANH B
• Application Number:
  US13/890,650
• Publication Number:
  US 20130246459A1
• Time in Patent Office: 467 Days
• Field of Search: 707/705, 707/790, 707/802
• US Class Current: 707/705
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]

Abstract

Systems, apparatuses, methods, and media for configuring a terminal to access a database are provided. The systems, apparatuses, methods, and media determine connection properties of the database. The database is accessible via a uniform resource locator string. One of a plurality of database connectivity drivers that enables a connection with the database is determined based on the connection properties of the database. The one of the plurality of database connectivity drivers is provided to the terminal via a network. The one of the plurality of database connectivity drivers comprises the uniform resource locator string and is configured to establish the connection with the database via the network based on the uniform resource locator string to enable communication between the terminal and the database.

Claims

1. A system for configuring a terminal to access a database, the system comprising:

a processor; and

a memory storing instructions that, when executed by the processor, cause the processor to perform operations including;

determining connection properties of the database, the database being accessible via a uniform resource locator string;

determining, based on the connection properties of the database and from a plurality of database connectivity drivers, one of the plurality of database connectivity drivers that enables a connection with the database; and

providing the one of the plurality of database connectivity drivers to the terminal via a network,

wherein the one of the plurality of database connectivity drivers comprises the uniform resource locator string and is configured to establish the connection with the database via the network based on the uniform resource locator string to enable communication between the terminal and the database.

2. The system according to claim 1, wherein the instructions, when executed by the processor, cause the processor to further perform:

loading the one of the plurality of database connectivity drivers on the terminal for establishing the connection between the terminal and the database.

3. The system according to claim 2, wherein the uniform resource locator is pre-encoded in the one of the plurality of database connectivity drivers for establishing the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

4. The system according to claim 1, wherein the one of the plurality of database connectivity drivers is configured to establish the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

5. The system according to claim 1, wherein the uniform resource locator is stored in the one of the plurality of database connectivity drivers.

6. The system according to claim 1, wherein the uniform resource locator is stored in the memory.

7. The system according to claim 1, wherein each of the plurality of database connectivity drivers is stored in the memory.

8. The system according to claim 7, wherein

the plurality of database connectivity drivers is aggregated into a single file in the memory, the single file having an archive file format, and

the instructions, when executed by the processor, cause the processor to further perform:

extracting the one of the plurality of database connectivity drivers from the single file before providing the one of the plurality of database connectivity drivers to the terminal via the network.

9. The system according to claim 1, wherein the connection properties include one of a hostname, a port number, a database name, a user name, and a password.

10. The system according to claim 1, wherein the plurality of database connectivity drivers supports a plurality of relational database management systems.

11. A method for configuring a terminal to access a database, the method comprising:

determining connection properties of the database, the database being accessible via a uniform resource locator string;

determining, based on the connection properties of the database and from a plurality of database connectivity drivers, one of the plurality of database connectivity drivers that enables a connection with the database; and

providing the one of the plurality of database connectivity drivers to the terminal via a network,

wherein the one of the plurality of database connectivity drivers comprises the uniform resource locator string and is configured to establish the connection with the database via the network based on the uniform resource locator string to enable communication between the terminal and the database.

12. The method according to claim 11, further comprising:

loading the one of the plurality of database connectivity drivers on the terminal for establishing the connection between the terminal and the database.

13. The method according to claim 12, wherein the uniform resource locator is pre-encoded in the one of the plurality of database connectivity drivers for establishing the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

14. The method according to claim 11, wherein the one of the plurality of database connectivity drivers is configured to establish the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

15. The method according to claim 11, wherein

the plurality of database connectivity drivers supports a plurality of relational database management systems,

each of the plurality of database connectivity drivers is stored in the memory,

the plurality of database connectivity drivers is aggregated into a single file in the memory, the single file having an archive file format, and

the method further comprises:

extracting the one of the plurality of database connectivity drivers from the single file before providing the one of the plurality of database connectivity drivers to the terminal via the network.

16. A non-transitory computer-readable medium having an executable computer program for configuring a terminal to access a database that, when executed by a processor, causes the processor to perform operations comprising:

determining connection properties of the database, the database being accessible via a uniform resource locator string;

determining, based on the connection properties of the database and from a plurality of database connectivity drivers, one of the plurality of database connectivity drivers that enables a connection with the database; and

providing the one of the plurality of database connectivity drivers to the terminal via a network,

wherein the one of the plurality of database connectivity drivers comprises the uniform resource locator string and is configured to establish the connection with the database via the network based on the uniform resource locator string to enable communication between the terminal and the database.

17. The non-transitory computer-readable medium according to claim 16, the operations further comprising:

loading the one of the plurality of database connectivity drivers on the terminal for establishing the connection between the terminal and the database.

18. The non-transitory computer-readable medium according to claim 17, wherein the uniform resource locator is pre-encoded in the one of the plurality of database connectivity drivers for establishing the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

19. The non-transitory computer-readable medium according to claim 16, wherein the one of the plurality of database connectivity drivers is configured to establish the connection with the database via the network based on the uniform resource locator string without requiring input of the uniform resource locator string at the terminal.

20. The non-transitory computer-readable medium according to claim 16, wherein

the plurality of database connectivity drivers supports a plurality of relational database management systems,

each of the plurality of database connectivity drivers is stored in the memory,

the plurality of database connectivity drivers is aggregated into a single file in the memory, the single file having an archive file format, and

the operations further comprise:

extracting the one of the plurality of database connectivity drivers from the single file before providing the one of the plurality of database connectivity drivers to the terminal via the network.