基于智能客户端技术的VOLVO建筑设备租赁信息系统研究与开发
|
摘要
信息技术的快速发展普及了信息系统在企业中的应用,企业信息化已经成为全球趋势。信息技术的发展也促进了信息系统开发方式的变化。信息系统中客户端应用程序的软件架构发生了从C/S到B/S的转变;数据库设计也发生了巨大变化,信息技术的高速发展使得分布式数据库应运而生,在某些领域取代了以往的集中式数据库,并成为当今计算机技术中最活跃的研究领域之一。
VOLVO建筑设备公司,是一所具有地域上分散而管理上又相对集中的企业,它的客户端程序要求具备对本地资源充分利用、便于部署安装和支持离线操作等特点。传统的客户端应用程序解决方案不能满足用户的要求,因此客观决定了使用智能客户端作为其应用程序解决方案;数据物理分散而逻辑集中要求了使用计算机网络与数据库系统的有机结合的分布式数据库系统。
本文旨在分析信息系统开发中智能化客户端技术方案与分布式数据库的理论方案的可行性,进而将技术与理论应用在具有代表性的VOLVO建筑设备租赁企业信息系统的设计中,开发了基于智能客户端技术的VOLVO建筑设备租赁信息系统。文中首先阐述了传统信息系统客户端应用程序解决方案并进行分析,提出智能客户端作为解决方案的优势。并且,介绍了作为智能客户端解决方案支持技术的Web技术;其次,阐述了VOLVO数据管理模式—分布式数据库系统的定义、特点、分类、优点、设计以及实现的技术难题等理论,信息系统的数据库设计等需要据此进行;再次,对VOLVO建筑设备租赁公司基于业务流程或组织结构进行分析,进而进行需求分析,依据需求分析决定该系统的设计,即:通过Microsoft Excel 2003及其VBA开发Office智能客户端应用程序、Microsoft 2005设计数据库、C#开发分布式解决方案的Web Services与C#结合Ajax技术开发了供用户注册、维护功能的Web部分,开发了完整的智能化分布式的VOLVO建筑设备租赁信息系统;并且对整个系统进行分析与测试。最后,对整个系统的开发进行了总结,并且提出了系统设计过程中遇到的值得以后研究的问题。本信息系统已经交付用户使用,并运行良好。
The fast development of information technologies has accelerated the application of information systems in enterprise. It has already made the informationization a worldwide tendency. At the same time, IT also changes the way of information system development. The architecture of client application program in Information System has changed from C/S to B/S. In addition, the design of database has greatly changed. With the high speed development of infotmation technology, Distributed Database System comes about. In some fileds DDBS has been the substitute solutions of CDBS. DDBS has been the hot-point in research.
VOLVO Construction Equipment Company is the enterprises that need geographical dispersion and management concentration, at same time the company hope the client have the characteristics such as full utilization of local resources, setup convenience and offline support. The tradition solutions in client can not support all the need in this company, Smart Client is taken into consideration. On another hand, with the demand that the data must be in geographical dispersion and management concentration, the company need the DDBS as databse solutions, which is the integration of network and database systems.
The paper strives to analyze the feasibility of Information System development using Smart Client technology and Distributed Database Systems theory, the technology and theory will be further applied to a representative of the enterprise information system design that is the development of the VOLVO Construction Equipment Rent Information System based on the Smart Client technology. The paper is constructed as follows: Firstly, describe and analyzed the traditional Infotmation System client application solution in order to show the advantage of Smart Client technology. Secondly, described the related theories of DDBS such as definition, characteristics, classification, benefits, design and the realization of the technical problems, etc. The database of Information System will be carried out based on these theories. Thirdly, analyzed the business processes and organizational structures of VOLVO Construction Equipment Rent Company, did Requirements Analysis and designed the Information System based on the Requirements Analysis. That was: developed the Office Smart Client in Microsoft Excel 2003 and its VBA; designed the database in Microsoft SQL Server 2005; programmed in C# to develop Web Services; programmed in C#, integrated with Ajax technology, developed Web Pages which provided user with functions like registration and maintenance. Developed the whole VOLVO Construction Equipment Rent Information System, and tested and analzyed the system. Finally, obtained the summary and outlook. The information system had been delivered to the user, and worked well.
VOLVO建筑设备公司,是一所具有地域上分散而管理上又相对集中的企业,它的客户端程序要求具备对本地资源充分利用、便于部署安装和支持离线操作等特点。传统的客户端应用程序解决方案不能满足用户的要求,因此客观决定了使用智能客户端作为其应用程序解决方案;数据物理分散而逻辑集中要求了使用计算机网络与数据库系统的有机结合的分布式数据库系统。
本文旨在分析信息系统开发中智能化客户端技术方案与分布式数据库的理论方案的可行性,进而将技术与理论应用在具有代表性的VOLVO建筑设备租赁企业信息系统的设计中,开发了基于智能客户端技术的VOLVO建筑设备租赁信息系统。文中首先阐述了传统信息系统客户端应用程序解决方案并进行分析,提出智能客户端作为解决方案的优势。并且,介绍了作为智能客户端解决方案支持技术的Web技术;其次,阐述了VOLVO数据管理模式—分布式数据库系统的定义、特点、分类、优点、设计以及实现的技术难题等理论,信息系统的数据库设计等需要据此进行;再次,对VOLVO建筑设备租赁公司基于业务流程或组织结构进行分析,进而进行需求分析,依据需求分析决定该系统的设计,即:通过Microsoft Excel 2003及其VBA开发Office智能客户端应用程序、Microsoft 2005设计数据库、C#开发分布式解决方案的Web Services与C#结合Ajax技术开发了供用户注册、维护功能的Web部分,开发了完整的智能化分布式的VOLVO建筑设备租赁信息系统;并且对整个系统进行分析与测试。最后,对整个系统的开发进行了总结,并且提出了系统设计过程中遇到的值得以后研究的问题。本信息系统已经交付用户使用,并运行良好。
The fast development of information technologies has accelerated the application of information systems in enterprise. It has already made the informationization a worldwide tendency. At the same time, IT also changes the way of information system development. The architecture of client application program in Information System has changed from C/S to B/S. In addition, the design of database has greatly changed. With the high speed development of infotmation technology, Distributed Database System comes about. In some fileds DDBS has been the substitute solutions of CDBS. DDBS has been the hot-point in research.
VOLVO Construction Equipment Company is the enterprises that need geographical dispersion and management concentration, at same time the company hope the client have the characteristics such as full utilization of local resources, setup convenience and offline support. The tradition solutions in client can not support all the need in this company, Smart Client is taken into consideration. On another hand, with the demand that the data must be in geographical dispersion and management concentration, the company need the DDBS as databse solutions, which is the integration of network and database systems.
The paper strives to analyze the feasibility of Information System development using Smart Client technology and Distributed Database Systems theory, the technology and theory will be further applied to a representative of the enterprise information system design that is the development of the VOLVO Construction Equipment Rent Information System based on the Smart Client technology. The paper is constructed as follows: Firstly, describe and analyzed the traditional Infotmation System client application solution in order to show the advantage of Smart Client technology. Secondly, described the related theories of DDBS such as definition, characteristics, classification, benefits, design and the realization of the technical problems, etc. The database of Information System will be carried out based on these theories. Thirdly, analyzed the business processes and organizational structures of VOLVO Construction Equipment Rent Company, did Requirements Analysis and designed the Information System based on the Requirements Analysis. That was: developed the Office Smart Client in Microsoft Excel 2003 and its VBA; designed the database in Microsoft SQL Server 2005; programmed in C# to develop Web Services; programmed in C#, integrated with Ajax technology, developed Web Pages which provided user with functions like registration and maintenance. Developed the whole VOLVO Construction Equipment Rent Information System, and tested and analzyed the system. Finally, obtained the summary and outlook. The information system had been delivered to the user, and worked well.
引文
[1]陈晓红.罗新星.信息系统教程[M].北京:清华大学出版社,2005:16-20.
[2]李红.李凤洁.杨森.管理信息系统开发与应用[M].北京:电子工业出版社,2003:37-89.
[3]邵佩英.分布式数据库系统及其应用(第二版)[M].北京:科学出版社,2005:1-107.
[4]蔡文卫.基于智能客户端的MIS系统设计、应用及其实现[D].上海交通大学硕士学位论文.2006.
[5]石宏.基于智能客户端的MIS系统的研究与实现[D].河海大学硕士学位论文.2007.
[6]马玉梅.基于智能客户端的电气操作票系统的设计与实现[D].山东大学硕士学位论文.2006.
[7]崔蔚.李安志.徐永红.浅谈智能客户端应用程序[J].教学与科技.2005,18卷(1):30-33.
[8]李涛.面向服务的智能客户端分布式应用模型研究[D].华中科技大学硕士学位论文.
[9]马秀麟.郏示德.管理信息系统及其开发技术[M].北京:清华大学出版社,北京交通大学出版社.2006:189-256.
[10]Alex Berson,Georage Anderson.Sybase and clinet'server computing,2rd ED McGraw-Hill.1999.89-102
[11]魏少华.基于WEB的分布式数据库系统的研究与设计[D],西北工业大学硕士学位论文.2007.
[12]J.D.Ullman.Principles of Database and Knowledge-base Systems[J],Vol.Ⅰ,ⅡCompute Science Press,1988,ISBN 088175-188-X(X.1),256-309
[13]张福涛.分布式数据库的安全研究与实现[D].南京工业大学硕士学位论文.2004.
[14]智能客户端的定义[OE/BL] http://msdn2.microsoft.com/zh-cn/smartclient/bb313755.aspx
[15]LOB Application[OE/BL]http://msdn2.microsoft.com/zh-cn/library/bb266337.aspx
[16]Lan Gorton,Anna Liu.Architecture and Technologies for Enterprise Application Integration.Processdings of the26th Internation Conference on Software Engineering(ICSE'04),2004
[17]周祥.智能客户端系统构架的研究与应用[D].西北工业大学硕士学位论文.2006.
[18]C/S与B/S的比较[OE/BL]http://www.cnblogs.com/daitengfei/archive/2006/04/04/366721.html
[19]开发人员创建智能客户端的十大理由[OE/BL]http://www.microsoft.com/china/msdn/developercenter/smartclient/ToplODevCreatS C.aspx.
[20]肖承勇.智能客户端的研究与应用[D].西南交通大学硕士学位论文.2007.
[21]刘如鸿.超越浏览器-Smart Client掀起软件革命[J].软件世界.2005,1:50-54.
[22]金兆毅.智能客户端离线关键技术研究与实现[D].合肥工业大学硕士学位论文.2007.
[23]方睿.Smart Client与Office System整合应用研究[D].电子科技大学硕士学位论文.2006.
[24]刘利.煤矿安全智能客户端体系结构研究[D].西安科技大学硕士学位论文.2006.
[25]Smart Client的构架与设计原则[OE/BL]http://blogs.msdn.com/twmvp/default.aspx
[26]David Hill,Brenton Webster,Edward A.Sezierski.Smart Client Architecture and Design Guide,Tune 2004;Smart Client Software Factory.[OE/BL]http://msdn2.microsoft.com/en-us/library/aa480482.aspx
[27]Kuayk R,Web Services:Standardizing EAI[J],eAiJournal,2002,4:23-2.
[28]杜碧晓.基于WebServices的项目管理系统研究与开发[D].四川大学硕士学位论文.2006.
[29]什么是Web服务[OE/BL]http://www.ibm.com/developerworks/cn/webservices/ws-wsar/part2/
[30]Min Luo,Mark Endrei,Philippe Comte,Pal Krogdahl,Jenny Ang,Tony Newling,IBM红皮书《Patterns:Service-Oriented Architecture and Web Services》(sg246303),chapter 2
[31]Eric Newcomer.Understanding Web Services:XML,WSDL,SOAP and UDD1[M].Addison-Wesley Pub Co.,2002.
[32]Extensible Markup Language(XML)1.0(Third Edition)[OE/BL]http://www.w3.org/TR/REC-xml/ 2005-07-21
[33]Randy Howard,Larry Kerschberc.A framework for dynamic semantic Web management[J].International journal of cooperative information system,2004,13(4)
[34]Graham,S.,Davis,D.,Simeonov,S.,Daniels,czBrittenham,P,Nakamura,Y,Fremantle,P,Koenig,D.and Zentner,C.Building Web services with sense of XML,SOAP,WSDL,and UDDI,2nd.ed.[M],London,Pearson Education,2004.
[35]SOAP Version 1.2 Part1:Messaging[OE/BL]http://www.w3.org/TR/soap12-part1/Framework,2005-11-15
[36]IBM Lotus Domino 7中的实用Web服务,第1部分:什么是Web服务以及它们为何如此重要[OE/BL]www.ibm.com/developerworks/cn/lotus/web-services1/
[37]柴晓路.Web服务架构与开放互操作技术[M].北京:清华大学出版社,2002:34-99.
[38]Russ Basiura,Mike Batongbacal等著.ASP.NET Web服务高级编程[M].北京:清华大学出版社,2002:48-157.
[39]架构Web Service:什么是Web服务?[OE/BL]http://www.ibm.com/developerworks/cn/webservices/ws-wsar/part2/
[40]AJAX:The Official Microsoft ASP.NET Site[OE/BL]http://www.asp.net/ajax/
[41]HTML 5[OE/BL]http://whatwg.org/specs/web-apps/current-work/
[42]David Bell.Jane Crimson.Distributed Database Systems[M]. Addison-Wesley,1994
[43]Hara,Takahiro;Harumoto,Distributed database system concurrency control.Systems Kaname;Tsukamoto,Masahiko;Nishio,Shojiro.based on database migration and its mechanism for and Computers in Japan.1999,30(S)
[44]周龙骧.分布式数据库管理系统实现技术[M].北京:科学出版社,1998:61-85.
[45]李晓容.分布式数据库在管理信息系统中的研究与探讨[D].吉林大学硕士学位论文.2007.
[46]王涛.多层分布式数据库实战[M].北京:清华大学出版社,2000:72-133.
[47]王以和.涂小平.分布式数据库系统[M].北京:电子工业出版社,1998.
[48]C.J.Date.Distributed Database:A Closer Look.In:C.J.Date and H.Darwen.eds.Relational Database:Writings 1989-1991.Reading,MA:Addison-Wesley,1992.485-516
[49]S.Tanenbaum Distributed Systems:principles and paradigms.分布式系统—原理与范例(英文影印版)[M].北京:清华大学出版社,2002:39-85.
[50]George Coulouris,Jean Dollinore and Tim Kindberg.Distributed System Concepts and Design,2rd ED[M].Addison-Wesley.1994,56-78
[51]M.Tamer Ozsu,Patrick Valduriez.Principles of distributed database systems[M].北京:清华大学出版社,2002:127-203.
[52]刘广钟.刘方鑫等.分布式数据库系统中数据分布模型的研究与建立[J].小型微型计算机系统.2001,22(1).
[53]邹建峰.周山峰.项细威.C#企业级开发案例精解[M].北京:人民邮电出版社,2006:51-118.
[54]Matthew MacDonald著..NET分布式应用程序:集成XML Web服务与.NET 远程处理[M].戢中东.周长青.张晔.常小红译.Visual Studio.NET产品组 审校.北京:清华大学出版社,2005:86-137.
[55]苑旭.董民辉.使用Visual C#.NET开发Windows应用[M].北京:红旗出版社,北京希望电子出版社,2005:125-143.
[56]Microsoft SQL Server主页[OE/BL]http://www.microsoft.comlchinalsql/default.mspx
[57]周峰.SQL Server 2005中文版关系数据库基础与实践教程CMS[M].北京:电子工业出版社,2006:71-89.
[58]罗斌.Visusal C#.NET精彩编程实例集锦[M].北京:中国水利水电出版社,2005:337-496.
[59]Tom Barnaby..NET分布式编程——C#篇[M].黎嫒.王小峰等译.北京:清华大学出版社,2005:3-35.
[60]李律松.马传宝.李婷.Visusal C#+SQL Server数据库开发与实例[M].北京:清华大学出版社,2006:304-397.
[61]Jeffrey Putz.最优化ASP.NET—面向对象开发[M].刘俊民.陈远译.北京:电子工业出版社,2006:23-150.
[62]张宽海.管理信息系统概论[M].北京:高等教育出版社,2002:24-71
[2]李红.李凤洁.杨森.管理信息系统开发与应用[M].北京:电子工业出版社,2003:37-89.
[3]邵佩英.分布式数据库系统及其应用(第二版)[M].北京:科学出版社,2005:1-107.
[4]蔡文卫.基于智能客户端的MIS系统设计、应用及其实现[D].上海交通大学硕士学位论文.2006.
[5]石宏.基于智能客户端的MIS系统的研究与实现[D].河海大学硕士学位论文.2007.
[6]马玉梅.基于智能客户端的电气操作票系统的设计与实现[D].山东大学硕士学位论文.2006.
[7]崔蔚.李安志.徐永红.浅谈智能客户端应用程序[J].教学与科技.2005,18卷(1):30-33.
[8]李涛.面向服务的智能客户端分布式应用模型研究[D].华中科技大学硕士学位论文.
[9]马秀麟.郏示德.管理信息系统及其开发技术[M].北京:清华大学出版社,北京交通大学出版社.2006:189-256.
[10]Alex Berson,Georage Anderson.Sybase and clinet'server computing,2rd ED McGraw-Hill.1999.89-102
[11]魏少华.基于WEB的分布式数据库系统的研究与设计[D],西北工业大学硕士学位论文.2007.
[12]J.D.Ullman.Principles of Database and Knowledge-base Systems[J],Vol.Ⅰ,ⅡCompute Science Press,1988,ISBN 088175-188-X(X.1),256-309
[13]张福涛.分布式数据库的安全研究与实现[D].南京工业大学硕士学位论文.2004.
[14]智能客户端的定义[OE/BL] http://msdn2.microsoft.com/zh-cn/smartclient/bb313755.aspx
[15]LOB Application[OE/BL]http://msdn2.microsoft.com/zh-cn/library/bb266337.aspx
[16]Lan Gorton,Anna Liu.Architecture and Technologies for Enterprise Application Integration.Processdings of the26th Internation Conference on Software Engineering(ICSE'04),2004
[17]周祥.智能客户端系统构架的研究与应用[D].西北工业大学硕士学位论文.2006.
[18]C/S与B/S的比较[OE/BL]http://www.cnblogs.com/daitengfei/archive/2006/04/04/366721.html
[19]开发人员创建智能客户端的十大理由[OE/BL]http://www.microsoft.com/china/msdn/developercenter/smartclient/ToplODevCreatS C.aspx.
[20]肖承勇.智能客户端的研究与应用[D].西南交通大学硕士学位论文.2007.
[21]刘如鸿.超越浏览器-Smart Client掀起软件革命[J].软件世界.2005,1:50-54.
[22]金兆毅.智能客户端离线关键技术研究与实现[D].合肥工业大学硕士学位论文.2007.
[23]方睿.Smart Client与Office System整合应用研究[D].电子科技大学硕士学位论文.2006.
[24]刘利.煤矿安全智能客户端体系结构研究[D].西安科技大学硕士学位论文.2006.
[25]Smart Client的构架与设计原则[OE/BL]http://blogs.msdn.com/twmvp/default.aspx
[26]David Hill,Brenton Webster,Edward A.Sezierski.Smart Client Architecture and Design Guide,Tune 2004;Smart Client Software Factory.[OE/BL]http://msdn2.microsoft.com/en-us/library/aa480482.aspx
[27]Kuayk R,Web Services:Standardizing EAI[J],eAiJournal,2002,4:23-2.
[28]杜碧晓.基于WebServices的项目管理系统研究与开发[D].四川大学硕士学位论文.2006.
[29]什么是Web服务[OE/BL]http://www.ibm.com/developerworks/cn/webservices/ws-wsar/part2/
[30]Min Luo,Mark Endrei,Philippe Comte,Pal Krogdahl,Jenny Ang,Tony Newling,IBM红皮书《Patterns:Service-Oriented Architecture and Web Services》(sg246303),chapter 2
[31]Eric Newcomer.Understanding Web Services:XML,WSDL,SOAP and UDD1[M].Addison-Wesley Pub Co.,2002.
[32]Extensible Markup Language(XML)1.0(Third Edition)[OE/BL]http://www.w3.org/TR/REC-xml/ 2005-07-21
[33]Randy Howard,Larry Kerschberc.A framework for dynamic semantic Web management[J].International journal of cooperative information system,2004,13(4)
[34]Graham,S.,Davis,D.,Simeonov,S.,Daniels,czBrittenham,P,Nakamura,Y,Fremantle,P,Koenig,D.and Zentner,C.Building Web services with sense of XML,SOAP,WSDL,and UDDI,2nd.ed.[M],London,Pearson Education,2004.
[35]SOAP Version 1.2 Part1:Messaging[OE/BL]http://www.w3.org/TR/soap12-part1/Framework,2005-11-15
[36]IBM Lotus Domino 7中的实用Web服务,第1部分:什么是Web服务以及它们为何如此重要[OE/BL]www.ibm.com/developerworks/cn/lotus/web-services1/
[37]柴晓路.Web服务架构与开放互操作技术[M].北京:清华大学出版社,2002:34-99.
[38]Russ Basiura,Mike Batongbacal等著.ASP.NET Web服务高级编程[M].北京:清华大学出版社,2002:48-157.
[39]架构Web Service:什么是Web服务?[OE/BL]http://www.ibm.com/developerworks/cn/webservices/ws-wsar/part2/
[40]AJAX:The Official Microsoft ASP.NET Site[OE/BL]http://www.asp.net/ajax/
[41]HTML 5[OE/BL]http://whatwg.org/specs/web-apps/current-work/
[42]David Bell.Jane Crimson.Distributed Database Systems[M]. Addison-Wesley,1994
[43]Hara,Takahiro;Harumoto,Distributed database system concurrency control.Systems Kaname;Tsukamoto,Masahiko;Nishio,Shojiro.based on database migration and its mechanism for and Computers in Japan.1999,30(S)
[44]周龙骧.分布式数据库管理系统实现技术[M].北京:科学出版社,1998:61-85.
[45]李晓容.分布式数据库在管理信息系统中的研究与探讨[D].吉林大学硕士学位论文.2007.
[46]王涛.多层分布式数据库实战[M].北京:清华大学出版社,2000:72-133.
[47]王以和.涂小平.分布式数据库系统[M].北京:电子工业出版社,1998.
[48]C.J.Date.Distributed Database:A Closer Look.In:C.J.Date and H.Darwen.eds.Relational Database:Writings 1989-1991.Reading,MA:Addison-Wesley,1992.485-516
[49]S.Tanenbaum Distributed Systems:principles and paradigms.分布式系统—原理与范例(英文影印版)[M].北京:清华大学出版社,2002:39-85.
[50]George Coulouris,Jean Dollinore and Tim Kindberg.Distributed System Concepts and Design,2rd ED[M].Addison-Wesley.1994,56-78
[51]M.Tamer Ozsu,Patrick Valduriez.Principles of distributed database systems[M].北京:清华大学出版社,2002:127-203.
[52]刘广钟.刘方鑫等.分布式数据库系统中数据分布模型的研究与建立[J].小型微型计算机系统.2001,22(1).
[53]邹建峰.周山峰.项细威.C#企业级开发案例精解[M].北京:人民邮电出版社,2006:51-118.
[54]Matthew MacDonald著..NET分布式应用程序:集成XML Web服务与.NET 远程处理[M].戢中东.周长青.张晔.常小红译.Visual Studio.NET产品组 审校.北京:清华大学出版社,2005:86-137.
[55]苑旭.董民辉.使用Visual C#.NET开发Windows应用[M].北京:红旗出版社,北京希望电子出版社,2005:125-143.
[56]Microsoft SQL Server主页[OE/BL]http://www.microsoft.comlchinalsql/default.mspx
[57]周峰.SQL Server 2005中文版关系数据库基础与实践教程CMS[M].北京:电子工业出版社,2006:71-89.
[58]罗斌.Visusal C#.NET精彩编程实例集锦[M].北京:中国水利水电出版社,2005:337-496.
[59]Tom Barnaby..NET分布式编程——C#篇[M].黎嫒.王小峰等译.北京:清华大学出版社,2005:3-35.
[60]李律松.马传宝.李婷.Visusal C#+SQL Server数据库开发与实例[M].北京:清华大学出版社,2006:304-397.
[61]Jeffrey Putz.最优化ASP.NET—面向对象开发[M].刘俊民.陈远译.北京:电子工业出版社,2006:23-150.
[62]张宽海.管理信息系统概论[M].北京:高等教育出版社,2002:24-71