Benefits of Views and Triggers (2)
Equally useful for performance and failure management
- Performance tuning example: DB index management
- View: access patterns to tables, query predicates used
- Trigger: access rate to table above/below average
- Adaptation: add/drop indices based on query stream
- Failure management example: impending disk failure
- View: disk error logs, environmental conditions
- Trigger: frequency of errors, unsafe environment
- Adaptation: redirect requests to other replicas, shut down disk, generate new replicas, signal operator