Font Size:
Speech:

Database Management Systems - 1399/20

Date Responded 29 September 2020

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:

  1. What database management systems do you currently use?
  2. What business applications and functions are being supported by each database management system?
  3. Is each database management system supported by an inhouse team or an external company?
  4. 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.

 

 

back to top