System and method for using an XML file to control XML to entity/relationship transformation

• US 20050165724A1
• Filed: 07/12/2004
• Published: 07/28/2005
• Est. Priority Date: 07/11/2003
• Status: Abandoned Application

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.), Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: West, William John
• Application Number:
  US10/890,563
• Publication Number:
  US 20050165724A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

A system and method for transforming output of a data modeler to a repository storage form is provided. A control file includes a selection of data to be transformed, mapping of object names and object content. The control file is optionally converted into internal data structure for easier lookup. A stream of data output from a data modeler is scanned and parsed and built into a repository storage form, for example, relational table form, using the control file, for instance, the converted internal data structure.

Claims

1. A method for transforming output of a data modeler to a repository storage form, comprising:

receiving a stream of data output from a data modeler;

receiving a control file associated with the stream of data;

converting the control file into internal structure;

parsing the stream of data to determine one or more of elements, attributes, associations, and relationships in the stream of data by referencing the internal structure; and

building a repository storage form from the parsed stream of data.

2. The method of claim 1, wherein the parsing the stream of data further includes:

invoking a plurality of events for handling events in the stream of data.

3. The method of claim 2, wherein the plurality of events includes at least one of start document event, start element event, characters event, end element event and end document event.

4. The method of claim 1, wherein the control file includes a declaration mapping of object name from the data modeler to a table name in the repository storage form.

5. The method of claim 1, wherein the control file includes a declaration mapping of one or more properties from the data modeler to one or more properties in the repository storage form.

6. The method of claim 1, wherein the control file includes a declaration of mapping of property values.

7. The method of claim 1, wherein the control file includes a declaration of one or more relationships between objects of the data modeler.

8. The method of claim 1, wherein the control file is in XML format.

9. The method of claim 1, wherein the stream of data output from a data modeler is in XML format.

10. A system for transforming output of a data modeler to a repository storage form, comprising:

a scanner operable to scan a stream of data output from a source system;

a control file comprising at least one of a declaration mapping one or more source objects to one or more target objects in the stream of data, a declaration mapping one or more source object properties to one or more target object properties in the stream of data, and a declaration of one or more relationships between objects of the data modeler;

a first module operable to recognize one or more objects from the stream of data output from a source system using the control file;

a second module operable to recognize one or more properties of the one or more objects using the control file; and

a third module operable to recognize one or more relationships between the objects using the control file.

11. The system of claim 10, wherein the first module, the second module, and the third module are functional components of the scanner.

12. The system of claim 10, wherein the declaration mapping source object to target object further include one or more of alternatives, compositions, decompositions, and rules.

13. The system of claim 10, wherein the declaration of one or more relationships between objects of the data modeler further includes one or more of containment of one object in another, ID as content or attribute, or siblings from object decomposition.

14. The system of claim 10, further including a plurality of events invoked as the scanner parses the stream of data output.

15. The system of claim 10, wherein the control file is in XML format.

16. The system of claim 10, wherein the stream of data output is in XML format.

17. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform a method for transforming output of a data modeler to a repository storage form, comprising:

receiving a stream of data output from a data modeler;

receiving a control file associated with the stream of data;

converting the control file into internal structure;

parsing the stream of data to determine one or more of elements, attributes, associations, and relationships in the stream of data by referencing the internal structure; and

building a repository storage form from the parsed stream of data.

18. The program storage device of claim 17, wherein the parsing the stream of data further includes:

invoking a plurality of events for handling events in the stream of data.

19. The program storage device of claim 17, wherein the plurality of events includes at least one of start document event, start element event, characters event, end element event and end document event.

20. The program storage device of claim 17, wherein the control file includes a declaration mapping of object name from the data modeler to a table name in the repository storage form.

21. The program storage device of claim 17, wherein the control file includes a declaration mapping of one or more properties from the data modeler to one or more properties in the repository storage form.

22. The program storage device of claim 17, wherein the control file includes a declaration of mapping of property values.

23. The program storage device of claim 17, wherein the control file includes a declaration of one or more relationships between objects of the data modeler.

24. The program storage device of claim 17, wherein the control file is in XML format.

25. The program storage device of claim 17, wherein the stream of data output from a data modeler is in XML format.

26. A method for transforming output of a data modeler to a repository storage form, comprising:

receiving a stream of data output from a data modeler;

receiving a control file, the control file including at least information about one or more objects to be transformed;

comparing an outer element in the stream of data and an outer element in the control file to determine that the control file is associated with the stream of data;

converting the control file into internal data structure, the internal data structure comprising one or more objects to convert, one or more attributes corresponding to the one or more objects, one or more relationships between the one or more objects, or one or more rules associated with the one or more objects, or combinations thereof;

parsing the stream of data output from a data modeler; and

transforming the parsed stream of data into repository storage form using the internal data structure.