Constant Time Recovery in Azure SQL Database
Summary: Introduces constant-time recovery by combining ARIES with MVCC to make restart independent of data size. Enables continuous log truncation even with long-running transactions, supporting large updates with constant log space and delivering sub-3-minute recoveries for 99.999% of cases. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Panagiotis Antonopoulos (Microsoft)
- 2. Peter Byrne (Microsoft)
- 3. Wayne Chen (Microsoft)
- 4. Cristian Diaconu (Microsoft)
- 5. Raghavendra Thallam Kodandaramaih (Microsoft)
- 6. Hanuma Kodavalla (Microsoft)
- 7. Prashanth Purnananda (Microsoft)
- 8. Adrian-Leonard Radu (Microsoft)
- 9. Chaitanya Sreenivas Ravella (Microsoft)
- 10. Girish Mittur Venkataramanappa (Microsoft)
BibTeX Citation
@article{antonopoulos_vldb19,
title = {{Constant Time Recovery in Azure SQL Database}},
author = {Antonopoulos, Panagiotis and Byrne, Peter and Chen, Wayne and Diaconu, Cristian and Kodandaramaih, Raghavendra Thallam and Kodavalla, Hanuma and Purnananda, Prashanth and Radu, Adrian-Leonard and Ravella, Chaitanya Sreenivas and Venkataramanappa, Girish Mittur},
journal = {PVLDB},
series = {{VLDB} '19},
volume = {12},
number = {12},
pages = {2143--2154},
doi = {10.14778/3352063.3352131},
url = {https://doi.org/10.14778/3352063.3352131},
year = {2019}
}Incoming Citations (Sorted by Pagerank)
Showing 20 of 20 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 34 | The Design Of Postgres | 1986 | SIGMOD | 0.00049142315 |
| 614 | Scalable Logging through Emerging Non-Volatile Memory | 2014 | VLDB | 0.0001556755 |
| 864 | Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems | 2015 | SIGMOD | 0.00013391824 |
| 1,425 | Amazon Aurora: On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes | 2018 | SIGMOD | 0.00010714536 |
| 2,847 | Transaction Time Indexing with Version Compression | 2008 | VLDB | 7.9447157e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,145 | A Recovery Algorithm for A High-Performance Memory-Resident Database System | 1987 | SIGMOD |
| 2 | 5,503 | A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure | 1993 | VLDB |
| 3 | 11,498 | Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless | 2024 | SIGMOD |
| 4 | 1,017 | Extreme Scale with Full SQL Language Support in Microsoft SQL Azure | 2010 | SIGMOD |
| 5 | 11,370 | MD-MVCC: Multi-version Concurrency Control for Schema Changes in Azure SQL Database | 2025 | VLDB |
| 6 | 12,122 | Concurrent Updates to Pages with Fixed-Size Rows Using Lock-Free Algorithms | 2020 | VLDB |
| 7 | 8,353 | Resumable Online Index Rebuild in SQL Server | 2017 | VLDB |
| 8 | 5,766 | Survivability of Cloud Databases - Factors and Prediction | 2018 | SIGMOD |
| 9 | 12,623 | Transaction Log Based Application Error Recovery and Point In-Time Query | 2012 | VLDB |
| 10 | 10,907 | Highly Scalable SQL Azure MVCC Version Cleaner | 2026 | VLDB |