System and method for data manipulation

• US 20060200439A1
• Filed: 05/23/2005
• Published: 09/07/2006
• Est. Priority Date: 03/07/2005
• Status: Active Grant

• Current Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Bhatia, Rishi, Srinivas, Davanum, Tomaszewski, John M., Kittredge, Robert B., Schulze, Matthew J.
• Granted Patent: US 7,840,895 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

In one embodiment of the invention, a system for data manipulation includes a mapper module operable to receive a first data format of a source file, receive a second data format of a target file, and automatically generate a script to represent a movement of data from the source file to the target file. A server is operable to execute the script, a first interface module is coupled to the source file and is operable to load the data in accordance with the script, and a second interface module is coupled to the target file and is operable to store the data in accordance with the script.

Claims

1. A system for data manipulation, comprising:

a mapper module operable to;

receive a first data format of a source file;

receive a second data format of a target file;

automatically generate a script to represent a movement of data from the source file to the target file;

a server operable to execute the script;

a first interface module coupled to the source file and operable to load the data in accordance with the script; and

a second interface module coupled to the target file and operable to store the data in accordance with the script.

2. The system of claim 1, further comprising a script manager operable to schedule the script for execution by the server.

3. The system of claim 1, wherein the mapper module is operable to scan the first data format from the source file.

4. The system of claim 1, wherein the mapper module comprises a graphical user interface and is further operable to receive the first data format from a user via the graphical user interface.

5. The system of claim 1, wherein each of the first and second data formats is selected from the group consisting of an XML format, a database format, and a flat file format.

6. The system of claim 1, wherein the mapper module comprises a graphical user interface and is further operable to receive mappings from a user via the graphical user interface to represent a desired movement of data from the source file to the target file.

7. The system of claim 6, wherein the mapper is further operable to convert the mappings into the script.

8. The system of claim 1, wherein the server is further operable to transform the data from the first format to the second format. in accordance with the script.

9. The system of claim 1, further comprising an internal database operable to store the scripts.

10. The system of claim 1, wherein the first and second interfaces are further operable to repeat load and store steps, respectively.

11. A method for data manipulation, comprising:

receiving a first data format of a source file;

receiving a second data format of a target file;

automatically generating a script to represent a movement of data from the source file to the target file;

executing the script;

loading the data in accordance with the script; and

storing the data in accordance with the script.

12. The method of claim 11, further comprising scheduling the script for execution by the server.

13. The method of claim 11, wherein receiving the first data format of the source file comprises scanning the first data format from the source file.

14. The method of claim 11, wherein receiving the first data format of the source file comprises receiving the first data format from a user via a graphical user interface.

15. The method of claim 11, wherein each of the first and second data formats is selected from the group consisting of an XML format, a database format, and a flat file format.

16. The method of claim 11, further comprising receiving mappings from a user via a graphical user interface to represent a desired movement of data from the source file to the target file.

17. The method of claim 16, further comprising converting the mappings into the script.

18. The method of claim 11, wherein the server is further operable to transform the data from the first format to the second format. in accordance with the script.

19. The method of claim 11, further comprising storing the script in an internal database.

20. The method of claim 11, further comprising repeating the loading and storing steps.