[Best Practice] | OceanBase's practice sharing in Jiangxi Human Resources and Social Security Co-ordination System

The national overall reform of basic old-age insurance is a major strategic decision implemented by the party and the state to establish and improve a fairer and more sustainable social security system. On February 14, 2020, the Central Comprehensive Deepening Reform Committee reviewed and approved the reform plan. In the same year, the Ministry of Human Resources and Social Security proposed to complete the construction of the national overall planning system in three years, as a basic project to ensure the smooth implementation of the national overall planning system. The biggest innovation of the national overall planning system is to adopt the "provincial centralization + ministry dispatched to the middle and Taiwan" model on the basis of ensuring that the powers and responsibilities of the central and local governments remain unchanged, and fully respecting the actual business development of each region. The high-level social security system is connected in series to form a set of "big system" that is logically centralized and operating in linkage, and achieves "clearing of headcount" for participation in insurance, "clearing of income" for payment, "clearing of expenditure" for benefits, and "clearing of balance" for funds nationwide.

Jiangxi Province, as one of the 8 pilot provinces, is the first to transform and access the national overall planning information system for endowment insurance. "One account" management, supports real-time risk control and early warning analysis of social security agencies, provides convenient, fast, accurate and efficient social insurance services, and guarantees the basic project of the smooth implementation of the national overall planning system of basic old-age insurance for enterprise employees. Jiangxi People's Society chose OceanBase to realize its localization replacement. Through one-to-one solutions, it brought a series of project benefits to Jiangxi People's Society.

OceanBase Solutions

As the core system related to people's livelihood in Jiangxi Province, the pension planning system has strict requirements on the consistency, high availability, high performance, high compatibility and high stability of database transactions in strengthening social security actuarial capabilities, early warning capabilities and quantitative analysis capabilities. At the same time, as the first centralized system at the provincial level to be connected with the Ministry of Human Resources and Social Security, it requires the unified policy of ministries and provinces, the same risk control strategy, the same source of data, and a single account of national funds and finance, to create a secure data base, and to deliver project delivery. put forward extremely high demands.

1. Quickly adapt to the data of the ministries and provinces, and realize the integrated linkage of the social security data of the provinces and the ministries

OceanBase has the characteristics of high compatibility with P/L SQL (stored procedures, functions, packages), so that the original system of developers can be perfectly adapted when migrating objects and data to meet the consistency and integration of data in ministries and provinces. ization requirements. OceanBase is vertically adapted to the technical specifications of the middle-stage of the pension planning system of the Ministry of Human Resources and Social Security, and synchronizes provincial and ministerial data. Horizontally, zoning planning for personnel numbers and unit codes, docking and connecting with government affairs, taxation, civil affairs, banking and other data, realizing the inclusion of all types of insurance and integration of all businesses, and integrating enterprise pensions, agency pensions, occupational pensions, work-related injuries, unemployment Insurance is integrated into the system, and at the same time, the four major sectors of business, finance, archives and risk control are deeply integrated to achieve integrated linkage. In addition, OceanBase is also fully compatible with the existing database audit software, fortress machine software and BI software of Jiangxi People's Society to ensure the safe and stable operation of Jiangxi Province's pension planning system.

2. The province's social security system achieves financial-level high availability through multi-active deployment

Based on the native distributed architecture, OceanBase provides a multi-active deployment mode for the provincial social security database, and implements three-copy redundancy for the database to achieve high availability with RPO=0, RTO<30 seconds, and meet the strict requirements of financial-level data consistency. Guarantee that Jiangxi Province pension planning system can automatically switch and recover automatically when it encounters a failure.

At the same time, based on the national data center level protection requirements, OceanBase provides off-site backup solutions for social security core data in Jiangxi Province, and conducts regular recovery tests to ensure that data can be restored in the shortest possible time in the event of a data problem. Data base.

3. Provide high-performance guarantee for human and social system based on partition read-write separation technology

The LSM-Tree algorithm adopted by OceanBase improves the processing efficiency of social security transaction data, divides the data into multi-level partitions, provides high concurrent processing capabilities for the centralized human and social system, and meets the province's daily social security requirements. At the same time, the read-write separation technology provided by OceanBase isolates resources from social security statistical analysis and business handling requirements, and realizes high-performance synchronous processing of business, so as to meet the needs of handling business including payment, inquiry, issuance, etc., as well as social security card processing, social security Insurance documents and other services and the output needs of statistical reports in all parts of the province.

4. Online expansion of application transparent migration for new system applications

OceanBase is highly compatible with Oracle syntax, enabling transparent business switching during application migration. At the same time, through the data evaluation, migration, and verification functions provided by OceanBase OMS, the data in the original database can be smoothly switched, so that the Jiangxi Provincial Pension Planning System can be migrated to the new platform efficiently, safely and without damage, and the migration process can achieve data lossless switching.

The non-stop online capacity expansion feature of OceanBase ensures that when the social security core area database encounters a sudden increase in business volume and data volume, the capacity can be flexibly expanded under the premise of non-stop business, the system can easily cope with traffic peaks, and ensure the rapid processing of social security services for enterprises and individuals , to improve the experience of social security services.

5. The OceanBase all-in-one machine realizes the standardization and rapid delivery of software and hardware integration

In order to quickly respond to the requirements of the national localization system, the project has a tight time period and heavy tasks. After careful deployment and rigorous testing by the Jiangxi Provincial Department of Human Resources and Social Security, the database integrated machine that optimizes network architecture and resource scheduling based on the OceanBase native distributed database stands out and realizes The software and hardware integration of the project is delivered, the production environment and the development and testing environment are quickly built, and the automatic standardized delivery from software to hardware of Jiangxi People's Society is facilitated. At the same time, with the full assistance of OceanBase's original 7*24 butler service, the core system of social security business in Jiangxi Province was launched safely and stably as scheduled.

Project income

Jiangxi Province, as the first province in the country, carried out a localization pilot in the national pension insurance national overall planning information system, promoted the localization of the core business database, and won the Ministry of leadership "the first to formulate the overall informatization plan, the first to realize the joint commission of the ministry and the province, and the first to realize the transformation of the localized database. "Highly appreciated. Take the docking transformation as an opportunity to localize the underlying database, so as to avoid re-transformation and investment in localization in the future.

1. Provide Jiangxi experience for national promotion

Jiangxi Province took the lead in using OceanBase, a domestic distributed database system with comprehensive independent intellectual property rights, in the field of human resources and social security. Reference, need to be cautious, its success provides Jiangxi experience for national promotion.

2. Advanced and stable technology

The business modules of the Jiangxi Provincial Pension Planning System, such as agency pension, enterprise pension, work-related injury insurance, unemployment insurance, occupational annuity investment and operation, financial system, and public services, all run stably on OceanBase, ensuring data security and reliability, and using OceanBase for multiple data copies The distributed architecture ensures that the data is foolproof, and 7*24 provides enterprises and individuals with the real-time query function of social security information to ensure the stability and security of the social security data of tens of millions of Jiangxi people. The Jiangxi Human Resources and Social Security Integrated Information System, which integrates online and offline services on self-service terminals, window terminals, PC terminals, and mobile terminals, provides real-time online services and creates social security public services as convenient as "online shopping".

3. The efficiency of the human and social information system has been greatly improved

Compared with the performance of the original database, the business processing time and query time of most business scenarios have been greatly improved, and the generation of the social security collection and payment plan has been reduced from the original 16 hours to about 9 minutes. At the same time, due to the high compression ratio of OceanBase, the project database and hardware costs can be saved by more than 70%.

Through the smooth launch of Jiangxi Human Resources and Social Security Coordination System at the end of 2021 and has been running stably so far, OceanBase has taken the lead in the human resources and social security industry to complete the localized replacement of the provincial social security core system, verifying that OceanBase, as a domestic native distributed database system, can fully guarantee people's livelihood The efficient, stable, safe and uninterrupted operation of the industry's core systems helps the people's livelihood industry to create a secure and reliable data base.

Postscript (the architect's perception)

Zeng Liang, Solution Architect of OceanBase:

With the construction of the integration platform of human and social, the informatization construction of human and social industry has ushered in a peak. At present, OceanBase has completed the adaptation with the synchronization platform issued by the Ministry of Human Resources and Social Security for the central platform and the ministry and the province, and has launched the social security core system and other related business systems in many provinces. As a quasi-financial system related to people's livelihood, the social security system puts forward extremely high requirements on the consistency, stability, high availability and performance of database transactions. OceanBase's strong consistency, multi-tenant management, and compatibility with Oracle and MySQL, HTAP, Key features such as multi-location and multi-active can help customers to build DBaaS platforms efficiently and quickly, and fully realize the replacement of localized databases.