Swiss State Secretariat for Economic Affairs Enhances Labor Market Data Analysis with Pivotal Greenplum Database
公司规模
Large Corporate
地区
- Europe
国家
- Switzerland
产品
- Pivotal Greenplum Database
技术栈
- Massively Parallel Processing (MPP)
实施规模
- Enterprise-wide Deployment
影响指标
- Cost Savings
- Productivity Improvements
技术
- 平台即服务 (PaaS) - 数据管理平台
适用功能
- 商业运营
服务
- 系统集成
关于客户
The Swiss State Secretariat for Economic Affairs (SECO) is a key governmental body in Switzerland responsible for economic policy, labor market policy, and trade policy. It plays a crucial role in managing the country's economic affairs, including the implementation of labor market policies. SECO oversees the Labor Market Statistics department, which is tasked with providing up-to-date information and flexible analysis options for statistical observations. These observations are used for various purposes, such as short-term economic indicators and ensuring the correct execution of the Unemployment Insurance Act. SECO's user community is complex and heterogeneous, comprising approximately 900 users, including responsible federal offices, employees of 120 regional offices (RAV) of the national employment service across 26 Swiss cantons, and more than 40 unemployment insurance funds. This diverse user base reflects the federal system of Switzerland and requires a robust and flexible business intelligence system to meet their varied needs.
挑战
Managing Performance Problems\nDue to increasing requirements regarding labor market statistics, SECO initiated the LAMDA (Labor Market Data Analysis) project. A number of business intelligence applications were implemented for several purposes – for example, the official labor market statistics, the statistics of payments executed by unemployment insurers, the key performance index for regional office executives and an application for public information regarding unemployment. Many of these applications required complex calculations.\n\nA more complex analysis requires a new infrastructure, as Dr. Elmar Benelli, Data Warehouse LAMDA Manager at SECO, explains, “We experienced increasing performance problems. With the existing infrastructure, such problems would have been manageable only with substantial effort and expenditures. The limiting factors were the physical separation of the database system and the data, as well as the data transport across the network, which is also used by other parties.”
解决方案
Pivotal Greenplum Database Delivers Speed and Flexibility\nAs a new database solution to cover Big Data requirements, Pivotal Greenplum Database replaced the legacy database to handle all Swiss labor market statistics.\n\nPivotal Greenplum Database operates with massively parallel processing (MPP), offers flexible scalability, and can be operated with various hardware platforms. Utilizing Pivotal Greenplum Database, the Swiss State Secretariat for Economic Affairs is now able to provide analyses to the user community faster and with greater flexibility.\n\nBUSINESS BENEFITS\nGreater Performance\n“We experienced massive front end performance increases with Pivotal Greenplum Database. Even in case of complex queries, the results are displayed quickly,” Benelli confirms.\n\n“Copying of the database now goes extremely quickly,” Benelli adds. “Previously, the preparation of a separate database for test and development purposes, or special analyses with high performance requirements, took the data warehouse team two weeks. With Pivotal Greenplum Database, all it takes is copying, which can be done in 20 minutes.”\n\nLow Cost of Ownership\n“Pivotal Greenplum Database provides the hardware flexibility we needed,” Benelli points out. “It enables operation on low cost, industry-standard servers that can be easily acquired from the usual government suppliers. So we will remain flexible and independent of a specific hardware provider in the future as well. Other solutions we evaluated included proprietary components that would not allow such flexibility.”
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
