【作者】 郑秀芬；

【导师】 吴国忠；

【作者基本信息】 浙江大学 ， 电力电子与电力传动， 2004， 硕士

【摘要】 随着Internet应用的飞速发展，网站信息的实时性、交互性成为网站设计的关键点。而Internet／Intranet和Web技术的出现和不断发展，使得越来越多的企业通过建立Internet站点实时发布企业动态信息，以及建立内部Intranet网进行企业集成与共享，以达到企业优化管理。 数据仓库技术是近几年来出现的、发展迅速的一种技术。它可以充分利用存于数据仓库中的已有信息，帮助决策者进行正确的决策，使企业能在激烈的市场竞争中把握先机。 数据清理是由创建数据仓库产生的为确保数据完整性的过程。数据的来源不同使数据仓库很容易产生“脏”的和“不稳定”的数据。对于一个公司而言，有一个拥有错误信息的数据仓库比没有数据仓库更糟。数据清理的步骤为：集成前清理、集成后清理、集成后提炼。本文以一个实例——数据清理系统(DCS)的设计并实现，从应用的角度上，初步论证了数据仓库技术在管理信息系统中的重要意义和在实际生活中的现实作用。 本文应用ASP和Oracle数据库技术构建了基于Web数据库的数据查询和信息发布系统，并阐述其设计和实现方法。该系统采用Browser／Server结构，使客户端能通过浏览器动态访问数据库信息，并通过浏览方式实现信息的发布与查询，其中采用ASP技术通过Oracle数据库自带的Oracle Objects for OLE来访问数据库，实现交互式、动态的企业数据库查询和信息发布。实践证明，该系统具有安全性强、稳定性高、操作简单等优点。在水电厂数据的实时显示方面，本文提出利用PUSH技术实现服务器主动发送数据，并把网络多播技术的应用作为未来进一步研究的方向。更多还原

【Abstract】 As a communication age has come, Internet is continuously changing people’s work and life. We can get a lot of information conveniently and quickly by web. With the fast development of Internet’s application, the key of Web node design is that the information of web must be time-effective aad be exchanged between both sides. So with the appearance and development of the technology of Internet/Intranet and web, in order to optimize management more and more enterprises have issued their dynamic information at real time by establishing Internet sites and have established Intranet inside to integrate and share all the information.Data warehouse is a technology that appeared and has got a fast development in recent years. It makes the best of the information that has been stored and helps decision-makers to make a wise decision. So enterprises can take an earlier advance than others in the vehement market competition.Data cleaning is the process that is done by data warehouse created to guarantee the integrality of data. The difference of data sources brings the result that data warehouse is easy to have some "dirty" and " unstable" data. For enterprises it is worse to have a data warehouse that has error information than to have no data warehouse. The procedures of data cleaning are cleaning before integrating, cleaning after integrating and extracting after integrating. Through an example - the design and implementation of data cleaning system(DCS), the great significance of data warehouse technology in Manage and Information System is demonstrated from the application point of view and the actual function in real life is introduced.In this paper the data query and information issuing system based on Web Database, in which the technology of ASP and Oracle database is applied, is introduced. And its design, implementation and examples are showed as well. In this system Browser/Server structure is applied in order that the client can dynamically access database information by browsers and perform the function of information issuing and query by the method of full-browser, in which ASP technology accesses databases by Oracle Objects for OLE of Oracle database to issue enterprise’s information dynamically and mutually. It is proved that this system has the advantages of high security and stability and easy-operation.更多还原