| The Integrated Information System which has been generalized in all People’s Courts of Jiangsu province standardizes the various processes of the trial and improves the efficiency of each departments, and thus promoted the information process of the People’s Court. In the construction of the court information system, as a very important part of the performance appraisal system of People’s Court, trial quality and efficiency evaluation system also need to be implemented automatically. The trial quality and efficiency evaluation is built under this context.The system has two versions, the early basic version and the later optimized version. After gaining insight into the People’s Court’s needs we developed the early basic version of the trial quality and efficiency evaluation system. This version achieves fundamental functions using Power Builder development tools and Sybase databases. The system includes a background data generating module and a frontend display module. The background data generation module uses the formulas offered by the Higher People’s Court of Jiangsu Province to calculate the assessment indexes of all courts across the province through the court case information database. Meanwhile the frontend display module mainly displays is responsible for displaying the indicator data generated by the background data generation module for the users in the form of report. The early version of the trial quality and efficiency evaluation system has met the basic needs requirements, but with the growing trial data and the improving of the People’s Court assessment system, increasingly large amount of data processing and complex data calculating has greatly increased the burden on the system calculates, which resulting in the early versions of the system inefficient. Thus, our team optimized the previous version of the system.The project team has studied the main bottlenecks affecting the efficiency of the system, in combination of the references. The team optimized the system’s background data modular. Firstly, optimizing database queries without affecting the results of the query premise, replace the query statement of lower efficiency by relatively high efficiency. Then through the creating of indexes on a database table, the system may avoid full scan of the table. In order to increase efficiency of complex statistical indicators, we changed the query mechanism, using the Sybase temp table to store temporary transition data queries, and then we can search on the basis of the temp tables to improve the query efficiency. Through a series of system optimization measures, the trial quality and efficiency evaluation system has been significantly improved, the system’s maintainability and usability has been greatly improved too. The court put the optimized system into manufacture use and has received good user feedback.Due to the progressive development of the current trail quality and efficiency evaluation system, the system has a broad prospect for future development. And together with the development and optimization of the trail quality and efficiency evaluation system, related projects will have more development on functional and technological. |