The Challenge
CCIS version 2k.1 is a Windows based application that stores records related to crimes and criminals, and lost and recovered property. The application resides at the NCRB office in New Delhi, and runs in district headquarters across the country. Records fed in at the district level are periodically thresholded at the center through the Offline/ Online system of data transfer, in the absence of an active online system.
The Integrated Information Forms serve as the backbone of the application, which link 140 tables, 120 forms and 160 parameters related to crimes, criminals and property. CCIS 2k.1 is potentially the largest police application in the world.
Today, CCIS is in the process of standardizing the way criminal records are maintained across the country, allowing efficient sharing of information and facilitating greater coordination at a national level. The application is partially available on a nationwide network today, and provides access to more than 5,300,000 records that are centrally located at NCRB. Apart from English, CCIS application has been implemented in 6 Indian regional languages: English, Hindi, Tamil, Marathi, Kannada, Gujarati, Punjabi (Gurmukhi). NCRB plans to extend to other regional languages in a phased manner.
The Solution
NCRB wanted to put in place a system that would allow access to and the sharing of hundreds of thousands of crime records created over decades, which existed in databases of police districts across the country.
The system consisted of around 12 modules for data entry of various criminal records at three different levels i.e. local, state and national levels. The application is capable of exporting and importing data amongst the various levels as and when required. It also generates 65 kind of reports based on the user requirements given by NCRB. It also gives various search facilities and matching facilities of finger prints from the archives.
The developed system allows efficient sharing of information and facilitates greater coordination at a national level. This system has provided efficient archiving of criminal records and greatly increased the retrieval of records for efficient action by the sleuths.
Technology Framework
- Microsoft Windows 2000 Advanced Server
- Microsoft SQL Server 7 Enterprise
- Microsoft Visual Basic 6.0
- Microsoft Back Office Server
- Microsoft Exchange