Case Study: Secretaría General de Administración de Justicia en España achieves near-real-time business intelligence and improved citizen services with Oracle Business Intelligence

Secretaría General de Administración de Justicia en España Enhances Citizen Services with Near-Real-Time Business Intelligence Gleaned from 500 Databases

The Secretaría General de Administración de Justicia en España (Spain’s General Secretariat for Justice Administration), part of the Ministry of Justice, manages court administration, staffing and procurement across 50 provinces and maintains a central registry of civil and criminal records. Faced with heterogeneous, geographically dispersed data, manual and nonstandard reporting, and the need to integrate with e‑justice systems, the ministry needed timely, reliable business intelligence to improve resource allocation, track crime and court performance, and evaluate new IT initiatives.

Working with Oracle Consulting to replace legacy tools, the ministry deployed Oracle Business Intelligence and Oracle Database to standardize analytics across more than 500 databases (16 billion rows, 4 TB). The solution delivers dashboards updated every 24 hours, enabled optimal allocation of judges, clerks and funds, supported benchmarking and wage/bonus decisions, handled over 100 million authenticated online communications yearly among 5,000 legal professionals, and embedded BI into new projects to improve efficiency and responsiveness to legislative change.

Secretaría General de Administración de Justicia en España

Angelines Turón

Director of the new technologies subdirectorate