Automation Levels
Comparison to self-driving cars
The automobile industry defines a six-level scale of automation (numbered 0 to 5). We use it as a reference point for measuring progress in computer system automation.
In the scale published by the Society of Automotive Engineers, level 0 means no automation. At levels 1 and 2, humans retain complete control, and the automation provides tools such as cruise control or lanekeeping assistance that make driving easier and safer. At levels 3, 4, and 5, humans increasingly delegate responsibility for driving tasks to the automated systems; under the right circumstances, they can safely take their eyes off the road and direct their attention to other things.
Status
AutoDBA now manages caching and buffering, which are core components of autoscaling in a stateful application such as a database. It also helps eliminate frequent pain points, such as the need for vacuuming and running statistics.
We have rated AutoDBA’s current automation capabilities using a 0-5 scale, where 0 represents no automation, and 5 represents automation that outperforms a human DBA under all circumstances:
Area | PostgreSQL/Ecosystem Automation Level | CrystalDB Automation Level |
---|---|---|
Cache management | 0 | 4 |
Buffer management | 0 | 4 |
Vacuuming | 2 | 3 |
Statistics | 2 | 3 |
Indexing | 0 | 0 |
Fault tolerance | 2 | 3 |
Local query planning | 0 | 0 |
Distributed query planning | 0 | 0 |
Scaling by partitioning | 0 | 0 |
Scaling by replication | 0 | 0 |
We will update this comparison as automation levels evolve.