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 19 of 19 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.00049302774 |
| 603 | Scalable Logging through Emerging Non-Volatile Memory | 2014 | VLDB | 0.00015853456 |
| 841 | Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems | 2015 | SIGMOD | 0.00013677356 |
| 1,463 | Amazon Aurora: On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes | 2018 | SIGMOD | 0.00010700936 |
| 2,824 | Transaction Time Indexing with Version Compression | 2008 | VLDB | 8.0882727e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 11,152 | TimeCloth: Fast Point-in-Time Database Recovery in The Cloud | 2024 | SIGMOD |
| 2 | 2,116 | A Recovery Algorithm for A High-Performance Memory-Resident Database System | 1987 | SIGMOD |
| 3 | 5,375 | A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure | 1993 | VLDB |
| 4 | 11,150 | Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless | 2024 | SIGMOD |
| 5 | 1,023 | Extreme Scale with Full SQL Language Support in Microsoft SQL Azure | 2010 | SIGMOD |
| 6 | 10,994 | MD-MVCC: Multi-version Concurrency Control for Schema Changes in Azure SQL Database | 2025 | VLDB |
| 7 | 11,821 | Concurrent Updates to Pages with Fixed-Size Rows Using Lock-Free Algorithms | 2020 | VLDB |
| 8 | 8,194 | Resumable Online Index Rebuild in SQL Server | 2017 | VLDB |
| 9 | 5,681 | Survivability of Cloud Databases - Factors and Prediction | 2018 | SIGMOD |
| 10 | 12,332 | Transaction Log Based Application Error Recovery and Point In-Time Query | 2012 | VLDB |