PTHS (Prepaid Transaction Historical System) is primarily a call centre application tool helping customer care officers (CCO) to quickly and efficiently customer interaction. CCO being the crucial interface between the company and the customer has to be equipped with instant, accurate and consistent information. PTHS equips CCO  with up to date customer data and other generic information required to addresses customers.

Back end Processing

Back end processing function to receive files from mediation (CPP) and saved to the table PTHS can be accessed by users. Currently, the design can manage data about 1 billion CDR per day.

• Input file based on HLR. For HLR with high population shall separate into two or more sub HLR.
• Input file is merged in order to have optimal file size and reduce number of processing.
• Load file into table by Loader. File put into HLR table respectively. Therefore extremely reduce memory consumption because no I/O queue since has wide separate destination table. Also because of average file size to be processed. It is also eliminate Mover Device which has mostly problem currently occurrence.
• In periodically, the data transfer into “query table” in order to separate table high query accessed by user and high hit inserted by loader.

Design Architecture

Screen Shoot PTHS Project