The Polícia Civil do Estado do Rio de Janeiro (PCERJ) is the government office in charge of police activities and the investigation of criminal offenses, with the exception of those regarding military matters. This is part of the State Security Department, headed by the Civil Police Chief and encompasses deputies and agents in their respective division areas.
In 1999, PCERJ launched a program to improve the working conditions of police officers and provide better service to citizens by computerizing and modernizing all units. The project—which obtained International Organization for Standardization certification—involved upgrading police stations facilities, standardizing police reports, and unifying and centralizing data in Oracle Database through the Police Intelligence System, which was developed in-house.
The Police Intelligence System allows PCERJ to manage criminal data, such as crime type, date and time, location, vehicles used, firearms and other weapons, and telephone numbers and e-mail addresses associated with specific crimes and investigations. Accessed by 6,500 computers located in the police departments across the state, the software shares data in real time and has more than 4 million personal records detailing physical features (such as criminal and suspect tattoos and scars) and more than 20,000 sketches of suspects and criminals, which accelerated and enhanced information sharing across departments.
"With data stored in Oracle Database, we consolidated all the violations and develop more effective action policies and increased our systems availability, which is critical for our 24/7 operation," said André Drumond, CIO, Rio de Janeiro State Civil Police.
The Police Intelligence System was developed in 1999 on Oracle Database, and since then there has been a large increase in the volume of data stored and the needs of the Civil Police of Rio de Janeiro. "In addition to improving the capacity and performance of the Police Intelligence System, we needed to know where the crimes occurred and how often to analyze and prevent crime," he said.
To expand the impact of its Oracle Database-based solution, PCERJ recently deployed Oracle Business Intelligence to generate reports that cross-reference locations, violation types, modus operandi, and physical features of violators.
"Using Oracle Business Intelligence, PCERJ improved its analysis capabilities. We can now study violators’ behavior in detail and develop more proactive and preventative strategies," Drumond said.
Thanks to the Police Intelligence System, PCERJ now provides data to dozens local, state, and national governments agencies. Overall, the Police Intelligence System includes more than 100 million documents from criminal court procedures and 6 million crime reports.
"We deal with a very large data volume, including statistical data that help us study crime patterns. Our dashboards, drill-down capabilities, indicators, and alerts provide the intelligence we need to effectively investigate and prevent crimes," Drumond said.
PCERJ also created an occurrences map, a geo-referencing system used to fight crime. It is based on Oracle Spatial and Graph, integrated with Oracle Business Intelligence, providing investigators and 185 departments with data, such as the exact time and place of violations, in a graphic format, that promotes prevention initiatives.
"With the occurrences map based on Oracle Spatial and Graph, we can visualize and create maps of criminal occurrences," Drumond said.
Modernizing its IT infrastructure will allow PCERJ to make the Police Intelligence System available to police personnel via mobile devices, such as smartphones and tablets—further accelerating information sharing. PCERJ is also developing in partnership with TJRJ (Court of Rio de Janeiro), the first paperless criminal court, a project that will involve collecting casualty data by tablets and livescans.
"With Oracle technology, investigators and other police personnel will be able to access our system through mobile devices, improving productivity and demonstrating PCERJ’s commitment to innovation and advancing public safety," Drumond said.
"We had great trust in Oracle Database and Oracle technology when we selected Oracle Business Intelligence and Oracle Spatial Graph. We, therefore, did not evaluate other vendors. Our institution has never lost data since 1999, and we have a great partnership with Oracle. As a public safety agency, we look for the most robust and reliable technology available to support us in our efforts. Oracle consistently meets our needs," Drumond said.