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
OG exemplary drawing
 
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.