US 7,321,939 B1 | ||
Enhanced distributed extract, transform and load (ETL) computer method | ||
Duane L. Porter, Blue Springs, Mo. (US) | ||
Assigned to Embarq Holdings Company LLC, Overland Park, Kans. (US) | ||
Filed on Jun. 27, 2003, as Appl. No. 10/607,788. | ||
Int. Cl. G06F 15/173 (2006.01) |
U.S. Cl. 709—238 [709/217; 709/226; 709/229] | 15 Claims |
1. A method for delivering information to information targets within a computing environment having multiple platforms, wherein
each of the multiple platforms is an information system accessing the remainder of the computing environment through a different
router, comprising:
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) delivering the message envelope to a router on a platform;
e1) where the message envelope is targeted to an information target on the same platform as the router, routing the message
envelope to at least one information target on the same platform;
e2) where the message envelope is targeted to an information target on a different platform than the router, routing the message
envelope to a second router acting as a router broker; the router broker then routing the message envelope to at least a third
router located on the platform with an information target; the third router routing the message envelope to at least one information
target on its platform;
(f) unwrapping the message envelope to reveal the transformed information; and loading the transformed information into the
information target,
wherein the extraction, transformation, and isolating steps (a)-(c), respectively, are isolated from the routing steps (e)
such that the extraction, transformation, and isolating 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 subsequent
steps are repeated for each of the plurality of message envelopes.
|