Our consultants were responsible for all Oracle DBA and Oracle development work for a GIS project with South Yorkshire Police. The original system was developed on an Ingres based system, for another Police force, and we were responsible for setting up the same system under Oracle and Solaris 2.3, along with transferring tables, data, triggers etc. from Ingres to Oracle. We used CA-Openroad for the interface between the GIS application and the Oracle database, and then set up a replication site using Oracle Replication

The Operational Response System (COMRAD) is used as a front line response system, and as such all calls, including 999 calls, are passed through and handled by the COMRAD system. This means that the system is required to be live 24 hours a day, 365 days a year, with the minimum of operational down time.

The system is based on a SUN Sparc solution consisting of two main server sites and five satellite sites. The satellite sites being control rooms in other districts. The configuration that the system is currently based on is that the two main sites each have one Sparc 1000 server with 4 processors, one Sparc 20 with 2 processors and two RAID arrays. One site is an update site, where all terminals requiring the ability to edit data connect to, the other site being for terminals requiring access to the COMRAD system for MIS purposes. The Sparc 20 servers at each site are standby servers in the case of a failure of a Sparc 1000. The two RAID devices at each site are mirrored to provide maximum fault tolerance. At each satellite office one of the workstations is configured with an additional external disk, which acts as a local GIS server.      

Sheffield                                                                                 Barnsley