【作者】 李强；

【导师】 赵朋朋；

【作者基本信息】 苏州大学 ， 软件工程（专业学位）， 2019， 硕士

【摘要】 随着信息化时代的到来,数据安全、分配是政府部门、企业、个人等都非常关心的一个话题。尤其是涉及到敏感数据,比如国家机密、公司的内部机密等等,这些敏感信息的安全显得更为重要。如果没有定期的数据备份,一旦发生灾难或者意外导致数据受损,那么后果不堪设想。所以数据复制同步技术显得极为重要。IBM的DB2数据库作为市场主流数据库之一,尤其在企业级的应用尤为广泛。基于DB2的复制技术对于企业来说显得非常重要。本文介绍了数据库基本概念并分析研究对比了基于DB2的不同复制方式的优缺点。对DB2数据复制过程中,数据源注册、控制表建立、订阅集设计以及数据的抓取及应用进行了分析归纳,最终实现了基于DB2的实时复制系统。并对常见的故障进行了分析并提供了解决方案。此系统是完全基于日志来实现的数据复制,无需安装除DB2数据库以外的软件。并且可适用范围广,不仅支持DB2数据库,还支持非DB2的关系型数据库同DB2之间的数据复制。最后经测试后,达到了预期的目标。更多还原

【Abstract】 With the advent of the information age,data security and distribution are a topic of great concern to government departments,enterprises and individuals.Especially when it comes to sensitive data,such as state secrets,internal corporate information,etc.,the security of these data is even more important.If there are no recent backup images,when the disaster or accident causes data damage,it will make a very huge impact.Therefore,data replication synchronization technology is extremely important.IBM’s DB2 database is one of the mainstream databases in the market,especially at the enterprise level.Replication technology based on DB2 is very important for enterprises.This paper introduces the basic concepts of the database and the comparison of the advantages and disadvantages of different replication methods based on DB2.During the process of DB2 data replication,data source registration,control table establishment,subscription set design,data grabbing and application are analyzed and summarized,and finally DB2-based real-time replication system is realized.It also analyzes common faults and provides solutions.This system is a data replication based entirely on logs,eliminating the need to install software other than the DB2 database.So,it can be applied in a wide range.In addition to the DB2 database,it also supports data replication between non-DB2 relational databases and DB2.After the final test,the expected goal was achieved.更多还原