The Research And Implementation Of Database Performance Optimization In Intelligent Transport System

This paper is based on the Shenzhen Urban Transport Simulation System.Database performance optimization is to adjust components purposively to improve the performance. It will increase database throughput and minimize response time. It's a very complex job and needs much knowledge about database and experience. The database performance is decided by two aspects, hardware and software. Performance problems will happen in running period, but the reasons for them may be in any period of system lifecycle, including designing, developing, debugging and production.SUTSS database is a very typical database system, which has complex relationship, huge data and frequent user accessing. To its testing, there are two phases. Firstly, in system designing, we optimize the whole structure of this system to make sure better performance and less system spending. Secondly, in system running, we found performance bottleneck and adopted system and database level optimization.