基于数据集成的宿舍服务管理系统的设计与实现
摘要
近年,随着信息化技术的不断发展完善,社会信息化已成为一个趋势,而高校的信息化建设在逐步的完善中,宿舍管理做为最贴近学生的校园服务,由于其业务的复杂,数据的庞大而非常需要信息系统提供强有力的支持。但是由于在信息化建设的初期中,只是单纯的进行各个单独业务点的信息化,缺乏统一的规划和设计。因此,信息化建设中只能够针对业务的关键步骤进行业务信息化升级,而对于业务数据的初始化、其他相关联业务的数据共享、跨硬件技术或跨IT技术的数据流传缺无能为力。为了解决宿舍管理系统中受以上条件限制而无法为学生提供更多人性化服务的问题,需要开发统一高效的数据集成系统,来支撑平台化的校园宿舍管理系统。
针对现在高校学生宿舍管理中主要的业务,通过采用ETL数据集成方法,本文致力于设计实现综合统一的宿舍管理系统,将教务系统的学生基本信息；学工系统的学生工作信息；房屋资产系统资产信息；校园一卡通门禁系统等各个系统统一集成起来。利用数据集成模块,完成了宿舍管理系统的学生基本信息导入,学生班级信息导入,学生宿舍分配,宿舍管理门禁信息的下发等信息、流转,将围绕整个宿舍系统业务的所有业务信息集成整合。本文在完成宿舍管理系统的建设同时,为构建校园数据集成平台,整个校园信息化建设提供了一种新的尝试模式。
In recent years, with the continuous development of information technology improved, the information society has become a trend, and university information technology are gradually improving, the dormitory management as the most close to the campus student services, due to the complexity of its operations, data The large and much-needed information system to provide strong support. However, due to the early construction of the information in the conduct of each individual purely business point of information, lack of unified planning and design. Therefore, the information construction of only the key steps for business business information technology upgrade, the initialization and for business data, other associated business data sharing across hardware technology or IT technology of data spread across missing powerless. Hostel management system in order to solve the above conditions can not be to provide students with more personalized services, the need to develop integrated and efficient data integration system, to support the platform management system of the campus dormitory.
Dormitory Management for now the main business, through the use of ETL data integration methods, this paper designs to achieve an integrated and comprehensive management system for dormitories, the academic system, the basic information for students; school students who work the work of information systems; housing assets system assets information; campus card access control system integrates the various systems uniform. Using data integration module, complete the dormitory for students of basic information management systems to import, the students class information import, distribution of student hostels, dormitory management access to information and other information issued by circulation, will be around the entire quarters of all business information systems integration business integration. In this paper, the completion of construction of hostel management system at the same time, the data integration platform for building the campus, the campus information technology provides a new attempt to model.
针对现在高校学生宿舍管理中主要的业务,通过采用ETL数据集成方法,本文致力于设计实现综合统一的宿舍管理系统,将教务系统的学生基本信息；学工系统的学生工作信息；房屋资产系统资产信息；校园一卡通门禁系统等各个系统统一集成起来。利用数据集成模块,完成了宿舍管理系统的学生基本信息导入,学生班级信息导入,学生宿舍分配,宿舍管理门禁信息的下发等信息、流转,将围绕整个宿舍系统业务的所有业务信息集成整合。本文在完成宿舍管理系统的建设同时,为构建校园数据集成平台,整个校园信息化建设提供了一种新的尝试模式。
In recent years, with the continuous development of information technology improved, the information society has become a trend, and university information technology are gradually improving, the dormitory management as the most close to the campus student services, due to the complexity of its operations, data The large and much-needed information system to provide strong support. However, due to the early construction of the information in the conduct of each individual purely business point of information, lack of unified planning and design. Therefore, the information construction of only the key steps for business business information technology upgrade, the initialization and for business data, other associated business data sharing across hardware technology or IT technology of data spread across missing powerless. Hostel management system in order to solve the above conditions can not be to provide students with more personalized services, the need to develop integrated and efficient data integration system, to support the platform management system of the campus dormitory.
Dormitory Management for now the main business, through the use of ETL data integration methods, this paper designs to achieve an integrated and comprehensive management system for dormitories, the academic system, the basic information for students; school students who work the work of information systems; housing assets system assets information; campus card access control system integrates the various systems uniform. Using data integration module, complete the dormitory for students of basic information management systems to import, the students class information import, distribution of student hostels, dormitory management access to information and other information issued by circulation, will be around the entire quarters of all business information systems integration business integration. In this paper, the completion of construction of hostel management system at the same time, the data integration platform for building the campus, the campus information technology provides a new attempt to model.
引文
[1]吴丹.宿舍管理系统的设计与实现.大连理工大学.2006
[2]戴曰梅.基于TCP/IP协议的门禁控制系统设计.合肥工业大学.2007
[3]刘绍清,黄章树.基于可复用构件思想的ETL架构设计.现代电子技术.2009.32(24)：62-68
[4]舒攀,陈金刚.数字化校园建设中宿舍管理系统的设计与实现.武汉工程大学学.2008,3(4)：108-111
[5]李庆阳,彭宏.面向数据质量的ETL框架的设计与实现.计算机工程与设计.2010,31(9)：2057-2060
[6]章述文,王先义,冷明,华洪亮,江新建,王晓军,王丽娟,张瑛,孙凌宇.基于微GIS的宿舍管理信息系统关键技术研究.井冈山学院学报(自然科学).2009,30(10)：29-32
[7]周蕾,常晋义.基于.NET的高校宿舍管理系统的设计与实现.计算机与现代化.2009,10：150-153
[8]苌程.基于ETL的数据集成过程模型.浙江大学.2010
[9]魏昭康.基于数据集成的校园招聘系统的web实现.北京邮电大学.2008
[10]吴京,蓬颜桐.基于手持式读写器的电子门锁实时管理系统.电子测量技术.2009,32(10)：24-26
[11]杨俊宝.基于JSP技术的学生宿舍管理系统的设计与实现.沈阳工业大学.2006
[12]王毅,易树平,龙跃,张力,唐平.基于SOA的整车企业技术数据集成研究.湖南大学学报(自然科学版).2010,37(5)：35-39
[13]赵枫.基于MISP的校园管理系统的设计与实现.大连理工大学.2007
[14]谢红标,徐争前.基于Web的智能化宿舍管理系统的设计与实现.计算机时代.2007.6：47-48
[15]苌程,李善平.基于ETL的金融数据集成过程模型.计算机工程与设计.2010,31(9)：2070-2072
[16]吴丹.宿舍管理系统的设计与实现.大连理工大学.2006
[17]张旭峰,孙未未,汪卫,冯雅慧,施伯乐.增量ETL过程自动化产生方法的研 究.计算机研究与发展.2006,3(6)：1097-1103
[18]王岩,凌兴宏,葛娟,伏玉琛.第三方物流信息系统的数据集成研究.计算机应用与软件.2009,06(1)：159-160
[19]戴浩,杨波.ETL中的数据增量抽取机制研究.计算机工程与设计.2009,30(23)：5552-5554
[20]Oracle. Oracle Data Integrator. 技术白皮书
[21]Oracle. Oracle Warehouse Builder lOg
[22]Oracle.Oracle Data Integrator User's Guide 10g Release 3 (10.1.3)
[23]Oracle.Oracle Database.2 Day+Performance Tuning Guide 10g Release 2 (10.2) B28051-02
[24]Cao YC, Ren W. Multi-vehicle coordination for double-integrator dynamics under fixed undirected/directed interaction in a sampled-data setting. International Journal of Robust and Nonlinear Control.201020(9)
[25]Soon-Woo LEE, Young-Jin PARK, Kwan-Ho KIM. Design and Implementation of Energy-Collection-Based Low Complexity IR-UWB Receiver. IEICE Transactions on Fundamentals of Electronics, Communications and Computer Sciences. 200891(2)
[2]戴曰梅.基于TCP/IP协议的门禁控制系统设计.合肥工业大学.2007
[3]刘绍清,黄章树.基于可复用构件思想的ETL架构设计.现代电子技术.2009.32(24)：62-68
[4]舒攀,陈金刚.数字化校园建设中宿舍管理系统的设计与实现.武汉工程大学学.2008,3(4)：108-111
[5]李庆阳,彭宏.面向数据质量的ETL框架的设计与实现.计算机工程与设计.2010,31(9)：2057-2060
[6]章述文,王先义,冷明,华洪亮,江新建,王晓军,王丽娟,张瑛,孙凌宇.基于微GIS的宿舍管理信息系统关键技术研究.井冈山学院学报(自然科学).2009,30(10)：29-32
[7]周蕾,常晋义.基于.NET的高校宿舍管理系统的设计与实现.计算机与现代化.2009,10：150-153
[8]苌程.基于ETL的数据集成过程模型.浙江大学.2010
[9]魏昭康.基于数据集成的校园招聘系统的web实现.北京邮电大学.2008
[10]吴京,蓬颜桐.基于手持式读写器的电子门锁实时管理系统.电子测量技术.2009,32(10)：24-26
[11]杨俊宝.基于JSP技术的学生宿舍管理系统的设计与实现.沈阳工业大学.2006
[12]王毅,易树平,龙跃,张力,唐平.基于SOA的整车企业技术数据集成研究.湖南大学学报(自然科学版).2010,37(5)：35-39
[13]赵枫.基于MISP的校园管理系统的设计与实现.大连理工大学.2007
[14]谢红标,徐争前.基于Web的智能化宿舍管理系统的设计与实现.计算机时代.2007.6：47-48
[15]苌程,李善平.基于ETL的金融数据集成过程模型.计算机工程与设计.2010,31(9)：2070-2072
[16]吴丹.宿舍管理系统的设计与实现.大连理工大学.2006
[17]张旭峰,孙未未,汪卫,冯雅慧,施伯乐.增量ETL过程自动化产生方法的研 究.计算机研究与发展.2006,3(6)：1097-1103
[18]王岩,凌兴宏,葛娟,伏玉琛.第三方物流信息系统的数据集成研究.计算机应用与软件.2009,06(1)：159-160
[19]戴浩,杨波.ETL中的数据增量抽取机制研究.计算机工程与设计.2009,30(23)：5552-5554
[20]Oracle. Oracle Data Integrator. 技术白皮书
[21]Oracle. Oracle Warehouse Builder lOg
[22]Oracle.Oracle Data Integrator User's Guide 10g Release 3 (10.1.3)
[23]Oracle.Oracle Database.2 Day+Performance Tuning Guide 10g Release 2 (10.2) B28051-02
[24]Cao YC, Ren W. Multi-vehicle coordination for double-integrator dynamics under fixed undirected/directed interaction in a sampled-data setting. International Journal of Robust and Nonlinear Control.201020(9)
[25]Soon-Woo LEE, Young-Jin PARK, Kwan-Ho KIM. Design and Implementation of Energy-Collection-Based Low Complexity IR-UWB Receiver. IEICE Transactions on Fundamentals of Electronics, Communications and Computer Sciences. 200891(2)