US 6,795,868 B1 · System and method for event-driven data transformation

Abstract

A system and method is described for event-driven data transformation. Generally, the system and method is directed to a transformation engine that iterates through one or more data sources, transforms data received from the data sources, and stores the output to one or more data targets. More specifically, the transformation engine is driven by executing specified event actions upon occurrence of specified triggering events. Thus, flexible, adaptable, highly tailored transformations can be implemented without incurring the often substantial expense of developing customized point-to-point solutions from scratch. The present invention supports one-to-one, mappings, many-to-one mappings, one-to-many mappings, and many-to-many mappings. In addition, the present invention supports both hierarchical and flat data sources and targets.

Claims49

Dependent claims

A method for data transformation comprising the steps of:

defining a data source comprising one or more data structures referred to collectively as source structures;
defining a data target comprising one or more data structures referred to collectively as target structures;
defining a data transformation map relating one or more source structures to one or more target structures;
specifying one or more event actions, each with an associated triggering event, wherein at least one of the specified event actions comprises:
retrieving one or more source structures from the data source,
transforming said one or more source structures in a manner specified by the data transformation map, referred to as transformed source data, and
storing said transformed source data in one or more target structures as specified by the data transformation map;
iterating through the data source and detecting occurrence of triggering events;
and
executing said one or more event actions upon occurrence of the respective associated triggering events.

7 more elements

A system for data transformation, comprising:

one or more read spokes, each read spoke configured to connect to one or more data sources, wherein each data source has one or more data structures referred to collectively as source structures;
one or more write spokes, each write spoke configured to connect to one or more data targets, wherein each data target has one or more data structures referred to collectively as target structures;
and
a transformation engine operatively coupled to the one or more read spokes for retrieving data from the one or more data sources, and coupled to the one or more write spokes for storing data in the one or more data targets, comprising:
a data transformation map that relates one or more source structures to one or more target structures;
an event list, comprising one or more event actions, each with a corresponding triggering event,
wherein the transformation engine is configured to:
iterate through the data sources and detect occurrence of triggering events, and
in response to the detection of triggering events, execute the respective one or more event actions from the event action list.

6 more elements

Dependencies are inferred from the claim text.

System and method for event-driven data transformation

Life of this patent

System and method for event-driven data transformation

Life of this patent

Abstract

Claims49