图书馆数据库拆分  

Splitting of Library Database

作　　者：石元聆[1] 

机构地区：[1]湖北水利水电职业技术学院电力电子系,武汉430070

出　　处：《电脑开发与应用》2011年第2期41-43,共3页Computer Development & Applications

摘　　要：学校进行校区搬迁,图书馆的数据要进行拆分,但是原有的系统已经过了服务期,需要自己进行数据拆分。其目标是现有南湖校区的学生要搬迁到汤逊湖校区去,另外有一部分南湖校区的书籍要搬迁到汤逊湖校区去,进而使其图书馆管理系统得到应用。数据库系统是Sqlserver2000,是基于客户端和服务器的老系统。两个校区分别有自己的图书借阅系统,相互之间不能通信。分析数据库,确定要操作的表,进行数据拆分。数据拆分后,系统运行稳定。Relocation of our school campus,the library data to be split, but the original system has been of service,so you need to split the data.Our goal is to present the students in South Lake Campus Tangxun Lake school district to move to,another part of the books in South Lake Campus Tangxun Lake school district to move to.Database system is sqlserver2000,is based on the old client and server systems.The two campuses have their own books to borrow systems can not communicate with each other.Analysis of the database to determine the table to operate.Data split.After Spliting the data,the system is stable.

关 键 词：SQLSERVER2000 数据分析 数据拆分 

分 类 号：TP311.132[自动化与计算机技术—计算机软件与理论]