Hunan Social Insurance Management and Service Bureau Reduces Total Cost of Ownership and Accelerates Database Performance by 30x
 
 

Hunan Social Insurance Management and Service Bureau Reduces Total Cost of Ownership and Accelerates Database Performance by 30x

Hunan Social Insurance Management and Service Bureau provides guidance and manages all pension insurance-related activities, such as processing or terminating social insurance payments made to rural farmers, businesses, and government employees in China’s Hunan province. The Social Security Department of Hunan Province manages the bureau.

From 2006 to 2010, Hunan Social Insurance Management and Service Bureau began to centralize its municipal social insurance database. In 2011, the bureau began to consolidate its database platform for Hunan province after the launch of China’s 12th, five-year plan. The project’s goal was to centralize pension insurance data relating to company employees and rural farmers on the provincial level.

 
 

 
 

Challenges

A word from Hunan Social Insurance Management and Service Bureau

  • “After considering other vendors, including IBM, we chose Oracle Exadata because it is the most cost-effective and high-performing integrated hardware and software solution. We have accelerated overall database performance for processing pension insurance by 30x, saved US$80,000 in annual IT maintenance costs, increased operational efficiency, and reduced the total cost of ownership." – Tang Wangjing, Deputy Director General, Business Guidance Department, Hunan Social Insurance Management and Service Bureau

  • Consolidate 14 databases into a single database platform to improve processing pension insurance data for more than 8 million company employees and 38.5 million rural farmers
  • Implement a highly performing, highly available, and scalable pension insurance database platform to increase operational efficiency and reduce the total cost of ownership
  • Prevent illegal access to sensitive data and loss of data in the pension insurance information system

Solutions

  • Increased operating efficiency by processing its employee pension insurance data 60x faster and rural farmers’ pension insurance data 48x faster
  • Reduced hardware and software license costs by 30%, data center energy costs by 50%, and floor space requirements by 67% with Oracle Exadata Database Machine
  • Cut yearly data center maintenance costs by more than US$80,000 by consolidating 14 pension insurance databases running on legacy HP servers and an EMC storage system into a single, preconfigured engineered system
  • Accelerated overall database performance by 30x and achieved real-time pension insurance data sharing for company employees across 14 cities and rural farmers in 100 districts and counties
  • Completed account settlements 50x faster and processed 8 million transactions in less than four hours, providing better service to citizens 
  • Reduced time taken for processing monthly account settlements for company employees and rural farmers’ pension insurance from eight hours to just 15 minutes by accelerating batch processing speeds up to 12x faster, improving staff productivity
  • Improved online-transactional processing (OLTP) for centralizing social security data in Hunan province, enabling smooth operations for processing 20,000 transactions for company employees pension insurance and 150,000 transactions for rural farmers’ pension insurance, during peak hours, daily, increasing citizen satisfaction
  • Enabled simultaneous data processing for rural farmers’ pension insurance payments across 100 districts and counties by using Oracle Exadata Smart Flash Cache and eliminating previous system bottlenecks
  • Enabled rapid upgrade to next rack size as database grows by two terabytes annually, providing a cost-effective and scalable platform
  • Ensured data security and business continuity by using Oracle Active Data Guard’s backup and recovery features across two back-up sites, enabling real-time data protection and availability of pension insurance database
  • Strengthened database audit operations and eliminated risk of disclosing sensitive data by automatically detecting and alerting administrators of suspicious activities, such as multiple access failures, thanks to Oracle Audit Vault and Database Firewall

Why Oracle

After considering the functionality and expert reviews of various solutions, Hunan Social Insurance Management and Service Bureau selected Oracle Exadata Database Machine because it provides an integrated hardware and software solution. Its extreme performance and lower cost of ownership were important factors in the decision process.

“We considered other vendors, including IBM, but they primarily offered mainframe and micro-computer solutions. Oracle Exadata is the most cost-effective hardware and software solution that offers extreme OLTP performance and enables us to accelerate processing speeds for large and complex pension insurance data,” said Tang Wangjing, deputy director, general of business guidance department, Hunan Social Insurance Management and Service Bureau.

Implementation Process

Hunan Social Insurance Management and Service Bureau went live on Oracle Exadata in June 2013.The data migration included data from the pension insurance management application for provincial government, financial management application for company employees in Hunan Province, pension insurance application for company employees in Changsha City, new rural farmers’ pension insurance application for Hunan Province, and other applications.

“We migrated Hunan provincial government data in just two days and gained a rapid return on investment,” Tang said.