| System and method for providing data manipulation as a web service -> Monitor Keywords |
|
|
 
System and method for providing data manipulation as a web serviceRelated Patent Categories: Data Processing: Presentation Processing Of Document, Operator Interface Processing, And Screen Saver Display Processing, Presentation Processing Of Document, FormSystem and method for providing data manipulation as a web service description/claimsThe Patent Description & Claims data below is from USPTO Patent Application 20060200753, System and method for providing data manipulation as a web service. Brief Patent Description - Full Patent Description - Patent Application Claims
RELATED APPLICATIONS [0001] This application claims the priority under 35 U.S.C. .sctn.119 of provisional application Ser. No. 60/659,264 filed Mar. 7, 2005, which is incorporated by reference. TECHNICAL FIELD OF THE INVENTION [0002] This disclosure relates generally to the field of data processing and, more particularly, to a system and method for manipulating data. BACKGROUND OF THE INVENTION [0003] In the rapidly-evolving competitive marketplace, data is among an organization's most valuable assets. Business success demands access to data and information, and the ability to quickly and seamlessly distribute data throughout the enterprise to support business process requirements. Organizations must extract, refine, manipulate, transform, integrate and distribute data in formats suitable for strategic decision-making. This poses a unique challenge in heterogeneous environments, where data is housed on disparate platforms in any number of different formats and used in many different contexts. SUMMARY OF THE INVENTION [0004] In accordance with the present invention, the disadvantages and problems associated with data processing have been substantially reduced or eliminated. In particular, methods and systems for transforming data are disclosed that provide a flexible, robust manner for providing data transformation functionality as a web service. [0005] In accordance with one embodiment of the present invention, a method of transforming data includes receiving information defining a transformation of an input data object to an output data object and generating, based on the received information, a script operable when executed to implement the defined transformation. The script is then stored. The method also includes receiving a service request from a remote client that requests a particular transformation and identifies a request data object and identifying a script that performs the requested transformation. Additionally, the method includes generating a response data object by executing the identified script on the request data object and transmitting the response data object to the remote client. [0006] In accordance with another embodiment of the present invention, a method of transforming data includes receiving information defining a transformation of an input data object to an output data object and generating, based on the received information, a script operable when executed to implement the defined transformation based on the received information. The script is then stored. The method also includes receiving, from a remote client, a service request that requests the defined transformation and identifies a request data object and a requested execution time. Additionally, the method includes generating a response data object by executing the script on the request data object at a time determined based on the requested execution time and storing the response data object in memory. [0007] Some embodiments of the present invention provide numerous technical advantages. Other embodiments may realize some, none, or all of these advantages. For example, particular embodiments may provide a data extraction, transformation, and load tool that features a flexible, easy-to-use, and comprehensive application-development environment. Particular embodiments may also reduce and/or eliminate the programming complexities of extracting, transforming, and loading data from disparate sources and targets and eliminate a need for users to learn XML programming or database-specific API's. Embodiments of the invention may facilitate seamless extraction and integration of data from and to AS/400, DB2, DB2 MVS, DBASE, flat files, COBOL files, Lotus Notes, Microsoft ODBC, Microsoft SQL Server, Oracle, Sybase, Microsoft Access, CA Ingres and UDB. [0008] In particular embodiments, some features provide the ability to process and output a wide variety of different types of input files and output files with significant flexibility in how the data may be transformed. As one example, particular embodiments of the described system may be capable of accepting input files in an XML format, transforming the data, and outputting the transformed data in one or more database tables or flat files. Similarly, particular embodiments may be capable of accepting input database tables or flat files, transforming the data contained in these files, and outputting the transformed data in one more XML files. As another example, particular embodiments of the described system may be capable of reading and transforming documents having a variable number of instances of a particular data object. As a result, the described system and methods provide a powerful, robust data transformation solution [0009] Other technical advantages of the present invention will be readily apparent to one skilled in the art from the following figures, descriptions, and claims. Moreover, while specific advantages have been enumerated above, various embodiments may include all, some, or none of the enumerated advantages. BRIEF DESCRIPTION OF THE DRAWINGS [0010] FIG. 1 is a block diagram illustrating a system for data manipulation according to one embodiment of the invention; [0011] FIG. 2 is a block diagram illustrating a mapper for data manipulation according to one embodiment of the invention; [0012] FIGS. 3A and 3B are example screen shots illustrating some functionality of an XML Object Definition of the mapper of FIG. 2; [0013] FIG. 4 is an example screen shot illustrating some functionality of an example Mapping module of the mapper of FIG. 2; [0014] FIGS. 5A-5C illustrate an example script generated by a particular embodiment of the data manipulation system; [0015] FIG. 6 is a block diagram illustrating an XML Interface for data manipulation according to one embodiment of the invention; [0016] FIG. 7A is a flowchart illustrating an example method of executing a script to perform a first transformation of data from a database source file to an XML target file according to one embodiment of the invention; [0017] FIG. 7B is an example output of the example method of FIG. 7A according to one embodiment of the invention; [0018] FIG. 8 is a flowchart illustrating an example method of executing a script to perform a second transformation of data from an XML source file to a database target file according to one embodiment of the invention; [0019] FIG. 9 shows a particular embodiment of a data transformation system capable of providing data transformation functionality to remote clients as a web service; and Continue reading about System and method for providing data manipulation as a web service... Full patent description for System and method for providing data manipulation as a web service Brief Patent Description - Full Patent Description - Patent Application Claims Click on the above for other options relating to this System and method for providing data manipulation as a web service patent application. ###
 How KEYWORD MONITOR works... a FREE service from FreshPatents1. Sign up (takes 30 seconds). 2. Fill in the keywords to be monitored. 3. Each week you receive an email with patent applications related to your keywords. Start now! - Receive info on patent apps like System and method for providing data manipulation as a web service or other areas of interest. ### Previous Patent Application: Method and system for laying out paginated content for viewing Next Patent Application: Systems and methods for storing personal information, automatically filling out forms, and sharing information with a data recipient Industry Class: Data processing: presentation processing of document ### FreshPatents.com Support Thank you for viewing the System and method for providing data manipulation as a web service patent info. IP-related news and info Results in 0.1071 seconds Other interesting Feshpatents.com categories: Accenture , Agouron Pharmaceuticals , Amgen , AT&T , Bausch & Lomb , Callaway Golf 174 |
PATENT INFO |
|
