Generating XML instances from flat files

• US 8,024,368 B2
• Filed: 12/07/2005
• Issued: 09/20/2011
• Est. Priority Date: 10/07/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Yoshida, Shinji, Roy, Indroniel Deb
• Primary Examiner(s): TO, BAOQUOC N
• Application Number:
  US11/297,172
• Publication Number:
  US 20070083538A1
• Time in Patent Office: 2,113 Days
• Field of Search: None
• US Class Current: 707/802
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/221 Parsing markup language streams streaming G06F40/149

Abstract

In order to parse a flat file to create an XML instance, information about the data and its hierarchy is captured in an XML schema definition. Once the data structure is defined in the Schema, the parsing instructions for the flat file are introduced in the schema so that after producing an XML instance from a schema definition, the instance may be populated with live data from the flat file.

Claims

1. A method for converting a body of data records to an XML format, wherein each record of said body of data records conforms to a same record format, said record format comprising record fields and an ordering among said record fields, each record field of said record fields belonging to a data type, wherein no record of said body of data records conforms to XML, wherein the method comprises:

generating a target XML schema document that includes declarations that both describe the record format and describe said XML schema of XML instances to which to convert said body of data records;

for each record field of said record fields, the declarations describe the respective data type of the record field and the order of the record field in said ordering among the record fields;

based on the body of data records and the XML schema, generating an XML instance that conforms to the XML schema;

wherein the method is performed by one or more computing devices.

2. The method of claim 1, wherein the body of data records is a flat file in a delimited format.

3. The method of claim 1, wherein the body of data records is a flat file in a fixed-length format.

4. The method of claim 1, wherein the body of data records is a flat file in ASCII text.

5. The method of claim 1, wherein the XML instance is a Java instance.

6. The method of claim 1, wherein the XML instance is a non-Java compatible instance.

7. The method of claim 1, wherein the XML schema comprises container definitions.

8. The method of claim 1, further comprising generating a default XML instance and then populating the default XML instance with data.

9. The method of claim 1, further comprising generating an XML schema with parsing information.

10. The method of claim 1, wherein the XML schema comprises contained objects.

11. The method of claim 1, wherein the XML schema comprises control attributes, wherein the control attributes indicate how to parse said body of data records.

12. The method of claim 11, wherein the generating of the XML instance comprises:

examining the control attributes;

reading a physical record from the body of data records; and

placing the value of the physical record into the XML instance in accordance with the control attributes.

13. A non-transitory computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform a method of converting a body of data records to an XML format, wherein each record of said body of data records conforms to a same record format, said record format comprising record fields and an ordering among said record fields, each record field of said record fields belonging to a data type, wherein no record of said body of data records conforms to XML, wherein the method steps executed by the one or more processors comprise:

generating a target XML schema document that includes declarations that both describe the record format and describe said XML schema of XML instances to which to convert said body of data records;

for each record field of said record fields, the declarations describe the respective data type of the record field and the order of the record field in said ordering among the record fields;

based on the body of data records and the XML schema, generating an XML instance that conforms to the XML schema;

wherein the method is performed by one or more computing devices.

14. The non-transitory computer-readable medium of claim 13, wherein the body of data records is a flat file in a delimited format.

15. The non-transitory computer-readable medium of claim 13, wherein the body of data records is a flat file in a fixed-length format.

16. The non-transitory computer-readable medium of claim 13, wherein the body of data records is a flat file in ASCII text.

17. The non-transitory computer-readable medium of claim 13, wherein the XML instance is a Java instance.

18. The non-transitory computer-readable medium of claim 13, wherein the XML instance is a non-Java compatible instance.

19. The non-transitory computer-readable medium of claim 13, wherein the XML schema comprises container definitions.

20. The non-transitory computer-readable medium of claim 13, further comprising instructions for generating a default XML instance and then populating the default XML instance with data.

21. The non-transitory computer-readable medium of claim 13, further comprising instructions for generating an XML schema with parsing information.

22. The non-transitory computer-readable medium of claim 13, wherein the XML schema comprises contained objects.

23. The non-transitory computer-readable medium of claim 13, wherein the XML schema comprises control attributes, wherein the control attributes indicate how to parse said body of data records.

24. The non-transitory computer-readable medium of claim 23, wherein the instructions for generating of the XML instance comprises:

examining the control attributes;

reading a physical record from the body of data records; and

placing the value of the physical record into the XML instance in accordance with the control attributes.