论文信息 - IBM Database 2 Performance: Design, Implementation, and Tuning

IBM Database 2 Performance: Design, Implementation, and Tuning

The larger and more complex a relation data base, the more efficient the data base management system must be to maintain an acceptable level of performance. The design and implementation of IBM Database 2 (DB2) have been aimed toward this objective. Techniques for achieving this key objective in DB2 are the subject of this paper. Presented are performance-related strategies in query processing and performance-related design tradeoffs. Data base and application design options and their resolution for optimum performance are also discussed. Also presented are techniques to maintain performance by application monitoring and tuning and DB2 system tuning.

Josephine M. Cheng | Christopher R. Looseley | Akira Shibamiya | Patricia S. Worthington

[1] Won Kim,et al. On optimizing an SQL-like nested query , 1982, TODS.

[2] Michael Stonebraker,et al. Performance enhancements to a relational database system , 1983, TODS.

[3] Patricia G. Selinger,et al. Access path selection in a relational database management system , 1979, SIGMOD '79.

[4] Peter Buneman,et al. An implementation technique for database query languages , 1982, TODS.

[5] Irving L. Traiger,et al. System R: relational approach to database management , 1976, TODS.

[6] Akifumi Makinouchi,et al. The Optimization Strategy for Query Evaluation in RDB/V1 , 1981, VLDB.

[7] Eugene Wong,et al. Decomposition—a strategy for query processing , 1976, TODS.

[8] Michael Stonebraker,et al. The design and implementation of INGRES , 1976, TODS.

[9] Donald D. Chamberlin,et al. Implementation of a structured English query language , 1975, CACM.

[10] Y. E. Lien. Design and implementation of a relational database on a minicomputer , 1977, ACM '77.