What is multi-version concurrency control?
What is multi-version concurrency control?
Updated May 18, 2018
Comments
Recommended Posts:
- What is SAP HANA
- SAP HANA Training Tutorials for Beginners
- SAP HANA In-Memory Database
- SAP HANA Database Architecture
- SAP HANA Studio Guide
- SAP HANA Azure Architecture
- SAP HANA Modeling Scenarios
- Create Schema in HANA
- SAP HANA Calculation View
- SAP HANA Hints
- SAP HANA vs S/4HANA
- SAP HANA Compression Techniques
- SAP HANA SQL Operators
- SAP HANA Data Provisioning
- SAP HANA Persistence layer
- SAP HANA DXC
- SAP HANA Audit
- SAP HANA Data Archiving vs Data Aging
- SAP HANA Interview Questions
- GST S/4HANA Master Data Configuration
×
Multi-version concurrency control (MVCC) is an implementation of isolation levels based on multiple versions of data. The most frequently used isolation level in SAP HANA is "read committed". This means that every database request sees the committed data of the point in time when the request (not the transaction) started. As a consequence different current and historic versions of the same data may need to be preserved in order to support the points in time when different SQL statements were started.