Providing interoperability in software identifier standards

• US 7,970,943 B2
• Filed: 08/14/2007
• Issued: 06/28/2011
• Est. Priority Date: 08/14/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Wilcox, Mark Edward, Lin, David Cheng-Fang
• Primary Examiner(s): Dharia; Rupal D
• Assistant Examiner(s): SHAW, ROBERT A
• Application Number:
  US11/838,537
• Publication Number:
  US 20090049200A1
• Time in Patent Office: 1,414 Days
• Field of Search: 709/246
• US Class Current: 709/246
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A system manages information exchanges between components of the system so that information is provided in a format expected by each particular component. In a specific implementation, a translation service provider intercepts information exchanges between client and data sources or data services and translates of converts software identifiers (e.g., UUIDs or GUIDs) as needed so that the client or data source can properly process the data. For example, a client may use GUIDs in a first format, and when information is requested is presented using a GUID in a second format, different from the first, the translation service provider translates a GUID to the first format. The translation service provider may be transparent to the other components of the system.

Claims

1. A computer-implemented method comprising:

a computer processor performing the steps of;

intercepting a request from a client for data stored at a first data source;

determining at least one data source where the data resides, where the data resides at the first data source or a second data source, different from the first data source;

wherein the first data source is configured to respond to a client request using a first communication protocol, and the second data source is configured to respond to a client request using a second communication protocol, different from the first communication protocol;

retrieving the data from the second data source;

obtaining a first identifier associated with the data, the first identifier being arranged to identify the data from the second data source, and being arranged in a first identifier format, wherein the first identifier format is a format for a globally unique identifier, and a value of the first identifier in the first identifier format is exclusively machine-generated;

determining if the first identifier format of the first identifier associated with the data from the second data source is different from a second identifier format, wherein the client is configured to receive an identifier in the second identifier format in response to its request, wherein the second identifier format is a format for a globally unique identifier,and a value of the first identifier in the second identifier format is exclusively machine-generated;

accessing a map indicating an identifier format, wherein the identifier format is associated with at least one of a data source or a client in a system;

when the first identifier format of the first identifier associated with the data from the second data source is different from the second identifier format, converting the first identifier into the second identifier format, wherein the converting is based on the map indicating an identifier format; and

after the converting the first identifier into the second identifier format, sending the data and associated first identifier to the client, wherein the first identifier is in the second identifier format, the second identifier format is a second format for a globally unique identifier, and the second format for a globally unique identifier is different from the first format for a globally unique identifier.

2. The computer-implemented method of claim 1 comprising:

accessing a map indicating where the data requested by the client resides.

3. The computer-implemented method of claim 1 wherein the map is selected from the group consisting of the first data source, the second data source, and the client.

4. The computer-implemented method of claim 1 wherein the map indicating the identifier format associated with at least one data source or at least one client in the system is generated on the fly.

5. The computer-implemented method of claim 1 wherein the first identifier format is a string of i hexadecimal characters, the second identifier format is a string of j hexadecimal characters including k separator characters, where j is greater than i, and the converting the first identifier into the second identifier format comprises:

inserting the separator characters at k different positions in the first identifier in the first identifier format.

6. The computer-implemented method of claim 1 wherein the first identifier format is a string of i hexadecimal characters including j separator characters, the second identifier format is a string of k hexadecimal characters, where i is greater than k, and the converting the first identifier into the second identifier format comprises:

removing the j separator characters from the first identifier in the first identifier format.

7. The computer-implemented method of claim 1 wherein the converting the first identifier into the second identifier format comprises:

dividing an n-bit value of the first identifier in the first format into m first bytes, where each first byte has p bits;

type casting each first byte into an integer;

performing a logical AND operation on each first byte with 0xFF to obtain resulting second bytes; and

converting each second byte into two hexadecimal characters; and

concatenating the hexadecimal characters into a string of hexadecimal characters.

8. The computer-implemented method of claim 1 wherein the converting the first identifier into the second identifier format comprises:

dividing n characters of hexadecimal string into n/2 pairs of two-hexadecimal substrings;

converting each of the two-hexadecimal substrings to an integer;

converting each integer into a byte value; and

forming a (n/2)-byte value with the n/2 converted bytes.

9. The computer-implemented method of claim 1 comprising:

intercepting a request from the client to store data at the second data source, the data comprising a second identifier in the second identifier format;

determining if the second identifier format is different from an identifier format associated with the second data source;

if the second identifier format is different from an identifier format associated with the second data source, converting the second identifier into the identifier format associated with the second data source;

storing the data and associated second identifier at the second data source, wherein the second identifier is in the identifier format associated with the second data source.

10. The computer-implemented method of claim 1 wherein the first and second data sources are databases.

11. The computer-implemented method of claim 1 wherein the first and second data sources are different directory services.

12. The computer-implemented method of claim 1 wherein a virtual directory program converts the first identifier into the second identifier format.

13. The computer-implemented method of claim 1 wherein the request by the client for data is directed to the first data source and the request is intercepted, without knowledge of the client.

14. The computer-implemented method of claim 1 wherein the first identifier format is a first format for a GUID and the second identifier format is a second format for a GUID, and the second format for a GUID is different from the first format for a GUID.

22. The computer-implemented method of claim 1 wherein the first data source is associated with a different identifier format from the second data source.

23. The computer-implemented method of claim 1 wherein the first data source is configured to respond to a client request using a first communication protocol, and the second data source is configured to respond to a client request using a second communication protocol, different from the first communication protocol, and the method comprises:

upon receiving a first response from the second data source, converting the first response into a second response that is in the first communication protocol; and

transmitting the second response to the client over a network.

25. The computer-implemented method of claim 1 wherein the first identifier in the first identifier format has an equivalent value to the first identifier in the second identifier format.

26. The computer-implemented method of claim 1 wherein means for converting the first identifier into the second identifier format is stored at the first data source.

15. A computer product comprising:

code stored on a non-transitory computer-readable storage medium which when executed by a computer processor performs the steps of ;

intercepting a request from a client for data stored at a first data source;

determining at least one data source where the data resides, where the data resides at the first data source or a second data source, different from the first data source;

code for retrieving the data from the second data source;

wherein the first data source is configured to respond to a client request using a first communication protocol, and the second data source is configured to respond to a client request using a second communication protocol, different from the first communication protocol;

obtaining a first identifier associated with the data, the first identifier being arranged to identify the data from the second data source, and being arranged in a first identifier format;

wherein the first identifier format is a first format for a globally unique identifier;

determining if the first identifier format of the first identifier associated with the data from the second data source is different from a second identifier format, wherein the client is configured to receive an identifier in the second identifier format in response to its request;

accessing a map indicating an identifier format, wherein the identifier format is associated with at least one of a data source or a client in a system;

translating the first identifier into the second identifier format when the first identifier format is different from the second identifier format, wherein the translating is based on the map indicating an identifier format; and

sending the data and associated first identifier to the client after the translating the first identifier into the second identifier format, wherein the first identifier is in the second identifier format, the second identifier format is a second format for a globally unique identifier, and the second format for a globally unique identifier is different from the first format for a globally unique identifier.

16. The computer product of claim 15 comprising:

code stored on a non-transitory computer-readable storage medium which when executed by a computer processor performs the steps of ;

intercepting a request from the client to store data at the second data source, the data comprising a second identifier in the second identifier format, the second identifier being arranged to identify the data;

determining if the second identifier format is different from an identifier format associated with the second data source;

translating the second identifier into the identifier format associated with the second data source when the second identifier format is different from the identifier format associated with the second data source;

storing the data and associated second identifier at the second data source, wherein the second identifier is in the identifier format associated with the second data source.

17. The computer product of claim 15 wherein translating the first identifier into the second identifier format comprises inserting separator characters into the first identifier in the first identifier format.

18. The computer product of claim 15 wherein the first and second identifiers are GUIDs.

19. The computer product of claim 15 wherein the first data source is a database.

20. The computer product of claim 15 wherein the code for translating the first unique identifier into the second identifier format is stored at the first data source.

21. The computer product of claim 15 wherein the map is selected from the group consisting of the first data source, the second data source and the client.

24. The computer product of claim 15 further comprising:

code stored on a non-transitory computer-readable storage medium which when executed by a computer processor performs the step of;

requesting from the client an identifier format the client is configured to receive.