Database connectivity

• US 20070299822A1
• Filed: 06/26/2006
• Published: 12/27/2007
• Est. Priority Date: 06/26/2006
• Status: Abandoned Application

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Jopp, John, Ammay, Felix, Harrell, Aaron D., Walker, Jackie E.
• Application Number:
  US11/474,854
• Publication Number:
  US 20070299822A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Database connectivity without a need for installing database specific drivers on individual client machines/applications is provided. A database access application module resides on a server associated with the database(s) to be accessed. User interface modules residing on individual client machines/applications enable users to submit their queries or select from a set of predefined queries through the database access application module and receive result sets. Available databases and their properties are updated by the database access application module preventing delays and errors without a need to update database information on individual clients.

Claims

1. A method to be executed at least in part in a computing device for accessing a database, comprising:

receiving a query at a server application module that is installed at a server associated with the database, wherein the server maintains database specific information, and wherein the query is provided by a user interface module independent of the database;

submitting the query to the database from the server; and

providing a result set associated with the query to the user interface module from the server application module.

2. The method of claim 1, wherein receiving the query includes one of:

receiving a user prepared query; and

receiving one of a predefined set of queries based on a user selection.

3. The method of claim 1, further comprising:

receiving a user credential; and

submitting the query to the database upon confirming a validity of the user credential.

4. The method of claim 1, wherein the user interface module is installed at one of:

a client application and a client device.

5. The method of claim 1, wherein the server is one of:

a server application and a server machine.

6. The method of claim 1, wherein the server is a web server.

7. The method of claim 1, further comprising:

validating the received query before submitting to the database.

8. The method of claim 1, further comprising:

maintaining a history of submitted queries such that the user may reuse a previously submitted query.

9. The method of claim 1, further comprising:

translating the received query based on database specific properties.

10. The method of claim 1, further comprising:

executing the received query on a plurality of databases.

11. The method of claim 1, further comprising:

receiving database specific property information from the database upon receiving the query; and

making the database available for querying to at least one additional user.

12. The method of claim 11, further comprising:

updating the database specific property information anytime a query is received from a user associated with the database.

13. A system for accessing a database, comprising:

a user interface module installed on a client device arranged to;

enable a user to provide a query for the database by one of;

selecting from a predefined set of queries and entering a user-defined query;

submit the query to a server application module; and

the server application module arranged to;

receive the submitted query from the user interface module;

execute the query on the database; and

return a result set received from the database in response to the executed query to the user interface module.

14. The system of claim 13, wherein the server application module is further arranged to:

determine the database based on the received query; and

receive a database specific property upon determining the database.

15. The system of claim 14, wherein the server application module is further arranged to:

confirm a user credential; and

validate the query based on the database specific property before executing the query.

16. The system of claim 14, wherein the server application module is further arranged to:

update the database specific property at a predetermined period; and

make the database available for querying to at least one additional user.

17. The system of claim 13, wherein the user interface module is further arranged to:

activate an application to consume the received result set.

18. A computer-readable medium having computer executable instructions for accessing a database, the instructions comprising:

enabling a user to provide a query directed to the database using a user interface module that is installed at a client device associated with the user without having a database specific driver installed at the client device;

receiving the query at a server application module that is installed at a web server associated with the database, wherein the server maintains database specific information;

submitting the query to the database from the server application module; and

providing a result set associated with the query to the user interface module from the server application module.

19. The computer-readable medium of claim 18, wherein the instructions further comprise:

modifying the query at the server application module based on at least one of;

a user credential, a database property, and a system resource availability.

20. The computer-readable medium of claim 18, wherein the instructions further comprise:

providing the user one of;

a predefined set of queries and a list of previously submitted queries to select from.