System and method for translating to and from hierarchical information systems

• US 7,072,903 B2
• Filed: 12/20/2002
• Issued: 07/04/2006
• Est. Priority Date: 01/07/2000
• Status: Expired due to Term

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture LLP (Accenture PLC)
• Inventors: Phillips, Jay, Joshi, Dhananjay M., Hudgons, Morrisha L., Milleker, William N.
• Primary Examiner(s): Pardo, Thuy N.
• Application Number:
  US10/327,622
• Publication Number:
  US 20030220930A1
• Time in Patent Office: 1,292 Days
• Field of Search: 707/10, 707/100, 707/101, 707/102, 707/103, 707/1, 707/2, 707/4, 707/203, 707/205, 709/223
• US Class Current: 707/694
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method for translating to and from an hierarchical information system, comprises identifying a non-hierarchical information system containing information stored in a non-hierarchical manner; developing a translation map that identifies organizational and content based rules for translating the non-hierarchical information into an hierarchical information system; and translating the non-hierarchical information for storage into the hierarchical information system according to the rules for translating.

Claims

1. A system for translating from a non-hierarchical information system to a hierarchical information system, the system comprising logic for:

providing a translation map that identifies organization and content based rules for translating information from the non-hierarchical information system to the hierarchical information system based on at least one attribute;

receiving non-hierarchical information;

determining attribute information from the non-hierarchical information based on the translation map; and

translating the attribute information to create hierarchical information based on the translation map by modifying the attribute information and adding the modified attribute information to a message under construction.

2. The system of claim 1, wherein the translation map defines location of the attribute in the non-hierarchical information;

and

wherein the logic for determining attribute information comprises logic for searching the location in the non-hierarchical information to determine the attribute information.

3. The system of claim 1, wherein the translation map comprises a rule;

and

wherein the logic for determining attribute information comprises logic for searching the non-hierarchical information for attribute information during execution of the rule.

4. The system of claim 1, wherein the translation map defines format of the attribute in the hierarchical information;

and

wherein the logic for modifying the attribute information comprises logic for formatting the attribute information based on the format of the attribute in the translation map.

5. The system of claim 1, wherein the logic for translating the attribute comprises logic for performing a calculation based on the attribute information.

6. The system of claim 1, wherein the logic for modifying the attribute information comprises logic for formatting the attribute information based on the translation map and appending the formatted attribute to the message under construction.

7. The system of claim 1, further comprising logic for:

providing a second translation map from a hierarchical information system to a non-hierarchical information system based on at least one attribute;

receiving a hierarchical message;

determining second attribute information from the hierarchical message based on the second translation map; and

translating the second attribute information to create a non-hierarchical message based on the second translation map.

8. The system of claim 1, wherein the non-hierarchical information system comprises a non-XML system and wherein the hierarchical information system comprises an XML system.

9. A system for translating from a hierarchical information system to a non-hierarchical information system, the system comprising logic for:

providing a translation map that identifies organization and content based rules for translating information from the hierarchical information system to the non-hierarchical information system based on at least one attribute;

receiving hierarchical information;

determining attribute information from the hierarchical information based on the translation map; and

translating the attribute information to create non-hierarchical information based on the translation map by modifying the attribute information and adding the modified attribute information to a message under construction.

10. The system of claim 9, wherein the translation map defines location of the attribute in the hierarchical information;

and

wherein the logic for determining the attribute information comprises logic for searching the location in the hierarchical information to determine the attribute information.

11. The system of claim 9, wherein the translation map comprises a rule;

and

wherein the logic for determining attribute information comprises logic for searching the hierarchical information for attribute information during execution of the rule.

12. The system of claim 9, wherein the translation map defines format of the attribute in the non-hierarchical information;

and

wherein the logic for modifying the attribute information comprises logic for formatting the attribute information based on the format of the attribute in the translation map.

13. The system of claim 9, wherein translating the attribute comprises performing a calculation based on the attribute information.

14. The system of claim 9, wherein the logic for modifying the attribute information comprises logic for formatting the attribute information based on the translation map and appending the formatted attribute to the message under construction.

15. The system of claim 9, wherein the logic for translating the attribute information comprises logic for mapping the attribute information to the non-hierarchical information.

16. The system of claim 9, further comprising logic for inserting constants in the non-hierarchical information.

17. The system of claim 9, wherein the non-hierarchical information system comprises a non-XML system and wherein the hierarchical information system comprises an XML system.

18. A method of translating between XML and non-XML information systems comprising:

providing a first translation map that identifies organization and content based rules for translating information from a non-XML information system to an XML information system based on at least one attribute;

providing a second translation map that identifies organization and content based rules for translating information from an XML information system to at least one non-XML information system based on at least one attribute;

receiving non-XML information;

determining non-XML attribute information from the non-XML information based on the first translation map;

translating the non-XML attribute information to create XML information based on the first translation map;

determining, between at least two non-XML information systems, which non-XML information system to send a message;

determining XML attribute information from the XML information based on the second translation map;

creating non-XML message by translating the XML attribute information using the second translation map; and

sending the non-XML message to the determined non-XML information system.

19. The method of claim 18, wherein translating the non-XML attribute information to create XML information based on the first translation map comprises modifying the non-XML attribute information and adding the modified non-XML attribute information to a message under construction.

20. The method of claim 19, wherein the first translation map defines a format of the XML attribute in the XML information;

and

wherein modifying the non-XML attribute information comprises formatting the non-XML attribute information based on the format of the XML attribute in the first translation map from a non-XML information system to an XML information system.

21. The method of claim 18, wherein translating the XML attribute information using the second translation map from the XML information system to the at least one non-XML information system comprises modifying the XML attribute information and adding the modified XML attribute information to a message under construction.

22. The method of claim 18, wherein creating non-XML message comprises packaging the non-XML message.

23. The method of claim 22, wherein packaging the non-XML message comprises packaging the non-XML message as a queued message.

24. The method of claim 18, wherein sending the non-XML message to the determined non-XML information system comprises depositing the non-XML message on a queue for the determined non-XML information system.

25. A system for translating between hierarchical and non-hierarchical information systems, the system comprising logic for:

providing a first translation map that identifies organization and content based rules for translating information from a non-hierarchical information system to an hierarchical information system based on at least one attribute;

providing a second translation map that identifies organization and content based rules for translating information from an hierarchical information system to at least one non-hierarchical information system based on at least one attribute;

receiving non-hierarchical information;

determining non-hierarchical attribute information from the non-hierarchical information based on the first translation map;

translating the non-hierarchical attribute information to create hierarchical information based on the first translation map;

determining, between at least two non-hierarchical information systems, which non-hierarchical information system to send a message;

determining hierarchical attribute information from the hierarchical information based on the second translation map;

creating non-hierarchical message by translating the hierarchical attribute information using the second translation map; and

sending the non-hierarchical message to the determined non-hierarchical information system.

26. The system of claim 25, wherein the logic for translating the non-hierarchical attribute information to create hierarchical information based on the first translation map comprises logic for modifying the non-hierarchical attribute information and adding the modified non-hierarchical attribute information to a message under construction.

27. The system of claim 26, wherein the first translation map defines a format of the attribute in the hierarchical information;

and

wherein the logic for modifying the non-hierarchical attribute information comprises logic for formatting the non-hierarchical attribute information based on the format of the attribute in the first translation map.

28. The system of claim 25, wherein the logic for translating the hierarchical attribute information using the second translation map comprises logic for modifying the hierarchical attribute information and adding the modified hierarchical attribute information to a message under construction.

29. The system of claim 25, wherein the logic for creating non-hierarchical message comprises logic for packaging the non-hierarchical message.

30. The system of claim 25, wherein the logic for sending the non-hierarchical message to the determined non-hierarchical information system comprises logic for depositing the non-hierarchical message on a queue for the determined non-hierarchical information system.

31. A method of translating between XML and non-XML information systems comprising:

providing a translation map that identifies organization and content based rules for translating information from an XML information system to at least one non-XML information system based on at least one attribute;

receiving XML information;

determining, between at least two non-XML information systems, which non-XML information system to send a message;

determining attribute information from the XML information based on the translation map;

creating non-XML information based on translating the attribute information using the translation map; and

sending the non-XML information to the determined non-XML information system.

32. The method of claim 31, wherein translating the attribute information using the translation map comprises modifying the attribute information and adding the modified attribute information to a message under construction.

33. The method of claim 32, wherein the translation map defines a format of the attribute in the non-XML information;

and

wherein modifying the attribute information comprises formatting the attribute information based on the format of the attribute in the translation map.

34. The method of claim 31, wherein creating non-XML message comprises packaging the non-XML message.

35. The method of claim 34, wherein packaging the non-XML message comprises packaging the non-XML message as a queued message.

36. The method of claim 31, wherein sending the non-XML message to the determined non-XML information system comprises depositing the non-XML message to a queue for the determined non-XML information system.

37. A system for translating between hierarchical and non-hierarchical information systems, the system comprising logic for:

providing a translation map that identifies organization and content based rules for translating information from an hierarchical information system to at least one non-hierarchical information system based on at least one attribute;

receiving hierarchical information;

determining, between at least two non-hierarchical information systems, which non-hierarchical information system to send a message;

determining attribute information from the hierarchical information based on the translation map;

creating non-hierarchical information based on translating the attribute information using the translation map; and

sending the non-hierarchical information to the determined non-hierarchical information system.

38. The method of claim 37, wherein the logic for translating the attribute information using the translation map comprises logic for modifying the attribute information and adding the modified attribute information to a message under construction.

39. The method of claim 37, wherein the logic for creating non-hierarchical message comprises logic for packaging the non-hierarchical message.

40. The method of claim 39, wherein the logic for packaging the non-hierarchical message comprises logic for packaging the non-hierarchical message as a queued message.