基于.NET架构的WEB数据库访问技术研究与应用

【作者】 叶安胜；

【导师】 罗惠琼；

【作者基本信息】 电子科技大学 ， 计算机系统结构， 2004， 硕士

【摘要】 随着Internet的飞速发展,WWW(World Wide Web)得到了很大的发展。WWW是Internet最流行最主要的信息服务方式,WWW系统和数据库是网络化信息服务的基础,Web技术和数据库技术相结合成为当前研究的热点,其中关键就是Web数据库访问技术。传统的数据库访问技术已渐渐不能满足高速存取、断开连接存取和内置的全面的XML支持等的需要,研究Internet的数据库访问技术也就成为数据库研究的主要方向之一。目前基本的数据库访问技术主要有ODBC、基于ODBC的DAO和RDO、JDBC、OLE DB/ADO,他们都是在不同时期出现并被广泛使用的技术,很多技术现在仍很流行。而常用的Web数据库访问实现技术主要包括CGI、ISAPI、ASP、PHP 、JSP,这些技术各有自己的优缺点和适宜场合,仍被广泛采用来编写Web应用程序。随着微软.NET的推出,ASP.NET为编写大量的Web应用程序带来了巨大的变革。本文着重就.NET Framework的最新数据库访问技术---ADO.NET的体系结构、对象模型、各个对象的重点特性等进行了深入而详细的分析和研究。就ADO.NET在Web应用中主要性能优化包括四种.NET数据提供程序性能优化、比较和选择,RecordSet、DataReader、DataSet的适用场合和性能比较分析,连接池优化,存储过程的优化;安全性等作了深入的探究并给出了相关的测试数据和分析。还就.NET架构、ASP.NET的核心及会话状态基础技术进行了研讨。提出了在.NET环境下如何开发高效的面向Internet的数据库访问应用,这些探讨对于目前大量的WEB数据库应用程序的开发具有较大的实用和指导意义。基于上述Web数据库访问技术研究,根据天光科技公司的实际需求,设计并实现了B/S模式的电子阅览室系统。该系统基于.NET平台,采用ADO.NET数据访问技术和相关性能优化技术,利用C#语言设计实现。此系统由表示层、数据逻辑层和数据层组成。表示层处在客户端,由一个通用的浏览器支持。事务、数据逻辑层,充当中间代理的角色,就是通常所说的应用服务器。后台是SQL Server数据库服务器。该电子阅览室系统的业务逻辑层使用ADO.NET技术进行数据库访问,运行在Web服务器端,利用ADO.NET连接池技术,使用SQL Server.NET数据提供程序,数据更新大量采用存储过程,DataReader和DataSet混合使用,安全的数据连接、应用程序代码和数据库用户身份验证及权限体系等技术。大大提高应用程序的数据访问效率和性能。最后还讨论了ADSI在该系统中的应用。在电子阅览室系统的设计和实现中,由我全面负责整个系统开发的计划、实施和控制。我主要完成系统的需求分析,系统的设计,数据库设计和80%的编码工作。更多还原

【Abstract】 With the developing rapidly of Internet, WWW(World Wide Web) has got the very big development. WWW is the most popular and leading information service method, WWW system and database are the foundations of network information service, the technique of Web has become the current focus of research with the database technique, the key is a Web database access technique. The traditional database access technique can’t satisfy little by little the demand of high speed access, the data access on broken connection and Complete support of XML etc. The study of database access technique based on Internet has become one of main direction of database research.Current basic database access technique primarily contain ODBC, DAO and RDO based on ODBC, JDBC, OLE DB/ ADO, they appear separately on different period and used broadly, a lot of techniques are still very popular now. General web database access realizing technique includes the CGI, ISAPI, ASP, PHP, JSP primarily, these techniques each have their advantages, shortcomings and the proper situations, still are extensive adopted to write the web application program. Along with the Microsoft .NET releasing, the ASP.NET brings enormous varieties for writing a flood of web application program. This paper investigates thoroughly the performance optimize of ADO.NET on Web application ,which includes comparison、choice and performance optimize of four kinds of .NET data provider, applicable occasion and performance analysis of RecordSet, DataReader and DataSet, Connection Pool optimize, optimize of stored procedure, security etc and gives a related test data with analysis. In addition, it discusses .NET structure、ASP.NET core and session state foundation technique and puts forward that how to develop efficiently database access application of facing to the Internet on .NET environment. These studies provide bigger practical values and guiding meaning for a great deal of the current development of database application on WEB.Based on the above Web database access technique studies, according to actual need of TianGuang Science & Technology Company, a electronics reading room system of B/S mode has been designed and realized. That system on .NET platform is realized with C# language by adoption ADO.NET data access technique and related performance optimize technique. This system consists of presentation layer、data logic layer and data layer. The presentation layer is placed in client anywhere supported by general browser. Business data logic layer as center agent is usually named applied <WP=6>server. The backstage is a SQL Server database server. The business logic layer of the system uses ADO.NET technique connecting and accessing database, it runs at the Web server, makes use of connection pool technique and adopts SQL Server.NET data providers, the large quantity stored procedures is adopted to refresh data, the DataReader and DataSet are mixed to use, safe data conjunction, application program code and database account Body a verification and Legal power management etc technique are used. Such things enhance consumedly data access efficiency and performance of application program .The finally ADSI and its application in the system are discussed too.In the process of designing and realization of the electronics reading room system, I completely am responsible for the whole system development of planning, putting into practice and controlling. I primary analyze the request the system, the design of the system, database design and 80% coding work.更多还原