Provision of information held by Northumbria Police made under the Freedom of Information Act 2000 (the 'Act')
As you may be aware the purpose of the Act is to allow a general right of access to information held at the time of a request, by a Public Authority (including the Police), subject to certain limitations and exemptions.
You asked:
- What database management systems do you currently use?
- What business applications and functions are being supported by each database management system?
- Is each database management system supported by an inhouse team or an external company?
- Do you use Ingres / Actian X? If so, what business function is supported by it?
In Response:
Following receipt of your request, searches were conducted with the ICT Department of Northumbria Police. I can confirm that the information you have requested is held by Northumbria Police.
I am able to disclose the located information to you as follows, which is in a way which avoids the use of exemptions being considered to withhold.
1. Oracle, SQL Server and IBM DB2.
2. Oracle databases are used in the following applications and functions:
- Geographic Information System
- Intranet
- LDAP Directory
- Automatic Number Plate Recognition
- HR Management System
- Business Intelligence and Analytics
- Interview Transcription
- Vetting Management
- Resource Management
- ICT Incident, Change and Service Request Management
- Legal Case Management
- Professional Standards Case Management
- Covert Operations Management
- Photo ID Management and Printing
- Database Backup and Monitoring
- Vehicle Recovery
- Video Identification
- Prisoner Intelligence
- Custody Management
- Incident Management
- Forensics Case Management
- Traffic Camera Offence Processing
- Document Management System
- Training Management System
- Appraisal System
- Online Submissions Management
SQL Server databases are used in the following applications and functions:
- Active Directory Federation Services
- Payroll and Finance
- Body Worn Video
- Automatic Number Plate Recognition
- Forensic Analytics
- Online Services
- Antivirus
- Fleet management
- Printing and Scannning
- VMWare infrastructure
- Victim's First Customer Relationship Management
- Business Intelligence and Analytics
- Sharepoint
- Interview transcription
- Digital Media Repository
- Password Management
- Statistical Analysis
- Software Deployment
- Police National Database Interface
- Police National Computer Interface
- Skype
- Microsoft System Center Operations Manager
- Firewall and Security
- Call Logging
- Mobility Management
- Asset Management
- Legal Case Management
- Forensic Case Management
3. IBM DB2 is used for email journaling and archiving.
4. All supported internally with the exception of finance and payroll which is now externally hosted.
