WO2001084385A1 - A telecommunication data warehouse arrangement - Google Patents
A telecommunication data warehouse arrangement Download PDFInfo
- Publication number
- WO2001084385A1 WO2001084385A1 PCT/EP2000/004390 EP0004390W WO0184385A1 WO 2001084385 A1 WO2001084385 A1 WO 2001084385A1 EP 0004390 W EP0004390 W EP 0004390W WO 0184385 A1 WO0184385 A1 WO 0184385A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data warehouse
- data
- network
- telecommunications
- arrangement according
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
Definitions
- This invention relates to switching and operational support systems in the area of general telecommunications, and more particularly, to a new type of telecommunications data warehouse arrangement .
- network elements such as telephony switches, are used to route and switch speech and data signals coming from another part of network. While performing this function the network element also generates a lot of data, which is then used for different purposes e.g. billing the customer for the phone call, billing another operator for the use of the network, or statistical data handling.
- each stream consists of a different subset information of the total traffic information.
- Such data streams are for instance customer billing information data stream, statistical information data stream, operational and maintenance information data stream, customer complaint audit data stream and inter-operator billing information data stream.
- FIG 1 is a block diagram showing a telecommunications data warehouse arrangement according to prior art.
- Figure 1 shows a block diagram of a telecommunications data warehouse arrangement according to prior art.
- a network element is marked with a reference number 1
- the communication network is marked with a reference number 2
- the customer billing system is marked with a reference number 4.
- a network element 1 collects, stores and outputs the call details for billing purposes and produces a billing data stream 3.
- the customer billing information data stream from the different network elements 1 to the communication network 2 is marked with a reference number 3 and the customer billing information data stream from the communication network 2 to customer billing system 4 is marked with a reference number 5.
- the telecommunications data warehouse arrangement comprises network elements 1, a data warehouse database 6, and analysis applications 8-12.
- the customer billing information data stream from the customer billing system 4 to the data warehouse database 6 is marked with a reference number 7.
- the mediation device in the communication network 2 collecting the customer billing information data from one or more network elements 1 passes the information onwards to the customer billing system 4 and from then onto the data warehouse database 6.
- the analysis applications 8-12 such as customer analysis application 8, service analysis application 9, fraud analysis application 10, churn analysis application 11 and market analysis application 12 then use the information available in the data warehouse database 6 for different analyses .
- the telecommunications data warehouse arrangement according to prior art have certain levels of possible analysis functionality depending on the data available in the data warehouse database 6.
- the database 6 has usually the data of chargeable calls and services, sometimes also data on calls that were routed across the network but were left unanswered or reached busy.
- the information content in the billing stream for any particular call is not normally complete. There is more information about the call existing in the network than is required for billing purposes.
- the billing stream e.g. the customer billing information data stream
- all changes must be coordinated via the systems supporting the billing stream. This coordination usually is restricted due to integrity, security and performance issues. This resistance prevents a single usage data stream from a network element 1 being used as input to multiple systems.
- Data warehouse arrangements are also used to analyze the service offered to the subscriber. Some analysis applications are used to determine relationships between different events in a database. An example of such a relationship is when a subscriber attempts to make a call but encounters a busy tone, and then orders a CCBS-service (CCBS, Call Completion on Busy Subscribers) , the network sets up the ordered call as the line becomes available. As only the traffic events are stored into a data warehouse arrangement, also the fact that the second call was attempted because of the CCBS-service can not easily be determined.
- CCBS Call Completion on Busy Subscribers
- the aim of this invention is to overcome the drawbacks of the prior art solutions and to provide a new type of telecommunications data warehouse arrangement.
- a telecommunications data warehouse arrangement comprising one or more network elements, communication network, a data warehouse database, and analysis applications, which arrangement is characterized by that the complete usage data of the network elements is fed through the communication network into the data warehouse database.
- Figure 1 is a block diagram of a telecommunications data warehouse arrangement according to prior art
- Figure 2 is a block diagram of a telecommunications data warehouse arrangement according to the present invention.
- FIG. 2 shows a block diagram of a telecommunications data warehouse arrangement according to the present invention.
- a network element is marked with a reference number 13
- the communication network is marked with a reference number 2
- the data warehouse database is marked with a reference number 15.
- a network element 13 collects, stores and outputs the details for each and every event in the network element 13, and produces a standard billing data stream 3 and a separate usage data stream 14, which is forwarded directly to the data warehouse database 15.
- the customer billing information data stream from the different network elements 13 to the communication network 2 is marked with a reference number 3, and the customer billing information data stream from the communication network 2 to customer billing system 4 is marked with a reference number 5.
- the usage data stream from the different network elements 13 to the communication network 2 is marked with a reference number 14, and the usage data stream from the communication network 2 to the data warehouse database 15 is marked with a reference number 16.
- the network element 13 records everything that occurs in the network element 13 independent upon billing philosophies.
- the network element 13 records all call attempts, whether they are originating calls, terminating calls, transiting calls, local calls, test calls, operator calls, calls to special services etc.
- the network element 13 also records all interactions by customers towards services, e.g. every button press to activate or invoke any service.
- the network element 13 could even record information on every time a customer picks his handset off-hook and then replaces it without dialing any digits.
- the telecommunications data warehouse arrangement comprises one or more network elements 1, a communication network 2, a data warehouse database 15, and analysis applications 8-12.
- the complete usage data of the different network elements 13 is fed through the communication network 2 into the data warehouse database 15.
- the customer billing information data of the network elements 13 is forwarded onwards to the customer billing system 4 and also forwarded 7 to data warehouse database 15.
- the complete usage data of a network element 13 can be forwarded as one single data stream 14, or as multiple data streams 14 towards the communication network 2.
- the complete usage data of the different network elements 13 can be forwarded from the communication network 2 to the data warehouse database 15 as one single data stream 16, or as multiple data streams 16.
- the analysis applications 8-12 such as customer analysis application 8, service analysis application 9, fraud analysis application 10, churn analysis application 11 and market analysis application 12 then use the information available in the data warehouse database 15 for different analyses.
- the telecommunications data warehouse arrangement according to the present invention can be constructed so that a new system application 17, such as a CRM application (CRM, Customer Relationship Management) , can easily be added. Furthermore, the arrangement according to the present invention can be specially designed to be used for Customer Relationship Management.
- a telecommunications data warehouse solution there are no dependencies between the data warehouse and other information processing systems such as billing systems. Therefore the data present in the warehouse can be trusted to be of higher quality, it can be loaded with current data quicker and with reduced operational costs.
- the data warehouse is filled with a complete picture of activity inside the network element, the data can also be used for network element management and fraud detection. Better analysis of calls, service and customer behaviour can be made compared to the existing data warehouse solutions. As it is guaranteed that all calls are present in the data warehouse, it is possible to correlate all service event information with all possibly related calls.
Abstract
This invention relates to switching and operational support systems in the area of general telecom-munications, and more particularly, to a new type of telecommunications data warehouse arrangement. In an arrangement according to the invention the complete usage data of the network elements is fed into the data warehouse database.
Description
A TELECOMMUNICATIONS DATA WAREHOUSE ARRANGEMENT
This invention relates to switching and operational support systems in the area of general telecommunications, and more particularly, to a new type of telecommunications data warehouse arrangement .
Today many telecommunication operators have data warehouses that they use to record customer and call and service related data. This data collected to data warehouse is then used to analyze for example different services or customer behaviour. By analyzing it is possible to discover which services to offer to which customers as well as differentiate between different customers, detect fraud and predict customer churn. This information helps the operator to provide better service to the customers.
In a telecommunications network, network elements, such as telephony switches, are used to route and switch speech and data signals coming from another part of network. While performing this function the network element also generates a lot of data, which is then used for different purposes e.g. billing the customer for the phone call, billing another operator for the use of the network, or statistical data handling.
In an ordinary network element this data is combined to form several different data streams to come out of the network element. Each stream consists of a different subset information of the total traffic information. Such data streams are for instance customer billing information data stream, statistical information data stream, operational and maintenance information data stream,
customer complaint audit data stream and inter-operator billing information data stream.
Current telecommunication data warehouses however are based on the existing billing stream, which only contains a subset of the calls and services used in the network. Calls and services that are not charged (e.g. unsuccessful calls and services, terminating calls etc) may not be part of the billing stream, and thus not be available in the data warehouse.
In the following, the prior art solutions will be described in more detail with reference to the accompanying figure 1 which is a block diagram showing a telecommunications data warehouse arrangement according to prior art.
Figure 1 shows a block diagram of a telecommunications data warehouse arrangement according to prior art. A network element is marked with a reference number 1, the communication network is marked with a reference number 2 and the customer billing system is marked with a reference number 4. A network element 1 collects, stores and outputs the call details for billing purposes and produces a billing data stream 3. In the figure the customer billing information data stream from the different network elements 1 to the communication network 2 is marked with a reference number 3 and the customer billing information data stream from the communication network 2 to customer billing system 4 is marked with a reference number 5.
The telecommunications data warehouse arrangement according to prior art comprises network elements 1, a data warehouse database 6, and analysis applications 8-12. In the figure the customer billing information data stream
from the customer billing system 4 to the data warehouse database 6 is marked with a reference number 7. The mediation device in the communication network 2 collecting the customer billing information data from one or more network elements 1 passes the information onwards to the customer billing system 4 and from then onto the data warehouse database 6.
The analysis applications 8-12 such as customer analysis application 8, service analysis application 9, fraud analysis application 10, churn analysis application 11 and market analysis application 12 then use the information available in the data warehouse database 6 for different analyses .
The telecommunications data warehouse arrangement according to prior art have certain levels of possible analysis functionality depending on the data available in the data warehouse database 6. The database 6 has usually the data of chargeable calls and services, sometimes also data on calls that were routed across the network but were left unanswered or reached busy.
The information content in the billing stream for any particular call is not normally complete. There is more information about the call existing in the network than is required for billing purposes.
In a prior art telecommunications network there are many events occurring, which are not charged for. A lot of these events belong to services that help to increase call completion rates for the operator. These events traditionally can not be obtained in the billing stream output by the telecommunication network element 1.
Data warehouse arrangements according to the prior art are built based upon a billing stream and they are restricted in information towards the operator about the network or customers . There have been many adaptations performed to the billing data stream in the network to acquire specific new events or information details. However, there is no known solution available that would contain a complete picture of activity in the network and allow the correlation of the customer's activities to one another.
When new requirements are placed on the data warehouse, it is quite often required for the data warehouse to be sourced with additional information from the network. As the data source for the data warehouses comes from the billing stream, this requires the billing systems and the systems between the network and the data warehouse to be updated. This updating of the different system elements is an extremely troublesome and time-consuming operation.
As the billing stream e.g. the customer billing information data stream is impacted by any change in the data characteristics of the billing stream, all changes must be coordinated via the systems supporting the billing stream. This coordination usually is restricted due to integrity, security and performance issues. This resistance prevents a single usage data stream from a network element 1 being used as input to multiple systems.
Data warehouse arrangements are also used to analyze the service offered to the subscriber. Some analysis applications are used to determine relationships between different events in a database. An example of such a relationship is when a subscriber attempts to make a call but encounters a busy tone, and then orders a CCBS-service (CCBS, Call Completion on Busy Subscribers) , the network
sets up the ordered call as the line becomes available. As only the traffic events are stored into a data warehouse arrangement, also the fact that the second call was attempted because of the CCBS-service can not easily be determined.
In the view of the prior art there is a clear need for a new type of method for establishing a telecommunications data warehouse arrangement and a new type of telecommunications data warehouse arrangement that would provide a complete, unambiguous and detailed picture of traffic in the network element. Lack of such a solution has already for a quite some time been a stumbling block for the further development of the current analysis applications 8-12 as well as for the introduction of new analysis applications such as CRM applications (CRM, Customer Relationship Management) .
The aim of this invention is to overcome the drawbacks of the prior art solutions and to provide a new type of telecommunications data warehouse arrangement.
According to the first aspect of the present invention there is provided a telecommunications data warehouse arrangement comprising one or more network elements, communication network, a data warehouse database, and analysis applications, which arrangement is characterized by that the complete usage data of the network elements is fed through the communication network into the data warehouse database.
A more complete understanding of the arrangement of the present invention may be obtained by the preferred embodiments that follow, taken in conjunction with the accompanying drawings, wherein:
Figure 1 is a block diagram of a telecommunications data warehouse arrangement according to prior art, Figure 2 is a block diagram of a telecommunications data warehouse arrangement according to the present invention.
The prior art solutions have been described in drawing 1. In the following, the solution according to the present invention will be described in more detail with reference to the accompanying drawing 2.
Figure 2 shows a block diagram of a telecommunications data warehouse arrangement according to the present invention. A network element is marked with a reference number 13, the communication network is marked with a reference number 2, and the data warehouse database is marked with a reference number 15. A network element 13 collects, stores and outputs the details for each and every event in the network element 13, and produces a standard billing data stream 3 and a separate usage data stream 14, which is forwarded directly to the data warehouse database 15.
In the figure the customer billing information data stream from the different network elements 13 to the communication network 2 is marked with a reference number 3, and the customer billing information data stream from the communication network 2 to customer billing system 4 is marked with a reference number 5. Likewise, the usage data stream from the different network elements 13 to the communication network 2 is marked with a reference number 14, and the usage data stream from the communication network 2 to the data warehouse database 15 is marked with a reference number 16.
The network element 13 records everything that occurs in the network element 13 independent upon billing philosophies. The network element 13 records all call attempts, whether they are originating calls, terminating calls, transiting calls, local calls, test calls, operator calls, calls to special services etc. The network element 13 also records all interactions by customers towards services, e.g. every button press to activate or invoke any service. The network element 13 could even record information on every time a customer picks his handset off-hook and then replaces it without dialing any digits.
The telecommunications data warehouse arrangement according to the present invention comprises one or more network elements 1, a communication network 2, a data warehouse database 15, and analysis applications 8-12. The complete usage data of the different network elements 13 is fed through the communication network 2 into the data warehouse database 15. The customer billing information data of the network elements 13 is forwarded onwards to the customer billing system 4 and also forwarded 7 to data warehouse database 15.
The complete usage data of a network element 13 can be forwarded as one single data stream 14, or as multiple data streams 14 towards the communication network 2. The complete usage data of the different network elements 13 can be forwarded from the communication network 2 to the data warehouse database 15 as one single data stream 16, or as multiple data streams 16.
The analysis applications 8-12 such as customer analysis application 8, service analysis application 9, fraud analysis application 10, churn analysis application 11 and market analysis application 12 then use the information
available in the data warehouse database 15 for different analyses. The telecommunications data warehouse arrangement according to the present invention can be constructed so that a new system application 17, such as a CRM application (CRM, Customer Relationship Management) , can easily be added. Furthermore, the arrangement according to the present invention can be specially designed to be used for Customer Relationship Management.
In a telecommunications data warehouse solution according to the present invention there are no dependencies between the data warehouse and other information processing systems such as billing systems. Therefore the data present in the warehouse can be trusted to be of higher quality, it can be loaded with current data quicker and with reduced operational costs.
As all usage on the network elements is recorded in advance it is more likely that when introducing a new application, the required data is already present in the data warehouse, thus reducing lead times and modification costs. As the data warehouse is filled with a complete picture of activity inside the network element, the data can also be used for network element management and fraud detection. Better analysis of calls, service and customer behaviour can be made compared to the existing data warehouse solutions. As it is guaranteed that all calls are present in the data warehouse, it is possible to correlate all service event information with all possibly related calls.
It is also possible to see the complete behaviour of the network. This would include any unforeseen behaviour that would normally be filtered out. The analysis of unforeseen behaviour can be very useful in network management, fraud
detection and for determining the scope for new service offerings .
Claims
1. A telecommunications data warehouse arrangement comprising one or more network elements (13), a communication network (2), a data warehouse database (15), and analysis applications (8) -(12), the arrangement being characterized in that the complete usage data of the network elements (13) is fed through the communication network (2) into the data warehouse database (15) .
2. A telecommunications data warehouse arrangement according to Claim 1, characterized in that the complete usage data of a network element (13) is forwarded as one single data stream (14) towards the communication network (2).
3. A telecommunications data warehouse arrangement according to Claim 1, characterized in that the complete usage data of a network element (13) is forwarded as multiple data streams (14) towards the communication network (2 ) .
4. A telecommunications data warehouse arrangement according to Claim 2 or Claim 3, characterized in that the complete usage data of the different network elements (13) is forwarded from the communication network (2) to the data warehouse database (15) as one single data stream (16) .
5. A telecommunications data warehouse arrangement according to Claim 2 or Claim 3, characterized in that the complete usage data of the different network elements (13) is forwarded from the communication network (2) to the data warehouse database (15) as multiple data streams (16) .
6. A telecommunications data warehouse arrangement according to any of the preceding Claims, characterized in that the information in the data warehouse database (15) is used for different analyses by the different the analysis applications (8)-(12).
7. A telecommunications data warehouse arrangement according to any of the preceding Claims, characterized in that the arrangement is constructed so that a new system application (17) can easily be added.
8. A telecommunications data warehouse arrangement according to any of the preceding Claims, characterized in that the arrangement is specially designed to be used for Customer Relationship Management.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/EP2000/004390 WO2001084385A1 (en) | 2000-05-01 | 2000-05-01 | A telecommunication data warehouse arrangement |
AU2000250665A AU2000250665A1 (en) | 2000-05-01 | 2000-05-01 | A telecommunication data warehouse arrangement |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/EP2000/004390 WO2001084385A1 (en) | 2000-05-01 | 2000-05-01 | A telecommunication data warehouse arrangement |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2001084385A1 true WO2001084385A1 (en) | 2001-11-08 |
Family
ID=8163939
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/EP2000/004390 WO2001084385A1 (en) | 2000-05-01 | 2000-05-01 | A telecommunication data warehouse arrangement |
Country Status (2)
Country | Link |
---|---|
AU (1) | AU2000250665A1 (en) |
WO (1) | WO2001084385A1 (en) |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0961439A2 (en) * | 1998-05-29 | 1999-12-01 | Hewlett-Packard Company | Network management event storage and manipulation using relational database technology |
WO2000013112A1 (en) * | 1998-08-31 | 2000-03-09 | Cabletron Systems, Inc. | Method and apparatus for managing data for use by data applications |
-
2000
- 2000-05-01 WO PCT/EP2000/004390 patent/WO2001084385A1/en active Application Filing
- 2000-05-01 AU AU2000250665A patent/AU2000250665A1/en not_active Abandoned
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0961439A2 (en) * | 1998-05-29 | 1999-12-01 | Hewlett-Packard Company | Network management event storage and manipulation using relational database technology |
WO2000013112A1 (en) * | 1998-08-31 | 2000-03-09 | Cabletron Systems, Inc. | Method and apparatus for managing data for use by data applications |
Non-Patent Citations (3)
Title |
---|
CONINE R: "THE DATA WAREHOUSE IN THE TELECOMMUNICATIONS INDUSTRY", IEEE NETWORK OPERATIONS AND MANAGEMENT SYMPOSIUM,US,NEW YORK, NY: IEEE, vol. CONF. 10, 3 November 1997 (1997-11-03), pages 205 - 209, XP000799773, ISBN: 0-7803-4352-2 * |
DETBYSHIRE M H: "AN ARCHITECTURE FOR A BUSINESS DATA WAREHOUSE", THE ICL SYSTEMS JOURNAL,GB,INTERNATIONAL COMPUTERS LIMITED, vol. 11, no. 1, 1 May 1996 (1996-05-01), pages 23 - 47, XP000631249, ISSN: 1364-310X * |
TRISOLINI S M ET AL: "Data integration and warehousing in Telecom Italia", 1999 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, PHILADELPHIA, PA, USA, 1-3 JUNE 1999, vol. 28, no. 2, SIGMOD Record, June 1999, ACM, USA, pages 538 - 539, XP002159300, ISSN: 0163-5808 * |
Also Published As
Publication number | Publication date |
---|---|
AU2000250665A1 (en) | 2001-11-12 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7062024B2 (en) | Telecommunication services reporting system | |
US6876731B2 (en) | System and method for managing CDR information | |
US5896445A (en) | Incoming call tracking with interactive data collection | |
US8433047B2 (en) | Method and system for measuring market-share for an entire telecommunication market | |
US5940471A (en) | Method and apparatus for obtaining feedback regarding network services | |
US6351453B1 (en) | Internet service provider (ISP) finder | |
AU658102B2 (en) | Flexible call detail recording system | |
US5805680A (en) | Method and apparatus for telephone call sub-billing | |
CA2305970C (en) | Automatic telecommunications provider selection system | |
CA2536725C (en) | Systems and methods for call measurement | |
US6606377B2 (en) | Method and system for analyzing and preparing an optimum telephone services call plan | |
US6078647A (en) | Method and apparatus for detecting a data service provider in a public switched telephone network | |
CN101453522A (en) | Method for non-standardized dialing service monitoring between networks | |
US20080126098A1 (en) | Value added service network, ivr server and method for analyzing flow track in real time | |
US20100130136A1 (en) | System and Method for Interpreting and Classifying Signals in Communications Systems | |
US5528676A (en) | Missed calls accounting and reporting system | |
US8270592B2 (en) | Call routing management based on caller language | |
US20080152119A1 (en) | Call management reports | |
US20050287983A1 (en) | System and method of managing SS7-monitored call information | |
WO2001084385A1 (en) | A telecommunication data warehouse arrangement | |
US6819751B1 (en) | Method of forwarding data from a network element and an arrangement for uitilizing data from a network element | |
EP1279275B1 (en) | A communications data storage arrangement | |
KR100662933B1 (en) | Apparatus and method for monitoring traffic of mobile value-added service by using cdr | |
KR100657119B1 (en) | Method for providing subscriber traffic data in intelligent network and system therefor | |
KR100714619B1 (en) | System for monitoring traffic and speech quality of incoming prefix using cdr and method thereof |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
122 | Ep: pct application non-entry in european phase | ||
NENP | Non-entry into the national phase |
Ref country code: JP |