Skip to content
Search to learn about InterSystems products and solutions, career opportunities, and more.

InterSystems Caché ensures SmartWater-based forensic evidence is watertight

software developer working at a large computer

COMPANY: SmartWater Technology Ltd

CHALLENGE: Introduce a new production management database for the manufacture and user registration of its DNA-style SmartWater® system.

OUTCOME: Thanks to InterSystems and Xebec Information Systems Ltd, SmartWater has a new solution that’s reliable, fast, cost-effective, and scalable.

Will the evidence stand up in court? When SmartWater Technology Ltd wanted to introduce a new production management database for the manufacture and user registration of its DNA-style SmartWater® system, the evidential trail had to remain watertight. But thanks to InterSystems and Xebec Information Systems Ltd, SmartWater has a new solution that’s reliable, fast, cost-effective, and scalable.

SmartWater Technology Ltd was founded in 1996. As one of the most powerful crime deterrents in the world, its SmartWater property-marking and anti-criminal spray contains a unique chemical marker. With a billion possible forensic combinations and detectors installed in police stations across the UK, SmartWater has a 100% conviction rate when presented as evidence in court. Criminals know that, when SmartWater is deployed, they will be physically and undeniably linked to the crime. As a result, they try very hard to avoid it which adds to SmartWater’s success.

Before implementing the new computing solution using InterSystems Caché® database technology, SmartWater relied on paperwork, a database, spreadsheets, and filing cabinets. Continuity of evidence was of critical importance with production steps signed off, control samples retained, and end user registrations recorded. By 2007, SmartWater was feeling the pressure.

“The ramp-up in volume was our biggest headache. We knew that, as the insurance industry started to come on board, the volumes would go through the roof,” said Chief Executive Officer Phil Cleary. “We simply could not continue to rely on the existing semi-manual systems.”

Demanding requirements

A replacement production management system was needed to provide security, robustness, and scalability yet remain flexible for future innovations. The technical requirements seemed impossibly high thanks to the need for item traceability.

“We wanted a database capable of storing all the SmartWater combinations that we could possibly make – that’s a billion. It needed to take a large amount of data in and deal with the many steps throughout the process,” said Cleary.

If that wasn't enough, SmartWater also required an “incredibly user friendly” and fast graphical front-end that makes it easy for production staff to record data consistently, sign-off key production steps, and track each batch in detail.

Following a personal recommendation, SmartWater contacted Xebec Information Systems Ltd which proposed a solution based on InterSystems Caché, the world’s fastest object database, to develop new production systems. But what made this proposal suitable?

“It was the way that Xebec Information Systems was going to design the database using Caché to deal with the large number of individual SmartWater combinations and track them through all their processes in a secure fashion,” said Cleary.

Xebec Information Systems then undertook bespoke consultancy services including project management, business analysis, software and architecture design through to implementation and ongoing technical knowledge transfer.

“Xebec worked very closely with us and spent a lot of time trying to understand what we were doing,” said Cleary. “We’ve been delighted with the work they have done.”

Powerful database technology

The new system makes use of features in the Caché Advanced Security system to provide a fully-customisable and comprehensively secure environment with a tamper-resistant audit trail.

[callout_box width="250px" align="left"]

Key Benefits

  • Fast, robust, and secure
  • Highly scalable
  • Easy to use


Thanks to Caché’s object storage, SmartWater could create a customised data structure to meet its complex requirements, yet use standard SQL reporting. In fact, Caché’s high-performance object database runs SQL five times faster than relational databases. A key Caché component, InterSystems Zen (an AJAX framework that automatically joins the user interface to the database), enabled the rapid development of application screens rich in functionality within an easy to deploy web-browser environment.

Installed on-time in November 2007, the new solution was implemented in modules. The Caché database on a shared server is linked to the production department. Production staff no longer needed to complete paperwork: instead they use the new solution’s intuitive screens with barcode readers for the whole production process. This enables them to easily handle the 20,000 unique batches-per-month production cycle.

The highly-reliable Caché database maintains integrity of the evidential trail, recording all activities. Thanks to the speed of development and deployment coupled with the ease of use of InterSystems’ software, the new applications have proved “very cost-effective”. The total cost of ownership is further reduced by minimal requirements for database administration and superior application performance with modest hardware demands.

The Caché-based system comes into its own when SmartWater receives samples for analysis. Minute SmartWater traces can irrefutably link property to its rightful owner or tie criminals to a crime scene. This makes it a superb tool for police forces wanting to solve crime or return stolen items. As a result, it is actively avoided by criminals, making SmartWater a formidable crime deterrent.

“As soon as we have analysed the sample, we come up with its unique reference number. The system turns out a hardcopy report,” said Cleary. “What impresses me is the ability to show the court everybody who has been involved in the process even down to the minute they worked on any given SmartWater solution.”

Monthly production is now set to rise ten-fold over the next few years as SmartWater is taken up by the insurance industry to protect premises and property. The solution developed by Xebec Information Systems will help staff continue to cross the t’s and dot the i’s with unprecedented attention to detail. And Caché’s rapid application development environment will ensure that future enhancements will be quickly delivered as business needs change.

“Scalability in terms of the future growth of the business is important to our work,” said Cleary. “Using InterSystems products gave us a solution that allowed us to work in a smarter way. What we’re now looking to do is move this on from production, through to fulfillment, customer relationships, invoicing, and accounts. It’s eventually going to be a complete end-to-end solution based on InterSystems technology.”

Jonathan Selby, Managing Director, InterSystems UK concluded, “We are delighted that InterSystems Caché plays an important role in SmartWater’s manufacturing and distribution process ensuring the solution was built and delivered rapidly and is secure, reliable, and scalable. SmartWater is a game-changing initiative for the security of assets and court evidence. Most importantly, criminals are discovering the effectiveness of SmartWater and they view it as a deterrent.”


Other Success Stories You Might Like

Innovative Mobile Solution for Municipal Government Operations Leverages CACHÉ Database System to Cut Costs While Delivering Access to Public Information Anywhere, Any Time Point Software, Inc. of East Longmeadow, Massachusetts, has been recognized with the InterSystems Award for Breakthrough Applications. Point Software received the award for DocumentLink™, an integrated suite of groundbreaking, Web-based applications developed to end the paper chase that is straining the resources of municipal governments countrywide. Running on a range of mobile platforms including tablets and smartphones as well as notebooks, DocumentLink provides government workers and the public with easy, secure, access to forms and documents in the cloud at any time from any location.
When new laws resulted in sweeping reforms of Belgium's police forces, the federal police were tasked with creating a single computing hardware and software architecture that they, and agents in all 195 of Belgium's local police zones, would share. For the core data management and application infrastructure, the federal police chose Caché.

Take The Next Step

We’d love to talk. Fill in some details and we’ll be in touch.
*Required Fields
Highlighted fields are required
*Required Fields
Highlighted fields are required

By submitting your business contact information to InterSystems through this form, you acknowledge and agree that InterSystems may process this information, for the purpose of fulfilling your submission, through a system hosted in the United States, but maintained consistent with any applicable data protection laws.

** By selecting yes, you give consent to be contacted for news, updates and other marketing purposes related to existing and future InterSystems products and events. In addition, you consent to your business contact information being entered into our CRM solution that is hosted in the United States, but maintained consistent with applicable data protection laws.