Help With My Essay:Database Performance and Tuning Plan
Database Performance and Tuning Plan
- Identify the goals and objectives for performance of the database system.
- Describe how atomicity, concurrency, isolation, and durability (ACID) rules will be supported. Then, identify the steps that will be taken to implement atomic transactions.
- Identify transaction anomalies that may occur and how each transaction will be managed through scheduling (serial, equivalent, or serializable).
Query Optimization Plan
- Identify general practices that will be implemented by the database administrator to accomplish query optimization.
- The concurrency control categories (optimistic, pessimistic, and semioptimistic) that will be used and expected performance.
- Methods of concurrency control that will be implemented and the specific steps planned for each type of transaction (specific locking strategies, isolation levels, limits that will be implemented, and major goals of concurrency control mechanisms being implemented)
