US7051334B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Distributed extract, transfer, and load (ETL) computer method
Assignee: Sprint Communications Co LP
•
Filing: 2001-04-27
•
Granted: 2006-05-23
•
Expires: 2021-04-27
Abstract
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.
Inventors
- 👤 Duane L. Porter
- 👤 David E. Swanholm
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 07:31
CPC Classifications
H; H04; H04L; H04L12/00; H04L12/66; G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/254; G06F16/27; G06F16/28; G06F16/283
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
152 words
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.
Claim 2
Independent Claim
152 words
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.
Claim 3
Dependent Claim
18 words
The method of claim 1 wherein the information is pulled from the source during the extracting step (a).
Claim 4
Dependent Claim
18 words
The method of claim 1 wherein the information is pushed from the source during the extracting step (a).
Claim 5
Dependent Claim
38 words
The method of claim 1 wherein the information extracted during step (a) comprises content changes to the source information at the time step (a) is performed as compared to the source information at a previous point in time.
Claim 6
Dependent Claim
26 words
The method of claim 1 wherein transforming the extracted information during step (b) further comprising applying one or more business rules to modify the extracted information.
Claim 7
Dependent Claim
28 words
The method of claim 1 wherein the message envelope further comprises an identification of the information source, a content definition identification and the content of the transformed information.
Claim 8
Dependent Claim
21 words
The method of claim 6 wherein the content definition identification is used to retrieve the content definition from a metadata repository.
Claim 9
Dependent Claim
33 words
The method of claim 6 wherein wrapping the message envelope further comprising retrieving content definition from a metadata repository and applying the content definition to the transformed information to produce a message envelope.
Claim 10
Dependent Claim
25 words
The method of claim 6 further comprising placing the message envelope into an inbox queue to a router component for routing according to step (d).
Claim 11
Dependent Claim
26 words
The method of claim 9 wherein the information sources publish the message envelope to the inbox queue and the router component subscribes to the inbox queue.
Claim 12
Dependent Claim
36 words
The method of claim 10 further comprising retrieving the message envelope from the inbox queue, looking up the address of the information target in a cross-reference table, and transmitting the message envelope to the information target.
Claim 13
Dependent Claim
23 words
The method of claim 11 wherein looking up the address of the information target is cross-referenced by the identity of the information source.
Claim 14
Dependent Claim
17 words
The method of claim 12 wherein the cross-reference table resides in local memory within the router component.
Claim 15
Dependent Claim
20 words
The method of claim 11 wherein transmitting the message envelope comprises placing the message envelope into an information target queue.
Claim 16
Dependent Claim
26 words
The method of claim 14 wherein the router component publishes the message envelope to the outbox queue and the information target subscribes to the outbox queue.
Claim 17
Dependent Claim
21 words
The method of claim 15 wherein the message envelope is retrieved from the outbox queue prior to unwrapping the message envelope.
Claim 18
Dependent Claim
33 words
The method of claim 8 wherein unwrapping the message envelope further comprising retrieving content definition from the metadata repository and applying the content definition to the message envelope to reveal the transformed information.
Claim 19
Dependent Claim
22 words
The method of claim 1 further comprising after unwrapping the message envelope, filtering the transformed information prior to loading the transformed information.
Claim 20
Dependent Claim
32 words
The method of claim 1 further comprising after unwrapping the message envelope, aggregating a plurality of transformed information and loading the aggregation of transformed information into the information target as a batch.
Claim 21
Dependent Claim
17 words
The method of claim 1 wherein the information target comprises a data warehouse and a data mart.
Claim 22
Dependent Claim
23 words
The method of claim 1 wherein the method for delivering information is executed on a plurality of computing platforms within the computing environment.
Claim 23
Dependent Claim
17 words
The method of claim 21 wherein the plurality of computing platforms comprise information domains for an enterprise.
Claim 24
Dependent Claim
164 words
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.
Claim 25
Dependent Claim
164 words
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.
Claim 26
Dependent Claim
18 words
The computer system of claim 23 wherein the extracting, transforming, and isolating steps occur at the information source.
Claim 27
Dependent Claim
17 words
The computer system of claim 24 wherein the unwrapping and loading steps occur at the information target.
Claim 28
Dependent Claim
16 words
The computer system of claim 25 wherein the transforming step occurs prior to the isolating step.
Claim 29
Dependent Claim
19 words
The computer system of claim 26 wherein the extracting, transforming, and isolating steps occur prior to the routing step.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2009-05-22 | 2009-11-21 | 2010-05-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2013-05-22 | 2013-11-21 | 2014-05-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2017-05-22 | 2017-11-21 | 2018-05-23 | $7700.00 | Window Closed / Lapsed |