Method and system for business to business data interchange using XML

• US 6,601,071 B1
• Filed: 04/14/2000
• Issued: 07/29/2003
• Est. Priority Date: 08/04/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sharma, Vivek, Bowker, Michael, Yappert, Craig B.
• Primary Examiner(s): Corrielus, Jean M.
• Assistant Examiner(s): Liang, Gwen
• Application Number:
  US09/550,300
• Time in Patent Office: 1,201 Days
• Field of Search: 703/22, 703/13, 707/10, 707/501.1, 707/513, 707/102, 707/100, 707/104.1
• US Class Current: 715/234
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system allows exchange of information by converting it to/from proprietary formats from/to XML. An XML import tool may be used to import data from an XML file into a target repository by receiving user input for selecting data structures within the target repository, for selecting set of fields that belong to the selected set of data structures, and for mapping fields in the selected set of fields to tags associated with data within the XML file. A set of commands is generated based on the user inputs for populating the one or more fields that are mapped to tags with the data in the XML file. The set of commands cause the one or more fields that are mapped to tags to be populated with the data in the XML file.

Claims

1. A computer implemented method for importing data from an XML file into a target repository, the method comprising the steps of:

receiving a first set of user input that selects a selected set of data structures within the target repository;

receiving a second set of user input that selects a selected set of fields that belong to said selected set of data structures;

receiving a third set of user input that maps one or more fields in said selected set of fields to tags associated with data within said XML file;

generating a set of commands based on said first, second and third sets of user input, wherein said set of commands includes commands for populating the one or more fields that are mapped to tags with the data in the XML file that is associated with the tags; and

issuing said set of commands to cause the one or more fields that are mapped to tags to be populated with the data in the XML file that is associated with the tags.

2. The method of claim 1 wherein the step of receiving a third set of user input includes receiving user input that maps a plurality of distinct tags within a single record of said XML file to a single field within a particular data structure.

3. The method of claim 1 wherein:

the target repository is a database; and

the step of receiving a first set of user input that selects a selected set of data structures within the target repository includes receiving user input that selects tables within said database.

4. The method of claim 3 wherein the step of receiving a second set of user input that selects a selected set of fields that belong to said selected set of data structures includes receiving user input that selects columns within said tables.

5. The method of claim 1 further comprising the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to sequences within said target repository; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to sequences with values dictated by the sequences.

6. The method of claim 1 further comprising the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to foreign key fields within said target repository; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to foreign key fields with values dictated by the foreign key fields.

7. The method of claim 1 further comprising the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to user-specified text values; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to user-specified text values with said user-specified text values.

8. The method of claim 1 further comprising the step of displaying a screen that includes controls for receiving said third set of user input, said screen including controls for displaying data that identifies selected fields and corresponding controls for displaying data that identifies XML tags to be mapped to said selected fields.

9. The method of claim 1 further comprising the step of, prior to receiving said third set of user input, automatically establishing an initial mapping between one or more fields and one or more XML tags based on a matching operation performed between data associated with said one or more fields and data associated with said one or more XML tags.

10. The method of claim 9 wherein said matching operation is performed between identifiers of said one or more fields and identifiers for said one or more XML tags.

11. The method of claim 5 further comprising the step of, prior to receiving said fourth set of user input, automatically establishing an initial mapping between one or more fields and one or more sequences based on a matching operation performed between data associated with said one or more fields and data associated with said one or more sequences.

12. The method of claim 6 further comprising the step of, prior to receiving said fourth set of user input, automatically establishing an initial mapping between one or more fields and one or more foreign key fields based on a matching operation performed between data associated with said one or more fields and data associated with said one or more foreign key fields.

13. The method of claim 1 further comprising the step of generating said XML file from a source repository that has a schema that is different from said target repository.

14. The method of claim 1 wherein:

the method further comprises the step of receiving a fourth set of user input that establishes an order to said selected set of data structures; and

the step of generating a set of commands includes generating commands for populating the one or more fields of the selected set of data structures in a sequence based on said order.

15. A computer-readable medium bearing instructions for importing data from an XML file into a target repository, the instructions comprising instructions for performing the steps of:

receiving a first set of user input that selects a selected set of data structures within the target repository;

receiving a second set of user input that selects a selected set of fields that belong to said selected set of data structures;

receiving a third set of user input that maps one or more fields in said selected set of fields to tags associated with data within said XML file;

generating a set of commands based on said first, second and third sets of user input, wherein said set of commands includes commands for populating the one or more fields that are mapped to tags with the data in the XML file that is associated with the tags; and

issuing said set of commands to cause the one or more fields that are mapped to tags to be populated with the data in the XML file that is associated with the tags.

16. The computer-readable medium of claim 15 wherein the step of receiving a third set of user input includes receiving user input that maps a plurality of distinct tags within a single record of said XML file to a single field within a particular data structure.

17. The computer-readable medium of claim 15 further comprising instructions for performing the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to user-specified text values; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to user-specified text values with said user-specified text values.

18. The computer-readable medium of claim 15 wherein:

the target repository is a database; and

the step of receiving a first set of user input that selects a selected set of data structures within the target repository includes receiving user input that selects tables within said database.

19. The computer-readable medium of claim 18 wherein the step of receiving a second set of user input that selects a selected set of fields that belong to said selected set of data structures includes receiving user input that selects columns within said tables.

20. The computer-readable medium of claim 15 further comprising instructions for performing the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to sequences within said target repository; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to sequences with values dictated by the sequences.

21. The computer-readable medium of claim 15 further comprising instructions for performing the steps of:

receiving a fourth set of user input that maps one or more fields in said selected set of fields to foreign key fields within said target repository; and

wherein the step of generating a set of commands includes generating commands for populating the one or more fields that are mapped to foreign key fields with values dictated by the foreign key fields.

22. The computer-readable medium of claim 15 further comprising instructions for performing the step of displaying a screen that includes controls for receiving said third set of user input, said screen including controls for displaying data that identifies selected fields and corresponding controls for displaying data that identifies XML tags to be mapped to said selected fields.

23. The computer-readable medium of claim 15 further comprising instructions for performing the step of, prior to receiving said third set of user input, automatically establishing an initial mapping between one or more fields and one or more XML tags based on a matching operation performed between data associated with said one or more fields and data associated with said one or more XML tags.

24. The computer-readable medium of claim 23 wherein said matching operation is performed between identifiers of said one or more fields and identifiers for said one or more XML tags.

25. The computer-readable medium of claim 20 further comprising instructions for performing the step of, prior to receiving said fourth set of user input, automatically establishing an initial mapping between one or more fields and one or more sequences based on a matching operation performed between data associated with said one or more fields and data associated with said one or more sequences.

26. The computer-readable medium of claim 21 further comprising instructions for performing the step of, prior to receiving said fourth set of user input, automatically establishing an initial mapping between one or more fields and one or more foreign key fields based on a matching operation performed between data associated with said one or more fields and data associated with said one or more foreign key fields.

27. The computer-readable medium of claim 15 further comprising instructions for performing the step of generating said XML file from a source repository that has a schema that is different from said target repository.

28. The computer-readable medium of claim 15 wherein:

the computer-readable medium further comprises instructions for performing the step of receiving a fourth set of user input that establishes an order to said selected set of data structures; and

the step of generating a set of commands includes generating commands for populating the one or more fields of the selected set of data structures in a sequence based on said order.