An implementation technique for database query languages
ACM Transactions on Database Systems (TODS)
On optimizing an SQL-like nested query
ACM Transactions on Database Systems (TODS)
Performance enhancements to a relational database system
ACM Transactions on Database Systems (TODS)
System R: relational approach to database management
ACM Transactions on Database Systems (TODS)
The design and implementation of INGRES
ACM Transactions on Database Systems (TODS)
Decomposition—a strategy for query processing
ACM Transactions on Database Systems (TODS)
Implementation of a structured English query language
Communications of the ACM
Access path selection in a relational database management system
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Design and implementation of a relational database on a minicomputer
ACM '77 Proceedings of the 1977 annual conference
The optimization strategy for query evaluation in RDB/V1
VLDB '81 Proceedings of the seventh international conference on Very Large Data Bases - Volume 7
Performance Analysis of Database Systems
Performance Evaluation: Origins and Directions
| Hi-index | 0.00 |
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.