[工学]_论文_分布式数据库中主键唯一性.doc

本科生毕业论文（设计） 题 目 一种分布式数据库中主键唯一性生成方法 学 院 软件学院 专 业 网络安全 学生姓名 潘昱成 　 学 号 0743111001 年级 指导教师 刘晓洁 教务处制表 二Ο一一 年 五 月 一种分布式数据库中主键唯一性生成方法 专业 网络安全 学生 潘昱成 指导教师 刘晓洁 [摘要] 分布式数据库，是在集中式数据库基础上发展起来的。随着当今社会的发展，数据呈现爆炸式增长。在面对海量数据处理时，集中式计算渐露疲态，分布式计算 A Method of the Unique Primary Key Generation Method in Distributed Database Network Security Student： Yucheng Pan Adviser: Xiaojie Liu [Abstract] Distributed database is developed based on the centralized database. With the development of society, data shows explosive growth. In the face of massive data processing, distributed computing will replace centralized computing gradually. In a centralized database, the primary key uniqueness is easier to guarantee, but in a distributed environment, it is more difficult to ensure the uniqueness of data in databases which are dispersed in different regions. So the uniqueness and generation method of primary key is more crucial in a distributed database. Current common primary key generation methods, such as increment primary key, cannot meet the requirements of the distributed database; and UUID, although meet the requirements, but occupy a large space. Most of mainstream commercial database cannot own multi-database consistency of the primary key. Oracle database can achieve it, but oracle database too complex and expensive prices. To solve the problem above, a method of primary key generation based on distributed database cluster is presented. Based on the original, this article designs a distributed database cluster system for primary key generation method. It implemented the uniqueness of primary key generation method. Specifically, the main work of the paper includes: Based on the analysis of various distributed algorithms and primary key generation method, a primary key Sequence generation algorithm was proposed. Adopted the method of central control in order to meet the unique primary key algori