The Mining Data Mart - Data Mining Techniques in CRM: Inside Customer Segmentation - page 172

Table 4.24 A lookup table for service types.

Field name Field type Field description

Service_Code Int The service code of the call

Service_Desc Char The service description of the call

Service_Code is the primary key (PK) of this table.

Table 4.25 A typical
list of mobile telephony
service types.

Service types

Voice calls

SMS calls

MMS calls

Internet calls

WAP calls

Video calls

Events/service calls

Mailbox calls

Other

Typical service types are given in Table 4.25.

Networks

The last proposed lookup table (''L_Network table''), Table 4.26, decodes the
different types of source (for incoming calls) and destination (for outgoing calls)
networks.
A typical categorization of network types is presented in Table 4.27.

THE MCIF FOR MOBILE TELEPHONY

Even if the data mart covered the majority of mining and marketing needs,
its information would typically require additional data preparation before being
appropriate for use in data mining applications. This is where the MCIF fits in.