masthead-resources

Key Benefits

  • High Performance
  • Scalability
  • Microsoft Windows NT

stock-p8Anything that slows the course of government impedes the business of running a country. The Department of Justice of the state of Bern in Switzerland, therefore, had a serious problem. The department’s Sybase database management system was taking well over a day to process the data entered into the system.

“We had been using a Sybase database to run our systems for two years,” said Rolf Streb, IT manager for Bern’s Department of Justice, the branch of the Swiss government responsible for the infrastructure and organization of the court systems. “We had a lot of performance and scalability problems.” Specifically, the Sybase system couldn’t handle the department’s transaction load – up to half a million transactions a day.

Running on the same hardware that supported the Sybase system, Caché is 100 times faster handling transactions, and 20 times faster than Sybase overall.

Rolf Streb, IT Manager
Department of Justice, Bern

As do most IT managers, Streb keeps himself apprised of technologies. He became intrigued by Caché, InterSystems’ database that uses a multidimensional data model and advanced object technology for high-performance complex transaction-processing applications. Streb decided to evaluate Caché head-to-head against applications using Sybase.

Following a six-month evaluation, Streb and his team decided to scrap their Sybase database for Caché. They ported the department’s Tribuna 2000 application that regulates all aspects of the department’s business to Caché without changing a single line of the application’s code.

“The greatest business benefit have been the performance gains'” said Streb. “Running on the same hardware that supported the Sybase system, Caché is 100 times faster handling transactions, and 20 times faster than Sybase overall.

With Caché, we are getting a much faster system that enables us to be 20-100 times more faster, is much easier to maintain, and takes far less system administration.

Rolf Streb, IT Manager
Department of Justice, Bern

“We run our systems in pure SQL,” Streb continued. “We found Caché much easier to maintain than Sybase. Caché’s multidimensional model provides dual access to objects and tables, it’s easier to modify, and has more scalability.”

The department’s system runs on Digital servers and 1,400 Digital PC clients installed in 43 locations around the state on a distributed database. An Ethernet backbone with Caché implemented on the servers and ODBC on the clients rounds out the system.

Caché has proven a good investment for Streb and the Department of Justice. “With Caché , we are getting a much faster system that enables us to be 20-100 times faster, is much easier to maintain, and takes far less system administration.”