The Danish Directorate of Fisheries tames a sea of data to gain upper hand in EU fishing industry

Challenge
Provide Danish representatives with superior data to give them the edge in EU fish quota negotiations.

Solution
The Danish Directorate of Fisheries runs SAS on HP Integrity Servers with Intel® Itanium® 2 processors

Benefits
Increased performance 10-fold and makes reports easier to access throughout the organization

Supplying accurate and easy-to-use data on fish catches, the Danish Directorate of Fisheries (DDF) keeps Danish negotiators ahead of the game when hammering out EU regulations and quotas. The data is vast, covering fish numbers and species landed in 340 locations across Denmark. The information must be available quickly, the data accurate and the reports easy to use by control personnel, planning staff, EU negotiators and fishermen.

In the constantly shifting environment of fishing quotas, SAS and HP work together to provide super-swift number crunching in a flexible, userfriendly form. Gert Thostrup, Deputy IT Chief at the DDF, explains, “We collect data from several different sources: catch figures from vessels and fishermen; and sales notes from auctions, sales companies and other people trading fish. As the only department that compiles statistics in this area for the Danish Statistics Bureau, we need solutions that can really help us. We looked around the market and chose SAS because it is the best when working with large amounts of data.”

The DDF has created a powerful system to fit its needs – a combination of SAS and a legacy transaction system, running on Intel-powered HP Integrity Servers. “We have designed a set up that suits us. We use a legacy transaction system to register incoming data and SAS for deep data analyses on both the vertical and horizontal level.”

The DDF is constantly searching for improvements. And, with SAS and HP, they are able to achieve them. Thostrup says, “If our users say response times are slow then our goal is to come up with a solution. We have to make sure we have a sufficient solution in place.”

The best combination in the EU
Running SAS products on HP Integrity Servers has helped the DDF earn a reputation as one of the best, swiftest and most accurate reporters in the EU. A large part of this success has come from a long-lasting relationship with SAS and HP.

“We are known to have some of the best data and data quality in the EU,” says Thostrup. “Data quality and reporting efficiency are extremely important to us. And it is essential that we ensure that the reports we make are correct. This gives us influence in the EU when negotiating and guiding future decisions.”

As well as reassuring the EU that Denmark’s fishermen are within their quotas, the DDF analyses data for implicit meaning, trying to spot trends in fish species. “We have to be able to use our data to see where we’ll be in two or three years’ time. We can predict and solve problems before most other countries even begin looking at them. One of the ways to do this is to make systems and reports that outline patterns that no one else has seen.”

Quick responses to shifting tides

Fisheries is an ever-changing area and the DDF is fighting a constant battle to stay on top. Fish quotas change often and new laws or EU regulations continually change. When a law change takes effect, either locally or in the EU, the DDF has to make sure fishermen are complying. This means having reporting processes that respond rapidly, without losing quality.

Paragraph 20 in Danish law is an added pressure. If a Minister of Parliament is asked a question in Parliament, they have to come up with an answer within six working days. And if the question is related to fish, the DDF is one of the main partners providing the Minister with the necessary information and answers.

Performing within budget

As a government institution, the DDF is constantly pressed to keep costs in check, so it’s vital that its inspectors can work as independently as possible.

Thostrup says, “Our reports are used by control personnel to select the companies and vessels that they are going to inspect. We have other reports that collect certain data to help inspectors see if there are any abnormalities. Inspectors can access reports from their laptops connected via a telephone line or mobile, so they can work away from the fixed office.

As with every government office, we face cost reductions and so we want to give our control, planning, and reporting personnel tools that enable them to do things themselves, better and easier.”

SAS® BI Server brings greater agility

Since 1995, SAS has been working with the DDF to bring greater flexibility and mobility to inspectors. SAS BI Server will make this even easier. The new solution gives the DDF the ability to make reports available to a broader group of users. And they can now combine data, such as fish stocks and actual control information, which makes access easier and gives the user further access to make analyses themselves.

Designed for functionality and adaptability, SAS BI Server provides Webbased report building and viewing in a drag and drop environment. Users don’t have to be able to programme to alter parameters or add functions. With the SAS Add-in for Microsoft Office, it also makes intergration with Microsoft – Word, Excel and PowerPoint – more accessible and simpler to use, throughout the organization. Users make their own data requests over the Internet. The DDF inspectors can access the information and compile data analysis before they get onto a boat.

HP and Intel® Itanium® 2 processor enhances performance and reduces costs
Last year, the DDF changed to HP Integrity Servers utilizing the Intel® Itanium® 2 processors, enabling it to take full advantage of 64-bit architecture. The decision to invest in this was driven by a desire to maintain the DDF’s position as a Fisheries Directorate at the cutting-edge of technology. Results have been beyond expectations.

“The HP Integrity Server raised performance by at least a factor of 10,” says Thostrup. “We had a program that started at 11 p.m. and ran until 2 or 3 a.m. After changing to HP Integrity Servers, our users came to us and said, ‘We have some problems, it has the wrong date, it’s yesterday’s date’. When we looked at it, we discovered that it was performing the job before midnight. It cut the time from four hours to less than one. This was all without making any job setup changes.”

And the change has seen a reduction in costs. “We had to pay a lot for support and upkeep on the old machines. We made an investment calculation and realized that with tax breaks we’d get return on our investment in two and a half years. In addition, the Itanium 2 processor is in a lower price bracket than our last one.”

SAS, HP and Intel – a powerful combination
The combination of SAS and the HP Integrity Server with Intel® Itanium® 2 processors gives an unbeatable solution for companies and organizations dealing with vast amounts of data. For the future, the Itanium 2 processor makes SAS solutions even more scalable and flexible.

High-level cooperation for the long-term
With an advisory role in the statistics department, SAS is helping the DDF maintain its international reputation for quality statistics. When looking to the future, the DDF wants to be leading the world in fisheries reporting, driving new programmes and influencing fish quota decisions.

Thostrup concludes, “We are working with SAS at a high level and will stick with it in the future. We are looking at a new risk control strategy – what are the risks of someone breaking the regulations and how can we predict that statistically? It’s all about controlling fisheries and ensuring that people don’t break the rules. This is a perfect task for SAS.”