Sichuan Provincial Medical Security Bureau

Overview

Sichuan Provincial Medical Security Bureau | Province-Wide Healthcare Data Cloud Migration

Country: China

Industry: Public Sector / Healthcare Administration

Solution: Info2soft’s solution

To support the province’s digital medical insurance transformation, the Sichuan Provincial Medical Security Bureau implemented Info2soft’s solution-based cloud data migration and synchronization solution. The project enabled real-time, lossless healthcare data replication from 22 regional cities to the national medical insurance platform.

Customer Challenge

• Decentralized medical insurance data distributed across 22 regional systems.
• Complex heterogeneous databases requiring schema transformation and standardization.
• Cross-region synchronization issues, including DELETE-to-INSERT conversion.
• The need for real-time, accurate reporting to the national platform without data loss.

I2 Solution

• City-Level Data Migration — Extracted, cleaned, and transformed data from regional social security databases (Oracle 11g/12c/19c) and synchronized them through Info2soft’s solution.
• Provincial-Level Data Reporting — Configured a sync server to incrementally replicate new data from TDSQL sources to MySQL targets every two minutes.
• Specialized DELETE Handling — Captured DELETE operations via TDSQL binlogs and logged them into a dedicated database for automated processing and compliance tracking.
• Settlement Platform Integration — Real-time replication of both full and incremental data into the TBASE system, ensuring instant display on settlement and treatment platforms.

Solution Effects

• Successfully migrated and unified medical insurance data from 22 cities to the provincial cloud platform.
• Achieved real-time, lossless synchronization and reporting to the national insurance platform.
• Ensured data consistency and availability across provincial and national systems.
• Established a reliable, fault-tolerant architecture supporting healthcare data security and continuity.