基于DB2的数据库应用系统的性能优化（Performance optimization of database application system based on DB2）.docVIP

基于DB2的数据库应用系统的性能优化（Performance optimization of database application system based on DB2） In combination with the experience of DB2, some principles and methods of performance optimization of database application systems are discussed from four aspects of database design, query optimization, concurrency control, and client / server model Keywords DB2 performance optimization; database design; query optimization; concurrency control; C/S model; Introduction DB2 is a large relational database management system with high performance. It is widely used in client / server architecture. The criteria for evaluating system performance are throughput, response time, parallel capability, etc.. This paper discusses the optimization of system performance from four aspects of database design, query optimization, concurrency control, and client / server mode. Design database 1. familiar with business systems Have a great influence on the performance of familiarity with the business systems for the entire database system, one of the business are not familiar with the design staff, despite the rich knowledge of database, it is very difficult to design a database application system for optimum performance. 2., standardization and non standardization When the database is standardized, data redundancy is reduced, data is small and data rows are narrowed. In this way, each page of the DB2 can include more rows, then each block has more data, thus speeding up the scan of the table and improving the query performance of a single table. However, when queries involve multiple tables, a lot of connection operations are needed to combine information from each table, resulting in higher CPU and I/O costs. Well, there are many times when we need to balance between normalization and non normalization, reduce the system overhead with appropriate redundant information, and use the space cost in exchange for the time cost. There is an order information form OrderDetail, which records the informatio