Web数据库系统的研究和实践
摘要
信息技术的快速发展使得整个社会的方方面面处于一个信息相互关连的网络世界，Intemet的日益普及和Web技术的飞速发展对传统MIS产生了巨大的冲击。在这种背景下，Web技术和数据库技术相互结合，便产生了Web数据库。Web数据库集合了Web技术和数据库技术的优点，使它们都发生了质的变化：Web网页从静态网页发展成了由数据库驱动的动态网页，数据库实现了开发环境和应用环境的分离。
我们开发的广东省科技人才库系统是一个Web数据库系统，其目的是实现广东省科技人才资源的共享，提高科技人才管理的效率和信息化程度，达到对高层次人才的跟踪管理，同时便于有关部门动态掌握科技人才发展状况和加强产、学、研的结合。
本文主要描述了广东省科技人才库系统中若干关键技术的研究和实现，主要包括：
1)从体系结构的角度来看，Web数据库系统可以采用B/S、B/S/S和多层B/S体系结构。本系统采用B/S/S体系结构。
2)分析和研究了Web数据库访问技术和应用编程模型，将面向对象的MVC模型应用到应用程序的开发中，采用基于JAVA的Web数据库访问技术：JSP、JavaServlet、Java Bean和JDBC，实现了应用程序中表示层、应用层和数据层的分离。
3)为了改善系统性能，本系统使用了“连接缓冲池”技术，提高了数据库访问的效率。
4)由于Web数据库系统的运行环境——Internet的开放性，本文还研究了Web数据库系统的安全性问题，并在系统的多个层次上设计和实现了系统的安全性。
With the rapid development of information technology, the whole society is now linked with network communication. The increasing popularization of Internet and the rapid progress of Web technology brought the tremendous impact to DB technology. Under this background, Web-DB came into being with the combination of Web technology and database technology. Combining the advantage of Web technology and database technology, the Web Pages can be expand from static to dynamic pages which driven by database, and the development and using environment can be separated.
We developed a Web-DBS-the Talents Database of Science and Technology in GuangDong. It aims to realize the sharing of talents of science and technology resources in GuangDong, and to improve the efficiency of talents of science and technology management This system is useful for the government departments to manage and trace the information of talents of science and technology in time, so that to strengthen the combination of production, studying and research.
This paper mostly describes the research and realization of some key technologies in the talent database of science and technology in GuangDong, which include the system architecture, Web-DB accessing technology, application programming model, capability optimize and security.
1) There are many kinds of architectures of Web-DBS, such as B/S architecture, B/S/S architecture and multi-tiered B/S architecture. We adopt B/S/S architecture in The talent-database of science and technology in GuangDong.
2) We analyzed and researched Web-DB accessing technology and application programming model, and applied MVC model in the development of application system, adopted the Web-DB accessing technologies based on Java such as JSP, Servlets, JavaBean and JDBC, and realized the department of presentation layer, application layer, and data alyer of application.
3) To improve the system capability, our system applied the DB connection pool technology which improved the efficiency of Web-DB access.
4) The platform of Web-DBS-Intemet is open, so we researched the security of Web-DBS, and designed and realized the security of our system in many way.
我们开发的广东省科技人才库系统是一个Web数据库系统，其目的是实现广东省科技人才资源的共享，提高科技人才管理的效率和信息化程度，达到对高层次人才的跟踪管理，同时便于有关部门动态掌握科技人才发展状况和加强产、学、研的结合。
本文主要描述了广东省科技人才库系统中若干关键技术的研究和实现，主要包括：
1)从体系结构的角度来看，Web数据库系统可以采用B/S、B/S/S和多层B/S体系结构。本系统采用B/S/S体系结构。
2)分析和研究了Web数据库访问技术和应用编程模型，将面向对象的MVC模型应用到应用程序的开发中，采用基于JAVA的Web数据库访问技术：JSP、JavaServlet、Java Bean和JDBC，实现了应用程序中表示层、应用层和数据层的分离。
3)为了改善系统性能，本系统使用了“连接缓冲池”技术，提高了数据库访问的效率。
4)由于Web数据库系统的运行环境——Internet的开放性，本文还研究了Web数据库系统的安全性问题，并在系统的多个层次上设计和实现了系统的安全性。
With the rapid development of information technology, the whole society is now linked with network communication. The increasing popularization of Internet and the rapid progress of Web technology brought the tremendous impact to DB technology. Under this background, Web-DB came into being with the combination of Web technology and database technology. Combining the advantage of Web technology and database technology, the Web Pages can be expand from static to dynamic pages which driven by database, and the development and using environment can be separated.
We developed a Web-DBS-the Talents Database of Science and Technology in GuangDong. It aims to realize the sharing of talents of science and technology resources in GuangDong, and to improve the efficiency of talents of science and technology management This system is useful for the government departments to manage and trace the information of talents of science and technology in time, so that to strengthen the combination of production, studying and research.
This paper mostly describes the research and realization of some key technologies in the talent database of science and technology in GuangDong, which include the system architecture, Web-DB accessing technology, application programming model, capability optimize and security.
1) There are many kinds of architectures of Web-DBS, such as B/S architecture, B/S/S architecture and multi-tiered B/S architecture. We adopt B/S/S architecture in The talent-database of science and technology in GuangDong.
2) We analyzed and researched Web-DB accessing technology and application programming model, and applied MVC model in the development of application system, adopted the Web-DB accessing technologies based on Java such as JSP, Servlets, JavaBean and JDBC, and realized the department of presentation layer, application layer, and data alyer of application.
3) To improve the system capability, our system applied the DB connection pool technology which improved the efficiency of Web-DB access.
4) The platform of Web-DBS-Intemet is open, so we researched the security of Web-DBS, and designed and realized the security of our system in many way.
引文
[1] 裴有福，Web技术大全，中国水利水电出版社，1998
[2] 阮家栋，施美雅，Web数据库技术，科学出版社，2002
[3] 魏应彬，周星，动态网页和Web数据库，北京大学出版社，2001
[4] 余波，动态Web应用高级开发指南，人民邮电出版社，1999
[5] 李庆发，完全探索Microsoft.NET技术战略，中国青年出版社，2002
[6] Rick Cattell,Jim Inscore,Rnterprise Partners,J2EE技术实践，机械工业出版社，2002年1月
[7] 黄理，李积善，曹林有，张勇，用JSP轻松开发Web网站，北京希望电子出版社，2001
[8] 黄理，李积善，曹林有，张勇，JSP深入编程，北京希望电子出版社，2001
[9] 肖刚，Java Web服务器应用程序设计，电子工业出版社，2001
[10] 邹华，方卫宁，邹蓉，Servlet/JSP程序设计技术和实践，人民邮电出版社，2001
[11] Phil Hanna,JSP:The complete Reference,March 2001
[12] David Harms,JSP,Servlets,and MySQL,May 2001
[13] Jonathan Lewis,Practical Oracle8i:Building Efficient Databases,August 2000
[14] 丁钺，Oracle8i数据库系统管理，人民邮电出版社，2001
[15] Terry Ogletree著，袁静，梁进军等译，网络技术金典，电子工业出版社，2001
[16] 戴英侠，连一峰，王航，系统安全与入侵检测，清华大学出版社，2002
[17] 毛汉书，网络技术基础，人民邮电出版社，2001
[18] Abraham Silberschatz,Henry F.Korth,S.Sudarshan著，杨冬清，唐世渭等译，数据库系统概念，机械工业出版社，1999：381-394
[19] Anido,L.;Llamas,M.:Fernandez,M.J.;Developing WWW-based highly interactive and collaborative applications using software component,software-Practice and Experience v31n9 Jul 25 2001,p845-867
[20] 周靖，基于J2EE技术的Web企业计算，现代计算机，2001．7
[21] 袁道华，基于Web的事务处理和信息系统构建，计算机工程与应用，1998．4
[22] 於长华，蔺博军，虞鹤松，基于三层C/S模型的大型关系数据库应用系统优化设计技术，计算机工程与应用，1999．11
[23] Wang,J.Z.;Yin,G.F.;Hu,X.B.;Chen,T.;Implementing method of remote cooperative design system based on browser/server model Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems,CIMS v 6 n 6 December 2000.p52-55+60
[24] Saimi,Akihiro:Syomura,Tsutomu:Suganuma,Hiroshi:Ishida,Itaru;Presentation layer framework of web application systems with server-side Java technology,Proceedings-IEEE Computer Society's International Computer Software and Applications Conference 2000.IEEE,Los Alamitos,CA,USA,00CB37156.p473-478
[25] Gehringer,Edward F.;Louca,Tony M.;Web-based computer architecture course database:Proceedings-Frontiers in Education Conference v 2 2000,IEEE,Piscataway,NJ,USA,00CB37135,pS2B-12-S2B-16
[26] Jiang,Jun-Jie:Li,Chun-Bo:Huang,M-Ping;Li,Jian-Ming,Web-based 3D dynamic browsing and markup system of product model,Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems,CIMS v 7 n 9 September 2001.p36-39
[27] Liu,Jiang B.,Multi-tiered intrenet computing using Java technologies,IECON Proceedings(Industrial Electronics Conference)v 1 2001,p1789-1793(IEEE cat n 01CH37243)
[28] 赵仲孟，马稳，张选平，Oracle Web应用服务器及开发技术的研究，计算机工程与应用，2001．2
[29] 唐飞龙，姚君遗，Web数据库访问技术的分析与研究，计算机工程，2001．7
[30] Papastavrou,Stavros;Chrysanthis,Panos K.;Samaras,George;Pitoura,Evaggelia;Survey on the Java-based approaches for web database connectivity Proceedings of the Mediterranean Electrotechnical Conference-MELECON v 1 2000,IEEE,Piscataway,NJ,USA,00CB37099,p290-293
[31] Lin,J.;Tsao,H.;Chu,Y;Object-oriented analysis and design of web-based information systems,Proceedings of the International Symposium and Workshop on Engineering of Computer Based Systems,2001,p68-75
[32] Salo,T.,Hill,J.,Building enterprise Web applications with java,JOOP-Journal of Object-Oriented Programming Vol 12,No 2,May 2000,Pages28-29+47
[33] 李平，沈国民，李哲，基于JSP技术的WEB数据库设计，电脑与信息技术，2001．6
[34] 孙莹，许俊华，张毅，MVC编程模型在Web程序中的应用及JAVA实现，计算机工程与应用，2001．17
[35] 罗朝晖，边小凡，刘铁英，李天柱，三层模式下信息系统的安全，计算机系统应用，2001
[36] 程明远，宋宝卫，王季方，耿雪春，Intranet内Web库系统的安全策略的实现，河南科学，2001．3
[37] http://technet,oracle,com:Conceptual and Physical Architecture for Web Application Server 3.0
[38] http://archives.java.sun.com
[39] http://www.sun.com.cn
[40] http://www.cnjsp.net
[41] http://www.chinajavaworld.com
[2] 阮家栋，施美雅，Web数据库技术，科学出版社，2002
[3] 魏应彬，周星，动态网页和Web数据库，北京大学出版社，2001
[4] 余波，动态Web应用高级开发指南，人民邮电出版社，1999
[5] 李庆发，完全探索Microsoft.NET技术战略，中国青年出版社，2002
[6] Rick Cattell,Jim Inscore,Rnterprise Partners,J2EE技术实践，机械工业出版社，2002年1月
[7] 黄理，李积善，曹林有，张勇，用JSP轻松开发Web网站，北京希望电子出版社，2001
[8] 黄理，李积善，曹林有，张勇，JSP深入编程，北京希望电子出版社，2001
[9] 肖刚，Java Web服务器应用程序设计，电子工业出版社，2001
[10] 邹华，方卫宁，邹蓉，Servlet/JSP程序设计技术和实践，人民邮电出版社，2001
[11] Phil Hanna,JSP:The complete Reference,March 2001
[12] David Harms,JSP,Servlets,and MySQL,May 2001
[13] Jonathan Lewis,Practical Oracle8i:Building Efficient Databases,August 2000
[14] 丁钺，Oracle8i数据库系统管理，人民邮电出版社，2001
[15] Terry Ogletree著，袁静，梁进军等译，网络技术金典，电子工业出版社，2001
[16] 戴英侠，连一峰，王航，系统安全与入侵检测，清华大学出版社，2002
[17] 毛汉书，网络技术基础，人民邮电出版社，2001
[18] Abraham Silberschatz,Henry F.Korth,S.Sudarshan著，杨冬清，唐世渭等译，数据库系统概念，机械工业出版社，1999：381-394
[19] Anido,L.;Llamas,M.:Fernandez,M.J.;Developing WWW-based highly interactive and collaborative applications using software component,software-Practice and Experience v31n9 Jul 25 2001,p845-867
[20] 周靖，基于J2EE技术的Web企业计算，现代计算机，2001．7
[21] 袁道华，基于Web的事务处理和信息系统构建，计算机工程与应用，1998．4
[22] 於长华，蔺博军，虞鹤松，基于三层C/S模型的大型关系数据库应用系统优化设计技术，计算机工程与应用，1999．11
[23] Wang,J.Z.;Yin,G.F.;Hu,X.B.;Chen,T.;Implementing method of remote cooperative design system based on browser/server model Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems,CIMS v 6 n 6 December 2000.p52-55+60
[24] Saimi,Akihiro:Syomura,Tsutomu:Suganuma,Hiroshi:Ishida,Itaru;Presentation layer framework of web application systems with server-side Java technology,Proceedings-IEEE Computer Society's International Computer Software and Applications Conference 2000.IEEE,Los Alamitos,CA,USA,00CB37156.p473-478
[25] Gehringer,Edward F.;Louca,Tony M.;Web-based computer architecture course database:Proceedings-Frontiers in Education Conference v 2 2000,IEEE,Piscataway,NJ,USA,00CB37135,pS2B-12-S2B-16
[26] Jiang,Jun-Jie:Li,Chun-Bo:Huang,M-Ping;Li,Jian-Ming,Web-based 3D dynamic browsing and markup system of product model,Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems,CIMS v 7 n 9 September 2001.p36-39
[27] Liu,Jiang B.,Multi-tiered intrenet computing using Java technologies,IECON Proceedings(Industrial Electronics Conference)v 1 2001,p1789-1793(IEEE cat n 01CH37243)
[28] 赵仲孟，马稳，张选平，Oracle Web应用服务器及开发技术的研究，计算机工程与应用，2001．2
[29] 唐飞龙，姚君遗，Web数据库访问技术的分析与研究，计算机工程，2001．7
[30] Papastavrou,Stavros;Chrysanthis,Panos K.;Samaras,George;Pitoura,Evaggelia;Survey on the Java-based approaches for web database connectivity Proceedings of the Mediterranean Electrotechnical Conference-MELECON v 1 2000,IEEE,Piscataway,NJ,USA,00CB37099,p290-293
[31] Lin,J.;Tsao,H.;Chu,Y;Object-oriented analysis and design of web-based information systems,Proceedings of the International Symposium and Workshop on Engineering of Computer Based Systems,2001,p68-75
[32] Salo,T.,Hill,J.,Building enterprise Web applications with java,JOOP-Journal of Object-Oriented Programming Vol 12,No 2,May 2000,Pages28-29+47
[33] 李平，沈国民，李哲，基于JSP技术的WEB数据库设计，电脑与信息技术，2001．6
[34] 孙莹，许俊华，张毅，MVC编程模型在Web程序中的应用及JAVA实现，计算机工程与应用，2001．17
[35] 罗朝晖，边小凡，刘铁英，李天柱，三层模式下信息系统的安全，计算机系统应用，2001
[36] 程明远，宋宝卫，王季方，耿雪春，Intranet内Web库系统的安全策略的实现，河南科学，2001．3
[37] http://technet,oracle,com:Conceptual and Physical Architecture for Web Application Server 3.0
[38] http://archives.java.sun.com
[39] http://www.sun.com.cn
[40] http://www.cnjsp.net
[41] http://www.chinajavaworld.com
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |