Polícia Civil do Estado do Rio de Janeiro Accelerates Data Sharing Across the State and Improves Police Operations, Criminal Intelligence, and Investigations with Upgraded IT Infrastructure

Polícia Civil do Estado do Rio de Janeiro Accelerates Data Sharing Across the State and Improves Police Operations, Criminal Intelligence, and Investigations with Upgraded IT Infrastructure

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.

Intelligence for Solving and Preventing Crime

A word from Polícia Civil do Estado do Rio de Janeiro (PCERJ)

  • “With Oracle Database, and its Oracle Real Application Clusters option, we increased our storage capability and secured high availability for more than 100 million criminal case documents and 6 million criminal reports, accessible to over 10,000 users registered with our Police Intelligence System.” – André Drumond, CIO, Polícia Civil do Estado do Rio de Janeiro

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.

Going Mobile




  • Improve ability to effectively and efficiently share crime and suspect data—encompassing more than 6 million crime reports and 100 million criminal case documents—with police departments across the state
  • Ensure high availability for the Police Intelligence System
  • Gain the intelligence needed to develop more effective crime prevention initiatives and strategies
  • Support crime investigators with advanced technology, including the ability to access police data via mobile devices


  • Upgraded to Oracle Database Enterprise Edition 11g to support the rapidly growing Police Intelligence System, which includes 6 million crime reports, 100 million criminal case documents, more than 4 million personal records, and over 20,000 sketches of wanted criminals
  • Ensured high availability of the of the Police Intelligence System to support 10,000 users and provide 24/7 access to vital information using Oracle Real Application Clusters
  • Implemented Oracle Business Intelligence and began performing violator behavior studies by cross-referencing data—enabling PCERJ to fight crime in a more proactive manner
  • Used Oracle Spatial and Graph to develop occurrence maps that support expanded crime prevention initiatives
  • Created a modern infrastructure that will enable police personnel to access the Police Intelligence System via mobile devices, such as smartphones and tablets, putting vital information at their fingertips in the field

Why Oracle

"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.