Sunday, July 12, 2009

This is Rukmani Devi



Call Record Analysis Tool



 



Prerequisites



 




  1. Call record formats of all companies


  2. Data of tower locations with Latitude – Longitudes with details of updating.


  3. STD and ISD codes


  4. Phone directories both landline and cellular (if available)


  5. Cellular Phone numbering plans in different circles and companies.


  6. Interpretations of prefix / codes if used in any field of call records.


  7.  



 



 



Format of Call Records



 



Call records are generally obtained for 2 types of queries. Call records of individuals or known phone numbers and call records of a particular tower.



 



Generic form of call records should contain the following



 




  1. Mobile Number | Subscriber


  2. Calling | Caller ID


  3. Call Type – Incoming / Outgoing



    • Voice  


    • SMS



  4. Date (DD/MM/YYYY)


  5. Time (24 Hours) IST


  6. Cell ID – Tower ID


  7. IMIE


  8. IMSI


  9. Call Duration



 



Different companies maintain their database in different formats. An analysis of these formats would be required to generate a common platform for data merge.



 



Following information can be derived from above database



 



Preliminary Analysis results



 



1.                  Frequency of call to a set of numbers



2.                  List of Most Frequently called numbers



3.                  List of Most Frequently Received Numbers



4.                  Latest called Numbers 



5.                  Numbers called Around the suspected time duration



6.                  List of numbers with maximum call duration



7.                  Area(s) of Maximum / Last activity



 



 



 



Analysis for TOWER DATA



 



1.                  Group of phone numbers Calling each other in a same tower location



2.                  Group of Phone Numbers Calling each in different tower locations



3.                  Movement of a number / group of numbers across different towers



4.                  Movement of a IMIE across different towers



 



 



Further analysis tools as listed below would provide different type of report generation.



 



1.                  Same phone number with different IMIE or Same IMIE with different phone numbers supported by the movement of number across the towers.



2.                  Group of phone numbers Calling each other in a same tower location



3.                  Group of Phone Numbers Calling each in different tower locations



4.                  Movement of a number / group of numbers across different towers



5.                  Movement of a IMIE across different towers



 



Above all can be visualized in text form as well as on google maps so that route map can be generated.



 



 



Cases where suspected numbers are not identified but tower locations are identified. Data of particular tower locations are merged to find out activity.



 




  1. Identification of common numbers / IMIE / group in set of specified tower locations.


  2. Indetification of 1o  and 2o ,…and N Degrees of connections  in specified tower locations on given date and time.



 



 



 



Formats of reports



 




  1. Text


  2. Graphs (Line / frequency / Timeline )


  3. Geographic Location representation with the help of Google Maps API