Identity for data sources

• US 20050055325A1
• Filed: 09/04/2003
• Published: 03/10/2005
• Est. Priority Date: 09/04/2003
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Dutt, Bala, Kumar, Ajay, Kannan, Srinivasan, Bhogi, Sankara R., K., Venugopal Rao
• Granted Patent: US 8,521,875 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Various embodiments of a networked computer system in which an application server associates an identity with each data source included in the system are disclosed. The networked computer system may include several backend systems, each including one or more data resources, and the identity of a data source may be unique to a data resource. When an application requests a connection to a data resource, the application server may ascertain the identity of the associated data source and compare this identity to identities of data sources with existing connections. If a match is found, the application server may provide an existing connection to the application, whereas if no match is found the application server may provide a new connection. The identity of a data source may include one or more data source configuration properties. In some embodiments, the identity may include database name, URL, and user name.

Claims

1. A system, comprising:

an application server; and

one or more of backend systems coupled to the application server;

wherein the one or more backend systems comprises a plurality data resources;

wherein the application server comprises;

an application configured to initiate requests for connections with the plurality of data resources;

a plurality of data sources configured to provide connections with the plurality of data resources; and

wherein the application server is configured to associate an identity with each of the plurality of data sources and to use the identity to determine whether one of the plurality of data sources provides connections to the same data resource as another of the plurality of data sources.

2. The system as recited in claim 1, wherein in response to the application requesting a connection from one of the plurality of data sources, a data source ID manager is configured to ascertain the identity of the data source from which the connection was requested and determine whether the identity matches the identity of any other of the plurality of data sources.

3. The system as recited in claim 2, wherein the data source ID manager is further configured to determine whether any of the data sources with matching identities previously supplied a connection to the application and, if a connection was previously supplied, to return the previously supplied connection to the application.

4. The system as recited in claim 3, wherein if no connection from a data source with a matching identity exists, the data source is configured to forward the request to a corresponding data source to obtain a new connection.

5. The system as recited in claim 4, wherein the connection is a local connection.

6. The system as recited in claim 1, wherein the identity comprises values for one or more data source properties.

7. The system as recited in claim 6, wherein the identity comprises database name, URL, and user name.

8. The system as recited in claim 1, wherein the application server is configured to instantiate a data source proxy for an abstract name of a data resource used by an application;

ascertain an identity for the data source; and

use the identity to link the proxy to the data source.

9. The system as recited in claim 8, wherein multiple data source proxies correspond to the same data source identity, wherein in response to the application requesting connections with a same data resource from multiple data source proxies, the data source proxies from which the connections were requested are configured to forward the connection requests to the data source whose identity corresponds to said proxies.

10. The system as recited in claim 1, wherein in response to a request to instantiate a data source corresponding to an abstract name, the application server is configured to determine an identity for the proposed data source, determine whether any existing data source has a matching identity, instantiate the proposed data source only if no existing data source with matching identity is found.

11. The system as recited in claim 1, wherein the application server further comprises a transaction manager;

wherein in response to a request to commit a transaction the transaction manager is configured to identify a number of data resources participating in the transaction according to connections supplied for unique data source identities;

wherein if the number of data resources participating in the transaction is two or more the transaction manager is configured to commit the transaction utilizing a two-phase commit protocol; and

wherein if only one data resource participating in the transaction the transaction manager is configured to commit the transaction utilizing a one-phase commit optimization.

12. A method, comprising:

receiving notification of a request for a connection;

ascertaining an identity of a data source associated with the request;

comparing said identity with the identities of data sources with existing connections;

providing an existing connection if an identity match is found with one of the data sources with existing connections; and

providing a new connection if no identity match is found.

13. The method as recited in claim 12, wherein the identity comprises values for one or more data source property.

14. The method as recited in claim 13, wherein the identity comprises database name, URL, and user name.

15. The method of claim 12, further comprising:

creating one or more data source proxies, wherein multiple data source proxies correspond to the same data source identity;

each data source proxy associated with the same data source identity forwarding connection requests to the same data source whose identity corresponds to said proxies.

16. The method of claim 12, further comprising:

in response to a request to commit a transaction, identifying the number of data resources participating in the transaction according to the number of unique data source identities used to establish data resource connections; and

if the number of data resources participating in the transaction is two or more, committing the transaction utilizing a two-phase commit protocol, and if only one data resource is participating in the transaction, committing the transaction utilizing a one-phase commit optimization.

17. A method, comprising:

receiving a request for a connection with a participant in a transaction;

ascertaining an identity of a local data source associated with the request;

attempting to identify a data source that is already participating in the transaction whose identity matches the identity of the data source associated with the request;

sharing an existing connection associated with the identity if a data source with a matching identity is found; and

providing a new connection if no data source with a matching identity is found.

18. A computer accessible medium comprising program instructions, wherein the program instructions are computer-executable to:

receive notification of a request for a connection;

ascertain an identity of a data source associated with the request;

determine whether the identity of a data source from among a plurality of local and global data source having an existing connection matches the identity of a data source associated with the request;

provide the existing connection if an identity match is found; and

provide a new connection if no identity match is found.

19. The computer accessible medium as recited in claim 18, wherein the identity comprises values for one or more data source properties.

20. The computer accessible medium as recited in claim 19, wherein the identity comprises database name, URL, and user name.

21. The computer accessible medium as recited in claim 18, wherein the program instructions are further computer-executable to:

create one or more data source proxies, wherein multiple data source proxies correspond to the same data source identity;

wherein each data source proxy associated with the same data source identity forwards connection requests to the same data source whose identity corresponds to said proxies.

22. The computer accessible medium as recited in claim 18, wherein the program instructions are further computer-executable to:

in response to a request to commit a transaction, identify the number of data resources participating in the transaction according to the number of unique data source identities used to establish data resource connections; and

if the number of data resources participating in the transaction is two or more, commit the transaction utilizing a two-phase commit protocol, and if only one data resource is participating in the transaction, commit the transaction utilizing a one-phase commit optimization.

23. A computer accessible medium comprising program instructions, wherein the program instructions are computer-executable to:

receive a request for a connection with a participant in a transaction;

ascertain an identity of a local data source associated with the request;

attempt to identify a data source that is already participating in the transaction whose identity matches the identity of the data source associated with the request;

share an existing connection associated with the identity if a data source with matching identity is found; and

provide a new connection if no data source with matching identity is found.