辽河油田分布式人事MIS系统的研究与实现
|
摘要
随着信息技术的飞速发展和企业需求的不断提高,分布式信息系统在企业人事管理工作中的应用已成必然。
本文论述了辽河油田公司分布式人事MIS系统的研发技术。该系统采用数据库结构特性与行为特性相结合的方法,给出了符合辽河油田人事管理特点及应用环境要求的全局数据库概念模型,使人事管理信息得到合理的组织和有效的使用。采用面向对象的分析方法设计出系统的总体逻辑结构,使系统的功能满足各项人事业务工作及管理的需要;采用了分布式数据库设计方法,进行了数据库的分段设计和分配设计。
在总体设计和具体实施中,分布式数据库技术的合理运用是本系统成功的关键。本文详细论述了分布式数据库的设计、数据的完整性、安全性、可靠性设计方法,以及分布式数据库查询优化、同步更新等技术,并将上述方法及技术灵活地贯穿于本系统的分布式数据库模型、数据流图、模块功能图和同步更新等设计及实现。
该系统的运用不仅使人事管理工作效率得到提高,把管理人员从繁琐的事务性工作中解放出来,更重要的是使得管理工作更加规范化、科学化。本文所给出的数据库模型及总体逻辑结构,对跨地区的集团级企业人事MIS系统的建设可提供参考。
With the rapid development of information technology and the improving requirement of enterprises, the application of Distributed Information System, has necessitated in the enterprise human resources management.
The paper introduces the research technology of Distributed Human Resources MIS system in Liaohe Oilfield. The system, which combines database structure characteristics and behavioral characteristics, gives an overall database conceptual model which suits itself to the properties of human resources management in Liaohe Oilfield and its application environment, thus human resources management information is organized reasonably and used effectively. The general logic structure of the system is designed based on object-oriented analysis method so that the functions of the system can be met demands of different human resources jobs and management. The distributed database is designed in way of segments and distribution.
The feasible application of distributed database is the key to successful during the total design and implementation in this system. The paper discusses the design of distributed database in detail; completion, security and reliability of the data and query optimization and synchronized updating techniques are also studied. All techniques and methods above are properly adopted in design and realization of distributed database module, illustrations of data flow and module functions as well as synchronized updating.
Not only does this system release the working staff from trivial jobs by enhancing efficiency of human resources management, but also most importantly, it directs management into a more scientific and standardized way. The database model and general logic structure in this paper can provides for the construction of human resources MIS system in trans-regional group enterprises.
本文论述了辽河油田公司分布式人事MIS系统的研发技术。该系统采用数据库结构特性与行为特性相结合的方法,给出了符合辽河油田人事管理特点及应用环境要求的全局数据库概念模型,使人事管理信息得到合理的组织和有效的使用。采用面向对象的分析方法设计出系统的总体逻辑结构,使系统的功能满足各项人事业务工作及管理的需要;采用了分布式数据库设计方法,进行了数据库的分段设计和分配设计。
在总体设计和具体实施中,分布式数据库技术的合理运用是本系统成功的关键。本文详细论述了分布式数据库的设计、数据的完整性、安全性、可靠性设计方法,以及分布式数据库查询优化、同步更新等技术,并将上述方法及技术灵活地贯穿于本系统的分布式数据库模型、数据流图、模块功能图和同步更新等设计及实现。
该系统的运用不仅使人事管理工作效率得到提高,把管理人员从繁琐的事务性工作中解放出来,更重要的是使得管理工作更加规范化、科学化。本文所给出的数据库模型及总体逻辑结构,对跨地区的集团级企业人事MIS系统的建设可提供参考。
With the rapid development of information technology and the improving requirement of enterprises, the application of Distributed Information System, has necessitated in the enterprise human resources management.
The paper introduces the research technology of Distributed Human Resources MIS system in Liaohe Oilfield. The system, which combines database structure characteristics and behavioral characteristics, gives an overall database conceptual model which suits itself to the properties of human resources management in Liaohe Oilfield and its application environment, thus human resources management information is organized reasonably and used effectively. The general logic structure of the system is designed based on object-oriented analysis method so that the functions of the system can be met demands of different human resources jobs and management. The distributed database is designed in way of segments and distribution.
The feasible application of distributed database is the key to successful during the total design and implementation in this system. The paper discusses the design of distributed database in detail; completion, security and reliability of the data and query optimization and synchronized updating techniques are also studied. All techniques and methods above are properly adopted in design and realization of distributed database module, illustrations of data flow and module functions as well as synchronized updating.
Not only does this system release the working staff from trivial jobs by enhancing efficiency of human resources management, but also most importantly, it directs management into a more scientific and standardized way. The database model and general logic structure in this paper can provides for the construction of human resources MIS system in trans-regional group enterprises.
引文
[1]张思嘉.企业人力资源管理系统的新架构.技术交流,1999(3):58-59.
[2]陈晓辉.管理信息系统在人事劳资管理中的应用.现代计算机, 2000,101(10):70-71
[3]施伯乐,丁宝康,楼荣生.数据库系统导论.北京:高等教育出版社, 1994:24-29
[4]李敏,宋伟,李红.分布式数据库一般查询处理的优化方法.黑龙江商学院学报(自然科学版),1998,14(3):9-12
[5]张海藩.软件工程.北京:人民邮电出版社,2002:13-23
[6]周平.管理信息网络化的创新理念.科学与管理,2002(2):58-60
[7]任东旺,姚飞.行业管理信息系统通用平台的开发.计算机工程与应用,2000(30): 117-119
[8]刘晓璐.基于管理信息系统的软件质量管理.信息技术与标准化,2004,14(3):35-38
[9]左美云.信息系统的开发与管理教程.北京:清华大学出版社,2001:7-9
[10]陈军霞.基于网络数据库的B/S模式的管理信息系统的研究.河北工业科技,2003, 20(2):7-10
[11]赵立平.数据库的数据加密.河北农业大学学报,2003,26(1):267-268
[12]杨冬青,唐世渭.数据库系统概念.北京:北京大学,2002:142-154
[13]舒后.分布式数据库系统的并发控制方法讨论.微型机与应用,2002(12):14-16
[14] CZESLAW DANILOWICZ,NGOC THANH NGUYEN.Consensus Methods for Solving Inconsis-tency of Replicated Data in Distributed Systems.Distributed and Parallel Databases 2003(14):53-69
[15] E.F.Codd,A relational model of data for large shared data banks,Communications of the ACM,1970,13(6):377-387
[16]肖凌,刘继红.分布式数据库系统的研究与应用.计算机工程, 2001,27(1):33-35
[17] Ajit M.amhankar,Sudha Ram:Database Fragmention and Allocation:an Integrated Methodology and Case Study IEEE Transactions on Systems.Man and Cybernetics-Part A: Systems and Humans.1998,28(3):288-305
[18] Remez ELMASRI,Shamkant NAVATHE.Fundamentals of database systems.california:The Benjamin/cummings Publishing Company,Inc. 1989:457-459
[19] C.I.EZEIFE,KEN BARKER.Distributed Ob ject Based Design.Distributed and Parallel Databases,1998:317-350
[20]王瑞敏,陈月英.分布式管理信息系统的研究与实现.浙江师范大学学报(自然科学版), 2004, 27(1):40-42
[21]章丽平,朱莉,汪艺.提高分布式多层系统执行效率方法的研究.微机发展,2004,1(2):70-73
[22] Ray Sarch. Data Network Design Strategies. America:McGraw Hill Publication Company,1983:41-47
[23] APOSTTOLOSN . PAPADOPOULOS . Distributed Processing of Similarity Queries.Distributed and Parallel Databases. 2001:67-92
[24]王以和,涂小平.分布式数据库系统.北京:电子工业出版社,1988:35-77
[25]金正淑,訾华亮,吕东方.分布式数据库系统中的查询优化.东北电力学院学报,2003, 23(4):12-15
[26]史向兵.浅谈计算机网络技术.科技情报开发与经济,2004,14(4):131-132
[27]田景鹏,金士良.企业管理信息系统中的B/S和C/S结构的应用.工业计量, 2004,14(1): 34-37
[28]杨晓燕,李雅辉.基于B/S模式的人事档案管理信息系统的设计.闽江学院学报,2004, 25(2):62-65
[29]曲俊华,林碧英.综合信息查询系统的设计与实现.华北电力大学学报, 2000,27(2): 93-96
[30] Stefano Ceri,Shamkant Navathe,Gio Wiederhold: Distribution Design of Logical Database Schemas,IEEE Transactions on Software Engineering,1983,SE-9(4):487-503
[31]潭三.分布式软件开发构架.四川轻化工学院学报,2002,15(4): 72-74
[32] Ouri Wolfson,Sushill Jajodia, Yixiu Huang.An Adaptive Data Replication Algorithm. ACM Transactions on Database System,1997,22(24):255-314
[33] P.M.G.APERS: Data Allocation in Distributed Systems.ACM Transactions on Database System, 1998,13:263-304
[34]袁刚.谈计算机管理系统的安全性与保密性.工业技术经济,2000,19(6):93-94
[35] Thomasen D J.Role-based application design and enforcement.In:Jajodia S, Landwehr C E(eds.). Database Security, TV: Status and Prospects. North-Holland,1991
[36] Baldwin R W.Naming and grouping privileges to simplify security management in large databases. In:IEEE Symposium on Research in Security and Privacy.1990
[37]王虎,李晶晶.分布式人力资源管理系统的实现.武汉理工大学学报(信息与管理工程版), 2003,25(4):57-59
[38] Hoang Pham:Optimal Cost Design of Replicated Data in Distributed Databse Systems.International Journal of Systems Systems Science.1998,29(8):795-804
[2]陈晓辉.管理信息系统在人事劳资管理中的应用.现代计算机, 2000,101(10):70-71
[3]施伯乐,丁宝康,楼荣生.数据库系统导论.北京:高等教育出版社, 1994:24-29
[4]李敏,宋伟,李红.分布式数据库一般查询处理的优化方法.黑龙江商学院学报(自然科学版),1998,14(3):9-12
[5]张海藩.软件工程.北京:人民邮电出版社,2002:13-23
[6]周平.管理信息网络化的创新理念.科学与管理,2002(2):58-60
[7]任东旺,姚飞.行业管理信息系统通用平台的开发.计算机工程与应用,2000(30): 117-119
[8]刘晓璐.基于管理信息系统的软件质量管理.信息技术与标准化,2004,14(3):35-38
[9]左美云.信息系统的开发与管理教程.北京:清华大学出版社,2001:7-9
[10]陈军霞.基于网络数据库的B/S模式的管理信息系统的研究.河北工业科技,2003, 20(2):7-10
[11]赵立平.数据库的数据加密.河北农业大学学报,2003,26(1):267-268
[12]杨冬青,唐世渭.数据库系统概念.北京:北京大学,2002:142-154
[13]舒后.分布式数据库系统的并发控制方法讨论.微型机与应用,2002(12):14-16
[14] CZESLAW DANILOWICZ,NGOC THANH NGUYEN.Consensus Methods for Solving Inconsis-tency of Replicated Data in Distributed Systems.Distributed and Parallel Databases 2003(14):53-69
[15] E.F.Codd,A relational model of data for large shared data banks,Communications of the ACM,1970,13(6):377-387
[16]肖凌,刘继红.分布式数据库系统的研究与应用.计算机工程, 2001,27(1):33-35
[17] Ajit M.amhankar,Sudha Ram:Database Fragmention and Allocation:an Integrated Methodology and Case Study IEEE Transactions on Systems.Man and Cybernetics-Part A: Systems and Humans.1998,28(3):288-305
[18] Remez ELMASRI,Shamkant NAVATHE.Fundamentals of database systems.california:The Benjamin/cummings Publishing Company,Inc. 1989:457-459
[19] C.I.EZEIFE,KEN BARKER.Distributed Ob ject Based Design.Distributed and Parallel Databases,1998:317-350
[20]王瑞敏,陈月英.分布式管理信息系统的研究与实现.浙江师范大学学报(自然科学版), 2004, 27(1):40-42
[21]章丽平,朱莉,汪艺.提高分布式多层系统执行效率方法的研究.微机发展,2004,1(2):70-73
[22] Ray Sarch. Data Network Design Strategies. America:McGraw Hill Publication Company,1983:41-47
[23] APOSTTOLOSN . PAPADOPOULOS . Distributed Processing of Similarity Queries.Distributed and Parallel Databases. 2001:67-92
[24]王以和,涂小平.分布式数据库系统.北京:电子工业出版社,1988:35-77
[25]金正淑,訾华亮,吕东方.分布式数据库系统中的查询优化.东北电力学院学报,2003, 23(4):12-15
[26]史向兵.浅谈计算机网络技术.科技情报开发与经济,2004,14(4):131-132
[27]田景鹏,金士良.企业管理信息系统中的B/S和C/S结构的应用.工业计量, 2004,14(1): 34-37
[28]杨晓燕,李雅辉.基于B/S模式的人事档案管理信息系统的设计.闽江学院学报,2004, 25(2):62-65
[29]曲俊华,林碧英.综合信息查询系统的设计与实现.华北电力大学学报, 2000,27(2): 93-96
[30] Stefano Ceri,Shamkant Navathe,Gio Wiederhold: Distribution Design of Logical Database Schemas,IEEE Transactions on Software Engineering,1983,SE-9(4):487-503
[31]潭三.分布式软件开发构架.四川轻化工学院学报,2002,15(4): 72-74
[32] Ouri Wolfson,Sushill Jajodia, Yixiu Huang.An Adaptive Data Replication Algorithm. ACM Transactions on Database System,1997,22(24):255-314
[33] P.M.G.APERS: Data Allocation in Distributed Systems.ACM Transactions on Database System, 1998,13:263-304
[34]袁刚.谈计算机管理系统的安全性与保密性.工业技术经济,2000,19(6):93-94
[35] Thomasen D J.Role-based application design and enforcement.In:Jajodia S, Landwehr C E(eds.). Database Security, TV: Status and Prospects. North-Holland,1991
[36] Baldwin R W.Naming and grouping privileges to simplify security management in large databases. In:IEEE Symposium on Research in Security and Privacy.1990
[37]王虎,李晶晶.分布式人力资源管理系统的实现.武汉理工大学学报(信息与管理工程版), 2003,25(4):57-59
[38] Hoang Pham:Optimal Cost Design of Replicated Data in Distributed Databse Systems.International Journal of Systems Systems Science.1998,29(8):795-804