MKB CDR progress - Jan 2004

Click for:		Milestones	Deliverables	Progress
Progress notes for MKB CDR/database development
Nov/Dec 03	Jan 04	Feb 04	Mar 04	Apr 04
May 04	Jun 04	Jul 04	Aug 04	Sept 04
5th January 2004 Simon has updated the software to include new command line parameters such as machine ID and site ID. He has also increased the speed of reception of CDRs by cacheing the data and only writing to disk once-per-second. This has allowed a speed of 2000 CDRs/second to be achieved. The CDRs are split into 3 parts: 1 – initial CDR data 0 – intermediate CDR data 2 – final CDR data Once all the information has been received for a particular CDR, it is written as a type 3 CDR. More work is to be done on the real-time aspects of the system and Simon will also work on the “network programming”, which deals with such things as broken and restored cables and other network problems. Simon is sending a copy of his environment to PTL (either via email or on CD-R, depending on the size) so that a “shadow system” can be configured. This will also provide a means of back-up. PTL’s new address and contact details have been sent to Simon. Simon will be working on some new queries and, to this end, will be sending out ideas regarding a requirements spec and marketing material to all parties for comment and ideas (see full report, below).
6th January 2004 Simon has delivered a copy of his development environment, and explainations for each module. The files can be viewed/downloaded below: insertcdrs.zip (276KB) \| scripts.zip (215KB) \| mkb_call.htm (144KB) This development will be incorporated into a "shadow" system at PTL HQ. The small footprint Linux PC has been shipped today from Semicom. Simon's progress report for today is as follows: ------ "The project progress over xmas has been aimed at getting the Demonstrator up and running, and is as follows: 'insertcdrs.exe' implemented, to write CDRs to the database from the Linux CDR server. This originally worked at 28 CDRs/s to the DB, but by changing the MySQL disk writing Cache this was increased to 2400 CDRs/s and began to be limited by the 10 Mbps of the Ethernet. I will repeat this test when the code is finished. Support added to set CDR Server variables from the command line. Support added for the original random CDR generator, controlled of the command line. This can generate N random CDRs without the CDR Server. Support added for SiteID, SystemID and CarrierID to be set on the command line. To Do: Support for Network outages to be added. To Do: Support for the Real-time CDR table to be added imminently. 'mkb_call' Database Initialisation files in SQL (mkb_init.sql) upgraded to support the new CDR format and real-time CDR table for calls-in-progress. Bug fixes as well. To Do: International Signalling Point Code (ISPC) table to be completed to enable look up of DPC and OPC Codes. Countries table with International Dial Codes to be added." ------ Simon also requested all staff to produce a wish list of ideas for the demonstrator software.
9th January 2004 The Semicom small footprint PC has been delivered to PTL. Once this system has been loaded with Linux and tested, it has been preliminarily agreed that Jeff and Pat will travel to see Simon over the next week to learn how his development system works and also to obtain a copy of Crystal Reports. At the same time, a conference call may take place to gnerate final ideas for the feature set of the demonstration system.
12th January 2004 Arrangements for a development demonstration have been made with Simon - Steve, Jeff and Pat to attend. Also a potential conference call to be made in the afternoon to discuss the final feature list for the demonstration/release software. Notes to be taken during the visit, and this will form the start of the documentation package for the final product.
15th January 2004 Visit to Simon to see a demonstraton of his software and learn how to install all the relevant applications so we can build a "shadow" system at PTL HQ. A summary of the visit can be found here.
29th January 2004 A visit to recover the Martinet hardware is to be planned for next Tuesday 3rd February. Simon has finished with the kit and has also promised a report update on his development progress. One aspect of recent development is the code to allow seamless reconnection to the database in the event of a network failure.
30th January 2004 Received latest progress report from Simon. It can be read here