Multi-user system with dynamic data source selection

• US 20070226339A1
• Filed: 06/27/2002
• Published: 09/27/2007
• Est. Priority Date: 06/27/2002
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Dixit, Sunil, Suen, Edward
• Granted Patent: US 8,799,489 B2
• Time in Patent Office: Days
• US Class Current: 709/226
• CPC Class Codes: G06F 16/2457 with adaptation to user needs

Abstract

Techniques to dynamically select data sources for users and to direct queries for the users to the proper data sources. Initially, user information (e.g., user name) for each user is received and used to determine a data source designated for the user. The designated data source may be determined via a look-up table or by running a query with the user information to obtain the identity (e.g., the logical name) of the data source. A data source variable for each user can then be set to the identity of the designated data source. Thereafter, queries for each user are directed to the user'"'"'s designated data source by determining database connection information for the designated data source based on the data source variable and using this information to direct the queries.

Claims

1. A computer program product comprising:

a computer-readable medium having embodied therein computer-readable program codes, wherein the computer-readable program codes are configured to receive user information for each user of a plurality of users at the start of each user'"'"'s session;

dynamically determine a plurality of data sources designated for each user based on the user information;

set a data source variable for each user, wherein the data source variable comprises information configured to identify the data sources designated for the user; and

direct queries for each user to the data sources designated for the user based on the identity of the data sources set in the data source variable.

2. The computer program product of claim 1, wherein the user information comprises identification information.

3. The computer program product of claim 2, wherein the identification information for each user comprises login information.

4. The computer program product of claim 2, wherein the identification information and identity of the designated data sources for each user are stored in a look-up table.

5. The computer program product of claim 1, wherein the identity of each of the data sources set in the data source variable for each user is only valid for the current session.

6. The computer program product of claim 1, wherein the computer-readable program codes configured to determine comprises computer-readable program codes configured to

execute a query for each user with the user information to obtain identities of the data sources designated for the user.

7. The computer program product of claim 6, wherein the computer-readable program codes configured to determine further comprises computer-readable program codes configured to

access a look-up table with the user information to obtain identities of the data sources designated for the user.

10. The computer program product of claim 1, wherein the computer-readable program codes configured to direct computer-readable program codes configured to

determine database connection information for the data sources designated for each user, and wherein the queries for the user are directed to the designated data sources based on the database connection information.

11. The computer program product of claim 10, wherein the database connection information for the data sources is stored in a configuration file.

12. The computer program product of claim 1, wherein the computer-readable program codes are installed in a single server.

8. (canceled)

9. (canceled)

13. A method comprising:

supporting dynamic selection of data sources for users, by virtue of

receiving user information for each user of a plurality of users at the start of each user'"'"'s session;

dynamically determining a plurality of data sources designated for each user based on the user information;

setting a data source variable for each user, wherein the data source variable comprises information identifying the data sources designated for the user; and

directing queries for each user to the data sources designated for the user based on the identity of the data source set in the data source variable.

14. The method of claim 13, further comprising:

setting a data source variable for each user to identify the data sources designated for the user, and wherein the queries for each user are directed to the designated data sources based on the data source variable.

15. The method of claim 14, further comprising:

determining database connection information for the data sources designated for each user based on the data source variable, and wherein the queries for the user are directed to the designated data sources based on the database connection information.

22. The method of claim 13, wherein

the identity of the data source set in the data source variable for each user is only valid for the current session.

16. A computer program product comprising:

a computer-readable medium having embodied therein computer-readable program codes configured to maintain a data structure configured to support dynamic selection of a plurality of data sources for each one of a plurality of users, the data structure comprising

a first section configured to store identification information for the users; and

a second section configured to store identities of the plurality of data sources designated to be used for the users, wherein

the stored identities of the data sources are only valid for a single session, and

the identities of the stored data sources are such that the data structure is configured to be accessed to determine the identities of data sources designated for each user based on the identification information.

17. The computer program product of claim 16, wherein the first section stores user names of the users.

18. The computer program product of claim 16, wherein the second section stores logical names of the data sources.

19. A computer system comprising:

means for receiving user information for each user of a plurality of users at the start of each user'"'"'s session;

means for dynamically determining a plurality of data sources designated for each user based on the user information;

means for setting a data source variable for each user, wherein the data source variable comprises information identifying the data sources designated for the user; and

means for directing queries for each user to the data sources designated for the user based on the identity of the data source set in the data source variable.

20. The computer system of claim 19, further comprising:

means for setting a data source variable for each user to identify the data sources designated for the user, and wherein the queries for each user are directed to the designated data sources based on the data source variable.

23. The method of claim 19, wherein

the identity of the data source set in the data source variable for each user is only valid for the current session.

21. A method comprising:

dynamically selecting a data source, by virtue of

providing a single interface configured to query a plurality of data sources;

receiving user information for each user of a plurality of users;

dynamically determining, from amongst the plurality of data sources, a plurality of data sources designated for each user based on the user information; and

when queries are received from a user via the interface, directing the received queries to the data source designated for the user.