Method and system for implementing database connection mapping for reporting systems

• US 7,801,967 B1
• Filed: 06/19/2001
• Issued: 09/21/2010
• Est. Priority Date: 06/19/2001
• Status: Active Grant

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Trundle, Stephen S., Bedell, Jeffrey A., Li, Benjamin Z., Orozco, Luis V.
• Primary Examiner(s): Flynn; Nathan
• Assistant Examiner(s): PATEL, CHIRAG R
• Application Number:
  US09/883,301
• Time in Patent Office: 3,381 Days
• Field of Search: 707/3, 707/5, 707/100, 707/102, 707/10, 707/E17.045, 709217-218, 709/219, 726/4
• US Class Current: 709/217
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: H04L 63/105 Multiple levels of security

Abstract

A method and system for implementing database connection mapping for mapping a user who may be associated with a group of users to an appropriate database via a database connection wherein the database connection comprises information for locating and logging into the appropriate database. A centralized server may control the access to databases, thereby ensuring efficient use of database resources. A user may log into a server and then be mapped to an appropriate database via a database name and login, provided by a database connection. Database connection mapping may provide the ability to map multiple users to the same database login as well as the ability to map different users to different database logins.

Claims

1. A method for implementing database connection mapping for connecting a user to at least one database in a reporting system, comprising the steps of:

enabling a user to submit a user identification input and a user request to a reporting system;

identifying the user based on user identification input; and

controlling access to at least one database through a centralized server wherein the centralized server maps the user to at least one appropriate database based on the user request and at least one database connection definition.

2. The method of claim 1 wherein the database connection definition comprises a data source name and a set of properties for establishing a database connection to at least one database.

3. The method of claim 2 wherein the data source name comprises information for locating and logging into a database.

4. The method of claim 2 wherein the database connection comprises a physical open database connectivity connection to a database.

5. The method of claim 1 wherein the user is associated with a group of users where each user of the group is mapped to a database connection via a database login.

6. The method of claim 1 further comprising the step of load balancing query volume associated with the at least one database.

7. A system for implementing database connection mapping for connecting a user to at least one database in a reporting system, comprising:

a user input for enabling a user to submit a user identification input and a user request to a reporting system;

an identification module for identifying the user based on user identification input; and

a centralized server for controlling access to at least one database wherein the centralized server maps the user to at least one appropriate database based on the user request and at least one database connection definition.

8. The system of claim 7 wherein the database connection definition comprises a data source name and a set of properties for establishing a database connection to at least one database.

9. The system of claim 8 wherein the data source name comprises information for locating and logging into a database.

10. The system of claim 8 wherein the database connection comprises a physical open database connectivity connection to a database.

11. The system of claim 7 wherein the user is associated with a group of users where each user of the group is mapped to a database connection via a database login.

12. The system of claim 7 further comprising a load balancing module for load balancing query volume associated with the at least one database.

13. A non-transitory processor-readable medium comprising code for execution by a processor to implement database connection mapping for connecting a user to at least one database in a reporting system, the medium comprising:

code for causing a processor to enable a user to submit a user identification input and a user request to a reporting system;

code for causing a processor to identify the user based on user identification input; and

code for causing a processor to control access to at least one database through a centralized server wherein the centralized server maps the user to at least one appropriate database based on the user request and at least one database connection definition.

14. The medium of claim 13 wherein the database connection definition comprises a data source name and a set of properties for establishing a database connection to at least one database.

15. The medium of claim 14 wherein the data source name comprises information for locating and logging into a database.

16. The medium of claim 14 wherein the database connection comprises a physical open database connectivity connection to a database.

17. The medium of claim 13 wherein the user is associated with a group of users where each user of the group is mapped to a database connection via a database login.

18. The medium of claim 13 further comprising code for causing a processor to load balance query volume associated with the at least one database.