| The Design Project Management System, which is an important part of the information construction work, is started by Shengli Engineering & Consulting Co. in 2009. The subject, which is based on this project, analysis of the company's current status of information construction, completes the system's requirements analysis, architecture design, program development, etc.Through the research and combination with the actual needs of the productive sector, the subject proposes a distributed database design based on a snapshot of the level of fragmentation and asynchronous replication. By the application of distributed database technology, the system will change the traditional centralized data storage and allow various departments controlling their own data which bases on ensuring the various departments in the remote data synchronization update and data query statistics on a consistent, and will make the system more suitable for the geographical distribution of the company. Particularly in data processing, it ensures the data integrity and consistency in a distributed environment through the application of snapshot replication technology and trigger functions.With the completing of the Design Project Management System based on the distributed database, the integration of design project management can be achieved in the company headquarters and all branches. On system application, the system allows the implementation of local control which means the commonly used data is stored in the local and the data entry, inquiry and maintenance also work in the local. On the data query and statistics, the system ensures the consistency of data retrieval in different places, by the data update synchronization between the company headquarters and all branches. |