Distributed extract, transfer, and load (ETL) computer method
First Claim
1. A method for delivering information within a computing environment, comprising:
- a) extracting information from an information source;
b) transforming the extracted information;
c) wrapping the transformed information into a message envelope having a standard format;
d) routing the message envelope to at least one information target;
e) unwrapping the message envelope to reveal the information received;
f) mapping the received information to a format required by the information target;
g) transforming the received information; and
h) loading the received information into the information target,wherein the extracting, transforming, and wrapping steps (a)–
(c), respectively, are isolated from the routing step (d) such that the extracting, transforming, and wrapping steps may bc executed simultaneously for a plurality of information sources distributed across the computing environment to produce a plurality of message envelopes and wherein the routing, unwrapping, mapping, transforming, and loading steps (d)–
(h), respectively, are repeated for each of the plurality of message envelopes.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention is a distributed extract, transform and load (ETL) method for delivering information within a computing environment, comprising extracting information from an information source and transforming the extracted information. The transformed information is isolated by wrapping the transformed information into a message envelope having a standard format. The message envelope is routed to at least one information target, unwrapped to reveal the received information, preferably transformed again, and loaded into the information target. The extraction, transformation, and adaptation steps on the source side are isolated from the routing step such that the extraction, transformation, and adaptation steps on the source side may be executed simultaneously for a plurality of information sources distributed across the computing environment to produce a plurality of message envelopes. The routing, unwrapping, mapping, transformation, and loading steps on the target side are repeated for each of the plurality of message envelopes.
-
Citations
27 Claims
-
1. A method for delivering information within a computing environment, comprising:
-
a) extracting information from an information source; b) transforming the extracted information; c) wrapping the transformed information into a message envelope having a standard format; d) routing the message envelope to at least one information target; e) unwrapping the message envelope to reveal the information received; f) mapping the received information to a format required by the information target; g) transforming the received information; and h) loading the received information into the information target, wherein the extracting, transforming, and wrapping steps (a)–
(c), respectively, are isolated from the routing step (d) such that the extracting, transforming, and wrapping steps may bc executed simultaneously for a plurality of information sources distributed across the computing environment to produce a plurality of message envelopes and wherein the routing, unwrapping, mapping, transforming, and loading steps (d)–
(h), respectively, are repeated for each of the plurality of message envelopes.- View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A computer system for delivering information within a computing environment, comprising a method for:
-
a) extracting information from an information source; b) transforming the extracted information; c) isolating the transformed information by wrapping the transformed information into a message envelope having a standard format; d) routing the message envelope to at least one information target; e) unwrapping the message envelope to reveal the transformed information; f) mapping the received information to a format required by the information target; g) transforming the received information; and h) loading the transformed information into the information target;
wherein the routing step occurs at a different resource than the extracting, the transforming, and the loading steps (a)–
(c) such that the extracting, transforming, and wrapping steps may be executed simultaneously for a plurality of information sources distributed across the computing environment to produce a plurality of message envelopes and wherein the routing, unwrapping, transforming and loading steps (d)–
(h) are repeated for each of each of the plurality of message envelopes. - View Dependent Claims (24, 25, 26, 27)
-
Specification