SUCCESS STORYCIV

Actian Ingres Database

CustomerCIV –a subsidiary of the Dutch Police and a center of excellence for football hooligan management.

IndustryPublic Sector

Challenge› Centralize information on instances of football hooliganism across Europe

› Proactively manage and protect people attending games

Solution

› Actian Ingres Database

› Actian Ingres OpenROAD

› Elegance

Benefits› The Hooligan Database`(VVS) is now the authority on football related violence

› VVS can be used to map previous incidents

› VVS can predict and potentially prevent future incidents

Keeping European Football Safe is the “Goal” for Actian Ingres Database

“For the Euro 2000 Football tournament in the Netherlands we were looking for a way to register football hooligans to proactively defend against violence. Particularly, we looked to record, register and process images of hooligans for future reference.”

Anton Kunenborg, IT Analyst CIV

HighlightsIn early 1997, prior to the Euro 2000 football tournament co-hosted by The Netherlands and Belgium; mayors of large Dutch cities, the royal commissionaires, the Dutch police, public prosecutors, and the Dutch Football League (KNVB in Dutch) recognized the need for a single record of football related violence to monitor the activities of a relatively small group of violent offenders, widely known as “football hooligans.”

As records of previous violence and its perpetrators are disparate and reside within various organizations across the Netherlands and the world, a single database with the ability to provide secure access for law enforcement agencies, governments, border control etc., was a key weapon in preventing football violence.

The database has become a mission critical tool for not only the Dutch authorities, but also the wider European community to fight hooliganism and make football safe for all those that wish to attend games.

ChallengeThe CIV is a subsidiary of the Dutch Police and a center of excellence for football hooligan management. It was created in 1986 after particular heavy riots and violence related to football.

The CIV knew that it needed to find a way to track previous football related violence, maintain a record of trends among offenders, and keep a database of all known football hooligans. As a result it created the Hooligan Tracking System (VVS in Dutch) to gather information regarding incidents of violence, hooligans’ backgrounds, effects of actions, previous convictions, and trends in behavior.

Cost management is key to any IT project in the public sector. The ability to integrate and allow access to the system was central to its success as a national and pan-European knowledgebase. As Hooligans travel through Europe for games, the VVS also understood the important of supporting multiple European languages, using Dutch and English as the default languages.

Success StoryThe Dutch Government has embraced open source solutions as a key element of its innovation strategy. Starting as a strong recommendation in 2005 and pronounced mandatory in 2009, the Dutch Government mandates that open source software must be considered as a potential equal alternative to closed source software in public tenders.

With this in mind, CIV approached the market with a specific requirement for a socially valuable project that could be powered by open source technology.

SolutionCIV worked with Ingres partner, Elegant ICT, to create a reliable database to support the work of law enforcement agencies in Europe by providing a platform for the exchange of information concerning international football matches. The Hooligan Tracking System was first released in 1997.

To be able to meet all the functional, technical and financial criteria, Elegant ICT developed the Ingres modeling tool Elegance, written in Ingres OpenROAD, which automates the data modeling and application generation process based upon user specifications. The migration project to Ingres Database and Ingres OpenROAD was successfully implemented in April 2009. European regulations require all local IFIP’s (International Football Information Points) take measures to deal with football related hooliganism. One of the tools at hand is a website that reveals the relevant information to its (limited by-authorization) users across Europe. VVS is one of the trustworthy sources that is used by this website.

ResultsThe VVS database holds information related to all football matches in the Netherlands such as dates, schedules, locations, crowd numbers, as well as data on persons linked to football related violence. VVS is now recognized by European courts as a trustworthy source to cite in conclusions and rulings. It is considered to be the most advanced and one-of-a kind solution that supports the process of arrest-hold-prosecute-convict hooligans to all the involved chain partners. The ability to predict the violence-risk factor of future football matches is one of the new features of VVS. On the basis of these predictions, law enforcement and others can help prevent and control a potential outburst of violence.

Over the past decade the VVS has seen impressive results in terms of Cost of Ownership. The reduction in maintenance costs due to its stability has ensured that VVS is considered a best practice example of how government agencies can reduce costs without stifling innovation but continue to protect its citizens.

SUCCESS STORYCIV

About Actian: Incite ActionActian Corporation (formerly Ingres Corp.) is the first to unveil a Cloud Action Platformfor building Action Apps. Action Apps are lightweight consumer-style applications that automate business actions triggered by real-time changes in data. Actian products incite action at more than 10,000 customers worldwide by driving their mission critical workloads and providing rapid action insights to their data. Actian is headquartered in Redwood City, California with offices in New York, London, Paris, Frankfurt, Amsterdam, and Melbourne.

Actian Corporation500 ARGUELLO STREET SUITE 200REDWOOD CITY CALIFORNIA 94063USAPHONE: +1.650.587.5500

Actian Europe Limited217 BATH ROADSLOUGHBERKSHIRE, SL1 4AAUNITED KINGDOMPHONE: +44 (0)1753 559500

Actian Germany GmbHOHMSTRASSE 1263225 LANGENGERMANYPHONE: +49 (0) 6103.9881.0

WEIMARER STR. 1AD-98693 ILMENAUGERMANYPHONE: +49 (0) 3677.6785.0

Actian France7C PLACE DU DÔMEIMMEUBLE ELYSÉES LA DÉFENSE92056 PARIS LA DÉFENSE CEDEXFRANCEPHONE: +33 (0) 1.72.75.74.54

Actian Australia Pty LtdLEVEL 8, SUITE 1616 ST. KILDA ROADMELBOURNE, VICTORIA, 3004AUSTRALIAPHONE: +61 3 8530.1700

ACTIAN.COMFOR MORE INFORMATION, CONTACT ACTIAN@ACTIAN.COM

©2011 Actian Corporation. All rights reserved. Printed in the U.S.A. Actian, Cloud Action Platform, Ingres, and Vectorwise are trademarks of Actian Corporation. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. S

S-7

35

A

SUCCESS STORYCIV