Multiversion Concurrency Control

• Query starting time locks a view of data

  • All data a query sees comes from single point in time

• During query, others’ writes modify new version

• Readers don’t block writers, and vice versa

• Key feature of Oracle

Previous slide

Next slide

Back to first slide

View graphic version