Patent US6714979B1 successfully refreshed from Google Patents.
US6714979B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data warehousing infrastructure for web based reporting tool
Assignee: Verizon Patent and Licensing Inc
•
Filing: 1998-09-24
•
Granted: 2004-03-30
•
Expires: 2018-09-24
Abstract
Abstract A data warehousing infrastructure for telecommunications priced call detail data is integrated with a Web/Internet based reporting system providing a common GUI enabling the requesting, customizing, scheduling and viewing of various types of priced call detail data reports. Such an infrastructure performs an extraction process to obtain only those billing detail records of entitled customers, and a harvesting process for transforming the billing records into a star schema format for storage in one or more operational data storage devices. The system is integrated with a database server supporting expedient and accurate access to the customer's telecommunications priced call detail data for priced call detail data report generation.
Inventors
- 👤 Andre R. Brandt
- 👤 Barbara Frueh
- 👤 Sajan J. Pillai
- 👤 Karl Rehder
- 👤 Donald J. Shearer
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 22:50
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/0703; G06F11/0706; G06F11/0709; G06F11/0766; G06F11/0769; G06F11/0781; G06F16/00; G06F16/90; G06F16/95; G06F16/958; G06F16/972; G06Q; G06Q10/00; G06Q10/10; G06Q30/00; G06Q30/02; G06Q30/06; H; H04; H04L; H04L12/00; H04L12/02; H04L12/14; H04L12/1428; H04L41/00; H04L41/18; H04L41/22; H04L63/00; H04L63/02; H04L63/0209; H04L63/0227; H04L63/0236; H04L63/0281; H04L63/04; H04L63/0428; H04L63/0464; H04L63/16; H04L63/162; H04L63/166; H04L65/00; H04L65/10; H04L65/1045; H04L65/1063; H04L65/1066; H04L65/1069; H04L67/00; H04L67/01; H04L67/02; H04L67/025; H04L67/14; H04L67/142; H04L67/2866; H04L67/30; H04L67/306; H04L67/50; H04L67/56; H04L67/564; H04L67/565; H04L9/00; H04L9/40; H04M; H04M15/00; H04M15/41; H04M15/43; H04M15/44; H04M15/49; H04M15/51; H04M15/58; H04M15/70; H04M15/745; H04M15/80; H04M15/8044; H04M15/83; H04M15/835; H04M15/8351; H04M15/84; G06F11/30; G06F11/34; G06F11/3466; G06F11/3495; G06F2221/00; G06F2221/21; G06F2221/2149; H04L41/06; H04L41/28; H04L63/08; H04L63/0815; H04L63/168; H04L69/00; H04L69/08; H04L69/30; H04L69/32; H04L69/322; H04L69/329; H04M2215/00; H04M2215/01; H04M2215/0104; H04M2215/0108; H04M2215/0152; H04M2215/0164; H04M2215/0168; H04M2215/0176; H04M2215/018; H04M2215/0188; H04M2215/42; H04M2215/46; H04M2215/54; H04M2215/74; H04M2215/745; H04M2215/81; H04M2215/8104; H04M2215/8108; H04M2215/8129; H04M2215/82; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99939
Claims Analysis
Total Claims: 40
Claim 1
Independent Claim
240 words
A Web/Internet based reporting system for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application, said system comprising: a data warehousing infrastructure comprising: process for generating a current customer list on a daily basis comprising customers entitled to receive daily telecommunications call detail data; device for receiving customer's raw telecommunications call detail data records from one or more telecommunications network switch mechanisms, and extracting certain call detail records for predetermined customers; harvest device for receiving said extracted call detail data records and replacing a call detail data item therein with a corresponding dimension key found in an associated dimension build table for that call detail item; and, device for generating an output fact table comprising customer records having unique key structures for enabling consolidated storage of specific customer call detail data; at least one secure server for managing client sessions over the Internet, the secure server supporting secure communication of customer request messages between the browser application client and the secure server; and, device for receiving said customer requests from said secure server and generating corresponding database queries implementing said dimension keys for application against said output fact table to obtain a specific call customer's call detail data, said call detail data being transmitted back to said client web browser via said secure server; whereby expedient and updated web/Internet-based access to said customer's daily call detail data is assured.
Claim 2
Dependent Claim
240 words
A Web/Internet based reporting system for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application, said system comprising: a data warehousing infrastructure comprising: process for generating a current customer list on a daily basis comprising customers entitled to receive daily telecommunications call detail data; device for receiving customer's raw telecommunications call detail data records from one or more telecommunications network switch mechanisms, and extracting certain call detail records for predetermined customers; harvest device for receiving said extracted call detail data records and replacing a call detail data item therein with a corresponding dimension key found in an associated dimension build table for that call detail item; and, device for generating an output fact table comprising customer records having unique key structures for enabling consolidated storage of specific customer call detail data; at least one secure server for managing client sessions over the Internet, the secure server supporting secure communication of customer request messages between the browser application client and the secure server; and, device for receiving said customer requests from said secure server and generating corresponding database queries implementing said dimension keys for application against said output fact table to obtain a specific call customer's call detail data, said call detail data being transmitted back to said client web browser via said secure server; whereby expedient and updated web/Internet-based access to said customer's daily call detail data is assured.
Claim 3
Dependent Claim
41 words
The system as claimed in claim 1 , wherein said dimension build tables are continuously generated and updated with key structures for each extracted telecommunications call detail data record having a call detail item in which no associating match is found.
Claim 4
Dependent Claim
50 words
The system as claimed in claim 1 , wherein said harvest device applies look-ups to each of said one or more dimension build tables having said unique dimension keys, said harvest device further replacing a call detail data item therein with a corresponding key structure when a match is found.
Claim 5
Dependent Claim
45 words
The system as claimed in claim 2 , wherein a dimension table includes a dimension key associated with a particular billing/customer, said system further comprising process for updating said billing/customer dimension table prior to inputting a received modified call detail record to said harvest device.
Claim 6
Dependent Claim
49 words
The system as claimed in claim 3 , wherein said updating of said billing/customer dimension includes process for comparing said current customer list with a customer list from a prior point in time, wherein new customers in said current daily list is added to said billing/customer dimension build table.
Claim 7
Dependent Claim
51 words
The system as claimed in claim 3 , further including a device for organizing said fact table and dimension tables in one or more operational data storage devices, said operational data storage devices comprising a database server for facilitating expedient retrieval of customer's daily call detail data upon received customer requests.
Claim 8
Dependent Claim
47 words
The system as claimed in claim 3 , further including a tranlation process for converting call detail data in said fact table from a first character format to a second character format, and transferring said fact table data to said operational data storage devices via ftp protocol.
Claim 9
Dependent Claim
26 words
The system as claimed in claim 1 , wherein said output fact table and said dimension build tables are organized according to a star schema structure.
Claim 10
Dependent Claim
22 words
The system as claimed in claim 2 , wherein said dimension build tables include dimension keys associated with a particular calling area.
Claim 11
Dependent Claim
68 words
The system as claimed in claim 5 , further including dispatch server for communicating with said secure server through a firewall over a second socket connection, the first and second secure sockets forming a secure communications link, said dispatch server enabling forwarding of a report request message and an associated report response message comprising requested call detail data back to the client browser over the secure communications link.
Claim 12
Dependent Claim
61 words
The system as claimed in claim 9 , further including a report manager server for maintaining an inventory of priced call detail reporting items associated with a customer and managing the reporting of daily call-detail data information in accordance with a customer request message, the report manager initiating access to said customer daily call detail data from said operational data stores.
Claim 13
Dependent Claim
30 words
The system as claimed in claim 5 , wherein said data warehousing infrastructure further includes process for totaling each customer's daily call detail data for a predetermined period of time.
Claim 14
Dependent Claim
19 words
The system as claimed in claim 12 , further including process for verifying data harvesting and database load totals.
Claim 15
Dependent Claim
60 words
The system as claimed in claim 12 , wherein said data warehousing infrastructure is further capable of providing output fact table associated with customer's monthly call detail data that has been repriced, said system further including process for reconciling a customer's daily call detail data totals in said operational data storage device with that customer's repriced monthly call detail data.
Claim 16
Dependent Claim
34 words
The system as claimed in claim 14 , wherein said reconciling process includes process for fragmenting blocks of call detail data included in said operational data storage devices with repriced monthly call detail data.
Claim 17
Independent Claim
233 words
A method for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application comprising the steps of: generating a current customer list on a daily basis comprising customers entitled to receive daily telecommunications call detail data; receiving customer's daily raw telecommunications call detail data records from one or more telecommunications network switch mechanisms, and extracting those call detail data records for only those customers entitled to receive said call detail data; receiving said extracted call detail data records and replacing one or more call detail data items therein with a corresponding dimension key found in a dimension build table associated with said call detail item; and, generating an output fact table comprising customer records having said unique key structures for enabling consolidated storage of specific customer call detail data; implementing a secure server to manage client sessions over the Internet, the secure server supporting secure communication of customer request messages between the browser application client and the secure server; and, receiving said customer requests from said secure server and generating corresponding database queries implementing said dimension keys for application against said output fact table to obtain a specific customer's call detail data, said call detail data being transmitted back to said client web browser via said secure server, whereby expedient and updated web/Internet-based access to said customer's daily call detail data is assured.
Claim 18
Independent Claim
233 words
A method for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application comprising the steps of: generating a current customer list on a daily basis comprising customers entitled to receive daily telecommunications call detail data; receiving customer's daily raw telecommunications call detail data records from one or more telecommunications network switch mechanisms, and extracting those call detail data records for only those customers entitled to receive said call detail data; receiving said extracted call detail data records and replacing one or more call detail data items therein with a corresponding dimension key found in a dimension build table associated with said call detail item; and, generating an output fact table comprising customer records having said unique key structures for enabling consolidated storage of specific customer call detail data; implementing a secure server to manage client sessions over the Internet, the secure server supporting secure communication of customer request messages between the browser application client and the secure server; and, receiving said customer requests from said secure server and generating corresponding database queries implementing said dimension keys for application against said output fact table to obtain a specific customer's call detail data, said call detail data being transmitted back to said client web browser via said secure server, whereby expedient and updated web/Internet-based access to said customer's daily call detail data is assured.
Claim 19
Dependent Claim
57 words
The method as claimed in claim 16 , wherein said step of replacing a call detail data item therein with a corresponding dimension key includes implementing a dimension table look-up of the call detail item for a key structure corresponding to said call detail item and replacing said key in said record when a match is found.
Claim 20
Dependent Claim
52 words
The method as claimed in claim 17 , wherein said step of replacing said call detail item with said corresponding dimension key further includes the step of generating a new key to replace said call detail item and providing said new key to said dimension build table when no match is found.
Claim 21
Dependent Claim
42 words
The method as claimed in claim 18 , wherein a dimension table includes a dimension key associated with a particular billing/customer, said method further updating said billing/customer dimension table prior to inputting a received modified call detail record to a harvest device.
Claim 22
Dependent Claim
48 words
The method as claimed in claim 19 , wherein said step of updating said billing/customer dimension includes comparing said current daily customer list with a customer list from an immediate prior day, wherein new customers in said current daily list is added to said billing/customer dimension build table.
Claim 23
Dependent Claim
63 words
The method as claimed in claim 20 , wherein said output fact table is capable of being loaded into storage/retrieval devices, said method further including the step of organizing said fact table and dimension tables in one or more operational data storage devices, said operational data storage devices comprising a database server for retrieving customer's daily call detail data upon received customer requests.
Claim 24
Dependent Claim
46 words
The method as claimed in claim 21 , further including the step of converting call detail data in said fact table from a first character format to a second character format, and transferring said fact table data to said operational data storage devices via ftp protocol.
Claim 25
Dependent Claim
23 words
The method as claimed in claim 21 , wherein said fact table and dimension tables are organized according to a star schema structure.
Claim 26
Dependent Claim
21 words
The method as claimed in claim 23 , wherein a dimension table includes dimension keys associated with a particular calling location.
Claim 27
Dependent Claim
39 words
The method as claimed in claim 24 , further including the step of forwarding a report request message and an associated report response message containing requested call detail data back to the client browser over a secure communications link.
Claim 28
Dependent Claim
55 words
The method as claimed in claim 25 , further including maintaining an inventory of priced call detail reporting items associated with a customer and managing the reporting of daily call-detail data information in accordance with a customer request message, and initiating access to said customer daily call detail data stored in said operational data stores.
Claim 29
Dependent Claim
28 words
The method as claimed in claim 26 , further including the step of totaling one or more call detail data item values for a predetermined period of time.
Claim 30
Dependent Claim
52 words
The method as claimed in claim 26 , further providing an output fact table associated with customer's monthly call detail data that has been repriced, said method further including reconciling a customer's daily call detail item value totals in said operational data storage device with that customer's repriced monthly call detail data.
Claim 31
Dependent Claim
32 words
The method as claimed in claim 28 , wherein said reconciling step includes fragmenting blocks of call detail data included in said operational data storage devices with repriced monthly call detail data.
Claim 32
Dependent Claim
35 words
The method as claimed in claim 26 , further including interfacing with a report manager server for retrieving the customer-specific data from the operational data stores in accordance with a customer identity and report name.
Claim 33
Dependent Claim
26 words
The method as claimed in claim 26 , further including generating a report utilizing the retrieved data and the metadata description of call detail reporting items.
Claim 34
Dependent Claim
196 words
A Web/Internet based reporting system for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application, said system comprising: a data warehousing infrastructure comprising: a traffic component to receive raw telecommunications call detail records from one or more telecommunications switches and to sort the call detail records into billing detail records; a billing system to perform pricing in connection with one or more billing detail records; an extraction component to extract selected customer billing detail records; a harvesting component to transform the selected billing detail records based on a set of business rules into transformed billing detail records; a data store component to store the transformed billing detail records into one or more data marts; at least one secure server for managing client sessions over the Internet, the secure server supporting secure communication of customer requests between the browser application client and the secure server; and, a device for receiving the customer requests from the secure server and generating corresponding database queries to obtain a specific customer's call detail data, the call detail data being transmitted back to said client web browser via the secure server.
Claim 35
Dependent Claim
196 words
A Web/Internet based reporting system for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application, said system comprising: a data warehousing infrastructure comprising: a traffic component to receive raw telecommunications call detail records from one or more telecommunications switches and to sort the call detail records into billing detail records; a billing system to perform pricing in connection with one or more billing detail records; an extraction component to extract selected customer billing detail records; a harvesting component to transform the selected billing detail records based on a set of business rules into transformed billing detail records; a data store component to store the transformed billing detail records into one or more data marts; at least one secure server for managing client sessions over the Internet, the secure server supporting secure communication of customer requests between the browser application client and the secure server; and, a device for receiving the customer requests from the secure server and generating corresponding database queries to obtain a specific customer's call detail data, the call detail data being transmitted back to said client web browser via the secure server.
Claim 36
Dependent Claim
29 words
The system of claim 32 wherein the traffic component comprises a module to convert the raw telecommunications call detail records into a format that is readable by a mainframe.
Claim 37
Dependent Claim
22 words
The system of claim 32 wherein the traffic component comprises a module to determine if records are billable and drops unbillable records.
Claim 38
Dependent Claim
21 words
The system of claim 32 wherein the extraction component comprises a file transfer protocol pull of a list of selected customers.
Claim 39
Dependent Claim
38 words
The system of claim 32 wherein the set of business rules for transforming the selected customer billing detail records comprises a star schema data model which incorporates a central fact table and a plurality of referenced dimension tables.
Claim 40
Dependent Claim
32 words
The system of claim 32 wherein the data warehousing infrastructure comprises a component to provide incremental, daily updates to the transformed billing detail records stored in the one or more data marts.
References Cited (Backward Citations)
US4160129A
Cited
US4345315A
Cited
US4817050A
Cited
US4823373B1
Cited
US4823373A
Cited
US4893248A
Cited
US5475836A
Cited
US5075771A
Cited
US4972504A
Cited
US5490060A
Cited
US5041972A
Cited
US5136707A
Cited
US5228076A
Cited
US5287270A
Cited
US5325290A
Cited
US5313598A
Cited
US5131020A
Cited
US5262760A
Cited
US5555290A
Cited
US5812750A
Cited
US5223699A
Cited
US5245533A
Cited
US5832519A
Cited
US5812654A
Cited
US5734709A
Cited
US5315093A
Cited
US5491779A
Cited
US5537611A
Cited
US5285494A
Cited
US5815080A
Cited
US5452446A
Cited
US5586260A
Cited
US5506893A
Cited
US5361259A
Cited
US5974396A
Cited
US5666481A
Cited
US5327486A
Cited
US5369571A
Cited
US5481542A
Cited
US5953389A
Cited
US5848399A
Cited
US5548726A
Cited
US5483596A
Cited
US5787412A
Cited
US5812533A
Cited
US5533108A
Cited
US5793762A
Cited
US5721913A
Cited
US5694546A
Cited
US5566351A
Cited
US5539734A
Cited
US6161102A
Cited
US5563805A
Cited
US5621727A
Cited
US5742905A
Cited
US5530744A
Cited
US5526257A
Cited
US5778377A
Cited
US5623601A
Cited
US5610915A
Cited
US5551025A
Cited
US5689645A
Cited
US5787160A
Cited
US5630066A
Cited
US5781632A
Cited
US6163597A
Cited
US5982891A
Cited
US5790797A
Cited
US5671354A
Cited
US5696906A
Cited
US5825769A
Cited
US5649182A
Cited
US20010001014A1
Cited
US5699403A
Cited
US5659601A
Cited
US5650994A
Cited
US5802320A
Cited
US5742762A
Cited
US6145001A
Cited
US5692030A
Cited
US5757900A
Cited
US6094655A
Cited
US6154744A
Cited
US5745754A
Cited
US5793964A
Cited
US5974441A
Cited
US5721908A
Cited
US5708780A
Cited
US5883948A
Cited
US5826269A
Cited
US5710882A
Cited
US6115458A
Cited
US6052450A
Cited
US5852812A
Cited
US5825890A
Cited
US5850517A
Cited
US5884032A
Cited
US5692181A
Cited
US6240450B1
Cited
US5966695A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-03-30 | 2007-09-29 | 2008-03-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-03-30 | 2011-09-29 | 2012-03-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-03-30 | 2015-09-29 | 2016-03-30 | $7700.00 | Window Closed / Lapsed |