| 英文摘要 |
This document is the results report of the "Cross-Departmental Chemical Substance Collection Computer System Architecture Optimization Plan". This project is mainly to understand the system design of the use and design of programming language through source code review and the design of the database to find out the execution efficiency of the "Chemical Cloud" computer software system and to locate the bottleneck for future optimization and improvement.
The program part reviews the data transformation by scheduled operations, the API (Application Programming Interface) program responsible for exchanging data with external systems or generating express reports for external system, and the SQL (Structured Query Language) script syntax for accessing data in web programs. The main problems with these programs are:
1. Program design by using some methods that usually take up more memory. When system resources are not used effectively, execution efficiency will be affected.
2. Synchronous processing is used in multiple places, causing the system to only perform specific task at one time that would naturally affects the overall execution efficiency.
3. A large number of duplicate codes lead to a waste of system operation resources.
The design of the database has the following main issues:
1. Many data tables are not properlly indexed or no index at all.
2. Failure to create a PK or too many primary keys would prevent the program from achieving better operating efficiency when it accessing the database.
This final report will explain how these bottlenecks affect performance, and further provide suggestion for improving and optimizing the execution efficiency of the “Chemical Cloud” system.At the same time this report will propose suggestions for future oprimization strategies in terms of platform technology, mechanism, and development.
|