Method and apparatus for mapping structured information to different structured information

• US 6,009,436 A
• Filed: 12/23/1997
• Issued: 12/28/1999
• Est. Priority Date: 12/23/1997
• Status: Expired due to Term

• Current Assignee: Ricoh Company Limited, Ricoh Corporation (Ricoh Company Limited)
• Original Assignee: Ricoh Company Limited, Ricoh Corporation (Ricoh Company Limited)
• Inventors: Motoyama, Tetsuro, Fong, Avery, Bhatnagar, Anurag
• Primary Examiner(s): Lintz, Paul R.
• Assistant Examiner(s): FLEURANTIN, JEAN B
• Application Number:
  US08/997,707
• Time in Patent Office: 735 Days
• Field of Search: 707/102, 707/2, 707/4, 707/100, 707/101, 706/59, 706/60
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method, apparatus, and computer program product for mapping a first structured information format to a second structured information format, which allows a user to interactively define the mapping. The present invention operates as a user tool by accepting interactive input from a user of a source input, by processing the input to display the source input in a format for accepting and processing user commands to create or edit a transformation map of source components to target components. Interactive user input is then accepted and processed for selection of an input file to be transformed and selection of a transformation map to be used for the requested transformation. Interactive user input is accepted and processed for selection of individual components of the first structured information format for mapping, and for selection of options for the target components. Exemplary options for the target components are a null value, the source component itself, a single selected target component, or plural selected target components. Interactive user input is accepted for processing to assign attribute values to components of the second structured information format. Exemplary options for the sources of attribute values are attribute values obtained from the source components, system attribute values, no value, attribute values input interactively by the user, and content of element. Interactive user input is then accepted and processed to initiate processing of a transformation of the source input file in the first structured information format to a target output file in the second structured information format.

Claims

1. A computer implemented method for processing information in a structured format, comprising the steps of:

(a) selecting an element for transformation of a first structured information format;

(b) determining properties of the element of the first structured information format;

(c) interactively inputting, from a user, an element of a second structured information format which corresponds to the element of the first structured information format;

(d) processing the element of the second structured information format to create a rule to transform the element of the first structured information format to the corresponding element of the second structured information format; and

(e) outputting the rule.

2. A method according to claim 1, wherein the first structured information format includes an ISO/IEC 9070 public identifier naming format, the second structured information format includes an operating system file name format, and the processing step comprises:

processing an operating system file name format element to create a rule to transform an ISO/IEC 9070 public identifier naming format element to the corresponding operating system file name format element.

3. A method according to claim 1, wherein the first structured information format includes a first database variable name format, the second structured information format includes a second database variable name format, and the processing step comprises:

processing a second database variable name format element to create a rule to transform a first database variable name format element to the corresponding second database variable name format element.

4. A method according to claim 1, wherein the structured format includes a markup language format, the first structured information format includes a first markup language format, the second structured information format includes a second markup language format, and the processing step comprises:

processing a second markup language format element to create a rule to transform a first markup language format element to the corresponding second markup language format element.

5. A method according to claim 4, wherein the first markup language format includes a Standard Generalized Markup Language ("SGML"), the second markup language format includes a HyperText Markup Language ("HTML"), and the processing step comprises:

processing an HTML element of the second markup language format to create a rule to transform an SGML element of the first markup language format to the corresponding HTML element element of the second markup language format.

6. A method according to claim 1, wherein the processing step comprises:

determining a condition for transformation of the element of the first structured information format to a corresponding element of the second structured information format; and

processing the element of the second structured information format to create a rule to transform the element of the first structured information format to the corresponding element of the second structured information format using the condition.

7. A method according to claim 1, wherein the outputting step (e) comprises:

outputting the rule to a map.

8. A method according to claim 7, further comprising the steps of repeating steps (a) through (e) for a second element of the first structured information format.

9. A method according to claim 1, wherein the step (c) further comprises the steps of:

(c-1) determining properties of the element input by the user; and

(c-2) inputting from the user a source for inputting a second structured information format attribute value of the second element, when step(c-1) determines that the element input by the user has a property which includes an attribute.

10. A method according to claim 9, further comprising the steps of:

(f) examining the source which has been input by the user; and

(g) assigning a null value to the second structured information format attribute value, when the source which has been input by the user indicates no source is to be used.

11. A method according to claim 9, further comprising the steps of:

(f) examining the source which has been input by the user; and

(g) assigning a system value to the second structured information format attribute value, when the source which has been input by the user indicates a system source is to be used.

12. A method according to claim 9, further comprising the steps of:

(f) examining the source which has been input by the user; and

(g) assigning a first structured information format attribute value to the second structured information format attribute value, when the source which has been input by the user indicates a first structured information format attribute source is to be used.

13. A method according to claim 9, further comprising the steps of:

(f) examining the source which has been input by the user; and

(g) assigning a first structured information format content value to the second structured information format attribute value, when the source which has been input by the user indicates a first structured information format content source is to be used.

14. A method according to claim 9, further comprising the steps of:

(f) examining the source which has been input by the user;

(g) interactively inputting a user input value, when the source which has been input by the user indicates a user input source is to be used; and

(h) assigning the user input value to the second structured information format attribute value, when the source which has been input by the user indicates a user input source is to be used.

15. A method according to claim 7, further comprising the steps of:

(f) inputting the map;

(g) inputting a first structured information format file;

(h) processing the first structured information format file and the map to transform the first structured information format file into a second structured information format file; and

(i) outputting the second structured information format file.

16. A method according to claim 15, wherein the processing step (h) further comprises the steps of:

(h-1) inputting a structural definition of the second structured information format;

(h-2) obtaining a first structured information format element from the first structured information format file; and

(h-3) processing the first structured information format element into a plurality of first structured information format components.

17. A method according to claim 16, wherein the processing step (h) further comprises the steps of:

(h-4) obtaining a first structured information format component from the plurality of first structured information format components;

(h-5) processing the first structured information format component into a second structured information format string; and

(h-6) outputting the second structured information format string.

18. A method according to claim 17, wherein the processing step (h-5) further comprises the steps of:

determining whether the first structured information format component contains text;

obtaining a text string from the first structured information format component, when the first structured information format component is determined to contain text; and

outputting the text string, when the first structured information format component is determined to contain text.

19. A method according to claim 17, wherein the processing step (h-5) further comprises the steps of:

determining whether the first structured information format component includes a first structured information format tag; and

processing the first structured information format component into a second structured information format string, when the first structured information format component is determined to include a first structured information format tag.

20. A method according to claim 1, further comprising the steps of:

(f) selecting a second element for transformation of the first structured information format;

(g) determining properties of the second element of the first structured information format;

(h) interactively inputting, from the user, a selection of a transformation to be performed on the second element of the first structured information format;

(i) processing the selection of a transformation which has been input by the user to create a rule to transform the second element of the first structured information format to a corresponding element of the second structured information format; and

(j) outputting the rule.

21. A method according to claim 20, wherein the processing step (i) further comprises the step of:

creating a rule to map the second element of the first structured information format to a null string, when the selection of a transformation which has been input by the user indicates a null transformation is to be performed.

22. A method according to claim 20, wherein the processing step (i) further comprises the step of:

creating a rule to map the second element of the first structured information format to a copy of the second element of the first structured information format, when the selection of a transformation which has been input by the user indicates a transformation of the second element of the first structured information format to a copy of the second element of the first structured information format is to be performed.

23. An apparatus for processing information in a structured format, comprising:

a first element selecting means for selecting an element for transformation of a first structured information format;

a first property determining means for determining properties of the element of the first structured information format;

an inputting means for interactively inputting, from a user, an element of a second structured information format which corresponds to the element of the first structured information format;

a processing means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format to the corresponding element of the second structured information format; and

an outputting means for outputting the rule.

24. An apparatus according to claim 23, wherein the first structured information format includes an ISO/IEC 9070 public identifier naming format, the second structured information format includes an operating system file name format, and the processing means comprises:

means for processing an operating system file name format element to create a rule to transform an ISO/IEC 9070 public identifier naming format element to the corresponding operating system file name format element.

25. An apparatus according to claim 23, wherein the first structured information format includes a first database variable name format, the second structured information format includes a second database variable name format, and the processing means comprises:

means for processing a second database variable name format element to create a rule to transform a first database variable name format element to the corresponding second database variable name format element.

26. An apparatus according to claim 23, wherein the structured format includes a markup language format, the first structured information format includes a first markup language format, the second structured information format includes a second markup language format, and the processing means comprises:

a markup language processing means for processing a second markup language element to create a rule to transform a first markup language element to the corresponding second markup language element.

27. An apparatus according to claim 26, wherein the first markup language includes an SGML, the second markup language includes an HTML, and the markup language processing means comprises:

means for processing an HTML element of the second markup language to create a rule to transform an SGML element of the first markup language to the corresponding HTML element of the second markup language.

28. An apparatus according to claim 23, wherein the processing means comprises:

a condition determining means for determining a condition for transformation of the element of the first structured information format to a corresponding element of the second structured information format; and

means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format to the corresponding element of the second structured information format using the condition.

29. An apparatus according to claim 23, wherein the outputting means comprises:

means for outputting the rule to a map.

30. An apparatus according to claim 29, further comprising:

a second element selecting means for selecting a second element for transformation of a first structured information format.

31. An apparatus according to claim 23, wherein the inputting means further comprises:

a second property determining means for determining properties of the element of the second structured information format input by the user; and

means for inputting from the user a source for inputting a second structured information format attribute value of the element of the second structured information format input by the user.

32. An apparatus according to claim 31, further comprising:

means for examining the source which has been input by the user;

a source determining means for determining a source to be used for assigning a value to the second structured information format attribute value; and

means for assigning a null value to the second structured information format attribute value when the source determining means determines that no source is to be used.

33. An apparatus according to claim 31, further comprising:

means for examining the source which has been input by the user;

a source determining means for determining a source to be used for assigning a value to the second structured information format attribute value; and

means for assigning a system value to the second structured information format attribute value when the source determining means determines that a system value is to be used.

34. An apparatus according to claim 31, further comprising:

means for examining the source which has been input by the user;

a source determining means for determining a source to be used for assigning a value to the second structured information format attribute value; and

means for assigning a first structured information format attribute value to eh second structured information format attribute value, when the source determining means determines that a first structured information format attribute source is to be used.

35. An apparatus according to claim 31, further comprising:

means for examining the source which has been input by the user;

a source determining means for determining a source to be used for assigning a value to the second structured information format attribute value; and

means for assigning a first structured information format content value to the second structured information format attribute value, when the source determining means determines that a first structured information format content source is to be used.

36. An apparatus according to claim 31, further comprising:

means for examining the source which has been input by the user;

a source determining means for determining a source to be used for assigning a value to the second structured information format attribute value;

means for interactively inputting a user input value when the source determining means determines that a user input source is to be used; and

means for assigning the suer input value to the second structured information format attribute value when the source determining means determines that a user input source is to be used.

37. An apparatus according to claim 29, further comprising:

means for inputting the map;

means for inputting a first structured information format file;

a transformation processing means for processing the first structured information format file and the map to transform the first structured information format file into a second structured information format file; and

means for outputting the second structured information format file.

38. An apparatus according to claim 37, wherein the transformation processing means further comprises:

means for inputting a structural definition of the second structured information format;

means for obtaining a first structured information format element from the first structured information format file; and

means for processing the first structured information format element into a plurality of first structured information format components.

39. An apparatus according to claim 38, wherein the transformation processing means further comprises:

means for obtaining a first structured information format component from the plurality of first structured information format components;

means for processing the first structured information format component into a second structured information format string; and

means for outputting the second structured information format string.

40. An apparatus according to claim 39, wherein the means for processing the first structured information format component into a second structured information format string comprises:

a text determining means for determining whether the first structured information format component contains text;

means for obtaining a text string from the first structured information format component when the text determining means determines that the first structured information format component contains text; and

means for outputting the text string when the text determining means determines that the first structured information format component contains text.

41. An apparatus according to claim 39, wherein the means for processing the first structured information format component into a second structured information format string comprises:

a tag determining means for determining whether the first structured information format component contains a first structured information format tag; and

means for processing the first structured information format component into a second structured information format string when the tag determining means determines that the first structured information format component contains a first structured information format tag.

42. An apparatus according to claim 23, further comprising:

a second element selecting means for selecting a second element for transformation of the first structured information format;

a second property determining means for determining properties of the second element of the first structured information format;

means for interactively inputting, from the user, a selection of a transformation to be performed on the second element of the first structured information format;

a rule creating processing means for processing the selection which has been input by the user to create a rule to transform the second element of the first structured information format to a corresponding element of the second structured information format; and

means for outputting the rule.

43. An apparatus according to claim 42, wherein the rule creating processing means further comprises:

a selection determining means for determining the selection of a transformation input by the user; and

means for creating a rule to map the second element of the first structured information format to a null string when the selection determining means determines that the selection of a transformation which has been input by the user indicates a null transformation is to be performed.

44. An apparatus according to claim 42, wherein the rule creating processing means further comprises:

a selection determining means for determining the selection of a transformation input by the user; and

means for creating a rule to map the second element of the first structured information format to a copy of the second element of the first structured information format, when the selection determining means determines that the selection of a transformation which has been input by the user indicates a transformation of the second element of the first structured information format to a copy of the second element of the first structured information format is to be performed.

45. A computer program product including a computer readable medium for processing information in a structured format, comprising:

means for selecting an element for transformation of a first structured information format;

means for determining properties of the element of the first structured information format;

inputting means for interactively inputting, for a user, an element of a second structured information format which corresponds to the element of the first structured information format;

processing means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format to the corresponding element of the second structured information format; and

outputting means for outputting the rule.

46. A computer program product according to claim 45, wherein the first structured information format includes ISO/IEC 9070 public identifier naming format, the second structured information format includes an operating system file name format and the processing means comprises:

means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format which includes an ISO/IEC 9070 public identifier element to the corresponding element of the second structured information format which includes an operating system file name element.

47. A computer program product according to claim 45, wherein the first structured information format includes a first database variable name format, the second structured information format includes a second database variable name format and the processing means comprises:

means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format which includes a database variable name element to the corresponding element of the second structured information format which includes a database variable name element.

48. A computer program product according to claim 45, wherein the structured format includes markup language format, the first structured information format includes a first markup language, the second structured information format includes a second markup language and the processing means comprises:

means for processing the element of the second structured information format to create a rule to transform the element of the first structured information format which includes a first markup language element to the corresponding element of the second structured information format which includes a second markup language element.

49. A computer program product according to claim 48, wherein the first markup language includes SGML, the second markup language includes HTML, and the processing means comprises:

means for processing the element of the second markup language to create a rule to transform the element of the first markup language which includes an SGML element to the corresponding element of the second markup language which includes an HTML element.