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.