Development of a web based database for storing large quantities of data related to vehicle assets.

Synopsis

The client required development of a web based database for storing large quantities of data related to their vehicle assets, including information such as certification, documentation and safety hazards, amongst others. Existing client data also needed to be migrated on to the new system. A web site and supporting database structure and system maintenance was required to ensure reliable access for the client.

The client required expertise in developing and maintaining a Structured Query language (SQL) server database architecture that was capable of being deployed over the internet to allow a wide range of users to access the information. Corus has substantial experience of developing solutions of this nature to support steel production facilities and maintaining these to a high standard, ensuring that the IT aspect does not cause process delays.

Key Client Issues

• Wide geographical spread of users
• Users on different networks therefore unable to access common data store
• Lack of in-house experience of developing suitable database architecture for internet deployment
• Large volumes of data required by different users

Solutions

The solution involved migrating the clients existing data, deploying a web site and supporting database structure and maintaining the system to ensure the client had reliable access. Key deliverables were:

• An SQL database building on the client’s prototype
• A hosted website available for 24/7 access

Client Benefits

• Dissemination of key information related to vehicle assets to users spread over a wide geographical area
• Maintaining control over stored data through agreed access control and protocols
• Data is maintained on an electronically and physically secure server which ensures that business critical data is safe and frequently backed up