The Design And Realization Of Shandong Province Underwater Monitoring Data Management And Issue System

The underwater monitoring data is the base of managing hydrogeololgy, engineering geology and environmental geology. Computerized monitoring data management and issue is a good way to analyzing the present situation and future efficiently for many engineers and technicians, it also plays an important role in monitor and supervise excessive extract and underwater pollution and the protect of geological environment. Shandong Province Monitoring Data Management and Issue System mentioned in the article is an important constitutive part of geological environment management computerized construction.With the goal of designing a application system based on 3-tiers browser/server structure by using ASP.NET 2.0 and SQL Server2005 which are developed by Microsoft company recently, Shandong Province Monitoring Data Management and Issue System, the following which is called Sdpgemis, service the geological environment monitoring and management with providing the functions of monitoring data input, managing, statistical analysis, browsing spatial maps and so on. The system also should have better scalability and maintainability as a solution to each province geological environment monitoring master station of China with a very good value.I took responsibility for the whole of project's development and undertook all works in the system design and realization process by myself. At the beginning of this article, I discuss system design background and whole article's frame. After that, I discuss the Web database process: From the earliest Host/Terminal to Client/Server in recent years, now Brower/Server and summarize their advantages and disadvantages. Furthermore ,the different methods of visiting web database arc discussed: middleware technology, client technology, PHP, J2EE and ASP.NET. Because ASP.NET 2.0 can integrate with SQL Server 2005 and provides many web controls and data access controls, I adopts ASP.NET 2.0 and SQL Server2005 to design and realize of Sdpgemis.Based on the demand analysis and major functions of Sdpgemis, I design 3-tiers structure: the Data Access Layer, business logic layer and presentation layer, and design and realize of Sdpgemis database based on SQL Server 2005 platform. The articles design score is design and realization 3-tiers of Sdpgemis taking advantage of ASP.NET 2.0 technology in c#.Sdpgemis uses the Abstract Factory Design Pattern within the Data Access Layer tier, in which generic interfaces IDAL are used to create families of related or dependent objects without specifying their concrete classes. The projects SQLServerDAL and DALFactory , in which DataAccess factory class is used reflection technology, realize the interfaces IDAL. Sdpgemis accesses database by using the SQLDataSource control and ObjectDataSource control in ASP.NET 2.0.Model objects created within business logic layer transform database entities to business objects. These objects are shared across the application layers as a way to communicate with each other. The business logic project BLL access data in Sdpgemis database by communicating with data access layer.Sdpgemis uses SQL cache dependency by Notification Services provided in SQL Server 2005 and aggregate cache dependency designed by facade pattern and simple abstract factory pattern within Presentation Layer. Cache dependency allows middle-tier object caches to be invalidated automatically as backend database information changes. With this feature, cached database information can always be kept up to date while still taking advantage of caching to reduce load on middle-tier and database servers. Membership Service in ASP.NET 2.0 provides a common user authentication and management framework that can dramatically reduce code associated with creating and maintaining user account information and protect application and database's safe. The web pages of statistical analysis forms are realized by Reporting Services provided in SQL Server 2005. The web pages including spatial maps are realized by map Designer in ARCIMS9.2.Designing the web pages by taking advantage of the web server controls that ASP.NET 2.0 provides, such as Master Pages, data bound control, Wizard control, and Login control, we are able to quickly implement the Sdpgemis presentation layer.Sdpgemis realized the principle of high cohesion, low coupling and accorded with the demands of scalability , maintainability and reusability by 3-tiers structure.