Comprehensive Information Management System Based On Three-tier Structure And Its Application

With the development of information technology and the progress in management methods, integrated information management system based on Internet/Intranet is required for enterprise application in the long term. The Client/Server architecture, widely used nowadays, is not efficient enough to meet the requirement of enterprise application. In the three-layer architecture model information system is divided into: expression layer, business logic layer, DBMS layer. Therefore, three-layer architecture is obviously superior to two-layer architecture in maintaining, expansibility, reusage, security etc. So three-layer architecture will gradually take place of two-layer architecture.The development of integrated statistics information system for Power Supply Company is presented in this paper. The integrated statistics business is characterized by a great many of distributed information sources and variable statistic rules and items for different statistic purposes. To solve these problems, the system adopted the three-layer architecture based on Sybase EAServer. The business logic is encapsulated as components that are executed in the component transaction server. By this means, the performance is greatly improved and the system becomes much easier for maintaining and expending.A detailed scheme is also presented in this paper for realizing the key functions of the system, sheet managing, dynamic reporting, integrated query and data analysis. The details of the business flow and the messages exchanged between each two layers of the three-layer architecture are described in the sequence diagram by using Rational Rose. Moreover, object-oriented analysis and design is used to classify the control components and the public components.Although it is much harder to develop the integrated information management system based on three-layer architecture than that on two-layer architecture, the enhanced performance, maintenance and expansibility of the system can obtained in comparison with the two-layer architecture. Therefore the contribution given in this paper is valuable for rapid development of integrated information management system.