close

Вход

Забыли?

вход по аккаунту

код для вставкиСкачать
ICA
InterConnect Accounting of in itel
The system of rating and reporting usage based interconnect products
Main features:
• Cost based IC product structure
• auditor proof quality report of the processing
• continous GUI supported file processing
• CDR level of reporting ( in case of dispute as well)
Hidden opportunities:
• CDR loading into the data-warehouse
• reporting of trunk usage
Next challange: getting more dynamic
• multiple rate brake within a month
• weekly accounting
• supporting least cost routing
25/02/2015
1
Hazay Csaba
ICA Processing Chain
SMACC CLIENT
System
Maintenance and
Configuration
Center
Interconnect
Service
Provider
inroute
outroute
TRUNK
Point of Interconnect
FIREWALL
SMACC Server
Excel
IC parameters
Database
SWITCH
IC AMA files
FIREWALL
File transfer by the
Switch Operation
CONVERTER
QUE
Loading at start
up
Parameters in the
Operative Memory
ARCHIVE DATABASE
PORTAL
QUE
REPORT
EDR LOADER
INTERCONNECT
PFRAMEWORK
IFW
QUE
QUE
SCADA (Supervisory Control and Data Acquisitions) Perl script set
REFRESH status
ACTION
ICA Dashboard
Perl/Tk  Xterminal GUI
Button / Menu
FIREWALL
25/02/2015
SSH Secure channel
2
Hazay Csaba
IC AMA files
File transfer by the
Switch Operation
ICA Dashboard
CONVERTER
QUE
25/02/2015
PORTAL INTERCONNECT
QUE
ARCHIVE DATABASE
EDR LOADER
QUE
QUE
3
Hazay Csaba
CONVERTER
ICA Converter
QUE
QUE
Core function
• Converting and mapping of the switch dependent (binary) interconnect Event Data
Records (EDR) to the INTEGRATE module acceptable SOL42 (text) format.
• Aggregating relevant call and file parameters for quality control.
• ANSI C self contained program.
Converter shell
• Implemented as a daemon.
• Looking for input files to be processed.
• Checking and prevent the double converting of the same file
• Starting of the core converter program.
• Interpretation and log of the report generated by the converter program.
• Compressing the processed files.
• Servo operation: not to overload the queues between the processes.
• PERL program
4
Hazay Csaba
ICA
Rating: Portal INTERCONNECT
Function:
• Identifying and rating Interconnect products.
PORTAL
INTERCONNECT
QUE
QUE
• Testing and re-rating rejected records.
• Logging of the processing events.
Features:
• It is not a self-contained program, rather a configurable toolkit only for professionals.
• EDR-s are processed in a pipe (consisting of processing plug-in chain).
• The plug-in chain is user configurable (Interconnect FrameWork IFW).
• There are pre defined plug-ins for interconnect processing (INTERCONNECT).
• User defined plug-ins are supported by scripting tools: IScript IRule
• Plug-ins are controlled by the parameters loaded from the database into the memory.
• Parallel operation of the pipes, pipes are multithreaded: input, plug-in chain, output.
• Advanced support for re rating of rejected records.
• GUI interface for IC product parameter set definition (SMACC).
5
Hazay Csaba
ARCHIVE DATABASE
EDR LOADER
ICA EDR Loader
QUE
QUE
Function:
• Filtering the rated (SOL42 format) records to Oracle database loadable files.
• Checking the record keys to avoid duplicate loading
• Generating the database tables per month.
• Loading the EDRs into the Archive Database using the ORACLE loader.
• Deleting the no more used SOL42 files.
• Processing the unrecoverable rejected files.
Features:
• Implemented as a daemon.
• Multithreaded operation: loading and preparing the next loadable file.
• Duplicated record checking: within the file, and against the records in the database.
• Free space checking before starting the ORACLE loader.
• PERL program
25/02/2015
6
Hazay Csaba
Excel
ICA IC Report
REPORT
Function:
• Report of Matáv by products, by trunks
• Report of other partners by products, by trunks
ARCHIVE DATABASE
QUE
• Generating audit-proof Quality Report
• Writing the result of the report into an Excel table file or an Excel loadable text file.
Features:
• Implemented as a daemon.
• Two phase operation:
aggregation into the Report Master table
query it by partner, ic product, …
• Multithreaded operation: query the data for quality report and
generating the Report Master table of the current month.
• PERL program
25/02/2015
7
Hazay Csaba
ICA Quality Report 1
Processing Log - Summary
Mediation - Rating - Posting
EWSD
file number
call number
duration [sec]
rejected [sec]
AXE
file number
call number
duration [sec]
rejected [sec]
RATING
EWSD
AXE
Total
dur. [sec]
Quality
converter
279
36 581 778
5 011 857 459
0
145
1 377 389
151 669 350
0
rejected [sec]
rejected [sec]
5 163 526 809
database
279
36 581 778
5 011 857 459
0
0
145
1 377 389
151 669 350
Processed Files - Integrity Check
processed file count against database
Account Period
switch
database
remark
200305
files of all sw.: 424
424 Current ACP
Overlap of previous month: 200304 (regular: 1 file/switch)
200304
files of all sw.: 10 10
all switches
Integrity summary: OK
25/02/2015
leakage
0
0
0
0
0
0.00E+00
0
0
integrity
OK
OK
8
Hazay Csaba
ICA Quality Report 2
Raw File Stream - Integrity Check
switch (integrity) start date
from: 2003.05.01
GDL
( OK)
from: 2003.05.01
VAC
( OK)
from: 2003.05.01
SZEGL
( OK)
from: 2003.05.01
SZI G
( OK)
from: 2003.05.01
DUNA
( OK)
DUNAT
( ERROR) from: 2003.05.01
file
min_seq
file stream of switch against gap/overlap
start file
end date
GDLIAC-0520
up to: 2003.06.01
VACIAC-0492
up to: 2003.06.01
SZEGLIAC-0512
up to: 2003.06.01
SZIGIAC-0485
up to: 2003.06.01
DUNAIAC-0490
up to: 2003.06.01
DUNATIAC-0494
up to: 2003.06.01
max_seq
gap
DUNATIAC-0502
26 421 067
26 518 134
DUNATIAC-0503
1
129 377
ESZT
VESZP
J AB
SZT
Integrity
from: 2003.05.01
( OK)
from: 2003.05.01
( OK)
from: 2003.05.01
( OK)
from: 2003.05.01
( OK)
summary: ERROR
IC Product - Integrity Check
provider
products
MV
in the database
Matáv
in the report
irregular: MVNDEF
ESZTIAC-0499
VESZPIAC-0522
JABACAS-2026
SZTACAS-1054
end file
GDLIAC-0550
VACIAC-0522
SZEGLIAC-0542
SZIGIAC-0515
DUNAIAC-0520
DUNATIAC-0555
remark
0 for reference
- 26 518 134 restart of the sw itch
up
up
up
up
to:
to:
to:
to:
2003.06.01
2003.06.01
2003.06.01
2003.06.01
ESZTIAC-0529
VESZPIAC-0552
JABACAS-2112
SZTACAS-1111
report table against database
dur_sec
prod_num
integrity
4 144 931 919
73
4 144 931 919
73 OK
104 045
2.51E-05
Integrity summary: OK
25/02/2015
9
Hazay Csaba
ICA Operation Support
• Unattended automatic file processing. Mail and SMS sending in case of crash.
• Graphical User Interface ( refusing not executable commands, ask for reinforce).
• Automatic generation of directories and table for the next account period.
• Rollback of complete processing of an account period
• Rollback processing results of a selectable file
• Log and record level browsing of rejected files.
• Selectable or bulk recycle of rejected records.
• Selectable DUMP file generation of rating result.
• Single file processing possibility.
• Saving and restoring of the archive and parameter database.
• GUI quality checking: call & duration balance between input and database.
• Individual session log of processing tasks.
• Automatic APC (Account Period Close): report generation, archiving.
• Multiple instances (test, production …)
25/02/2015
10
Hazay Csaba
ICA position in our world
Martin Browne about the Interconnect reconcilliation variation:
„The percentage variation is usually between 3% and 5% but can, in some cases,
be as low as 0.5% „
Invitel – Matáv relation we are always under 1%
Cost of ownweship:
(1.4 M CDR/day)
•Hardware: HP unix server + disk array
•Database (ORACLE):
45 M HUF
2 M HUF
•Portal INTERCONNECT ?? ? Part of the INFRANET package
•Two external consultant ( 10 man month) + 1 full time employee of Invitel
•Development time (from available server up to the fist invoice) 1 year
Comparison:
(9 M CDR/day
Matáv)
•Intec’s InterconnecT + DatenKontor’s DAPRE, DAPRO modules
•Rumored 20 times more expensive
25/02/2015
11
Hazay Csaba
1/--страниц
Пожаловаться на содержимое документа