IP Library Granted Patent US 8,024,368
Granted Patent B2
US 8,024,368 · App. 11/297,172 · Granted Sep 20, 2011

Generating XML instances from flat files

Assignee: Oracle International Corporation
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,024,368
App. No.
11/297,172
Granted
Sep 20, 2011
Kind
B2
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 (38)

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.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 7, 2005
From: ROY, INDRONIEL DEB; YOSHIDA, SHINJI
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 017340/0737 →
Continuity (1)
Related Publication 20070083538A1 · Apr 12, 2007