Data Management And Data Replication Of Integrated Business System Of Deyang Industrial And Commercial Bureau

The paper is aimed at the concrete business of industrial and commercial administration management and provides a system resolution which covers the mostly work of industrial and commercial administration and is applicable to industrial and commercial bureaus at many different level. The design and development of the database and data replication of the project are detailedly described in the paper. The project is based on the .NET platform and confirmed to the three-layer B/S architecture. The database of the project is built on SQL Server 2000. In view of the flaws of typical three-layer architecture, A DAL (Data Access Layer), responsible for the operation of the business logical layer on the database, is abstracted from the business logical layer and the data layer. To improve the total performance and scalability, stored procedures are applied in the operation of business logical layer on the database. Based on analyzing the common operation on database, considering the inconvenience of manually coding numerous stored procedures and referring to modeling tools and template producing codes, a tool has been developed to produce stored procedures by the relation schema information of database. For the sake of the autonomy of the sites and data synchronization, the database is joint concentrated database with distributed database. Compared with several database synchronization cases, the merged replication of SQL Server 2000 has been adapted which has been implemented by script files made up from system stored procedures.