Patent ID: 6714979
Filing Date: 2004-03-30
Classification: G06F,G06Q,H04L,H04M,Y10S

Abstract:
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.