Case Study: Development of a Casualty Database


CWGC Logo


Services
IT Development
Support & Maintenance

Technologies
.NET
SQL Server

Sector
Restoration
Commemoration
Government

Triad designed and delivered, within budget, a tailored solution that enabled the Commonwealth War Graves Commission to increase productivity and provide a platform for future development.


Background

Established by Royal Charter in 1917, the Commonwealth War Graves Commission (“the Commission”) pays tribute to the men and women of the Commonwealth forces who died in the two world wars. An essential part of the Commission’s work is to maintain records of the war dead and the principal means of accessing this information is through the Casualty Database (CDB).

Triad undertook the full project delivery lifecycle, from the requirements analysis through to the design and on into development, test and rollout. The development of the site made use of industry standard architecture.

Improving user experience

The Commission required a web based system for the secure and rapid electronic dissemination of 2M casualty records to the CDB users. These users needed to find casualty and cemetery information efficiently, to produce reports of their data and to manage enquiries from members of the public. Triad produced innovative ways to query the database, introducing type-ahead fields and custom multi-value drop lists in search screens to ensure that the users were able to access their data in exactly the way they needed.

Modern technology

The development of the site made use of industry standard architecture, utilizing the MVC pattern for optimal reuse of coding to ensure that the code was fully extensible for future iterations of development. The underlying platform made use of SQL Server 2008 and Reporting Services to provide the Commission with a robust database solution that allowed them to query the data in a simple manner. Third party components were used where feasible to ensure that the Commission achieved the greatest value for money.

Outcome

The Casualty Database went live on time, and within budget. Since then, Triad and the Commission have worked together to support the Commission’s user base across the world. The Commission continues to invest in technology to provide additional functionality to enhance the application. Triad has been supporting the Commission through the provision of hands-on development, as well as passing on experiences from their other clients that may benefit the Commission.

"I would like to take this opportunity to thank you and everyone who has worked on this project at Triad, for your help in seeing it through. I have been very impressed by the professionalism and commitment shown by you and the rest of your team and I look forward to continuing to collaborate on future developments of the Casualty Database." Bernard McGee - Director of Information Services