一种面向社保领域的数据清洗整合系统架构

An Architecture Oriented Social Insurance System for Data Cleaning and Integrating

昆明市社会保险管理系统包括医疗、养老、失业、工伤和生育五大业务子系统,由于信息化建设进程的前后不一致导致五大业务子系统之间数据的不一致;因此对五险数据进行清洗与整合、建立五险公共数据库势在必行。针对社保领域的数据质量问题,设计了数据清洗整合系统架构;该系统架构分为五个层次,分别是公共交易数据库层、同步数据层、数据清洗与整合层、公共数据库层、报表展现层。

Due to the inconsistencies of data between the five operational sub-systems in the process of information building,the Kunming social insurance management system,including the five operational sub-systems,the medical insurance system,retirement insurance system,unemployment insurance system and work injury and maternity insurance system need to be integrated.Aims to build a frame of data cleasing and integrating system the problem in the social insurance system is solved.The system architecture is included five levels：public transactions database layer,synchronize data layer,data cleansing and integration layer,public database layer.