This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)
Impact of disk corruption on open-source DBMS
Long Beach, CA, USA
March 01-March 06
ISBN: 978-1-4244-5445-7
ASCII Text
x 
 
Sriram Subramanian, Yupu Zhang, Rajiv Vaidyanathan, Haryadi S. Gunawi, Andrea C. Arpaci-Dusseau, Remzi H. Arpaci-Dusseau, Jeffrey F. Naughton, "Impact of disk corruption on open-source DBMS," Data Engineering, International Conference on, pp. 509-520, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010), 2010.
 
 
BibTex
x
 
@article{ 10.1109/ICDE.2010.5447821,
author = {Sriram Subramanian and Yupu Zhang and Rajiv Vaidyanathan and Haryadi S. Gunawi and Andrea C. Arpaci-Dusseau and Remzi H. Arpaci-Dusseau and Jeffrey F. Naughton},
title = {Impact of disk corruption on open-source DBMS},
journal ={Data Engineering, International Conference on},
volume = {0},
year = {2010},
isbn = {978-1-4244-5445-7},
pages = {509-520},
doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2010.5447821},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Data Engineering, International Conference on
TI - Impact of disk corruption on open-source DBMS
SN - 978-1-4244-5445-7
SP509
EP520
A1 - Sriram Subramanian,
A1 - Yupu Zhang,
A1 - Rajiv Vaidyanathan,
A1 - Haryadi S. Gunawi,
A1 - Andrea C. Arpaci-Dusseau,
A1 - Remzi H. Arpaci-Dusseau,
A1 - Jeffrey F. Naughton,
PY - 2010
VL - 0
JA - Data Engineering, International Conference on
ER -
 
Sriram Subramanian, Department of Computer Science, University of Wisconsin, Madison, USA
Yupu Zhang, Department of Computer Science, University of Wisconsin, Madison, USA
Rajiv Vaidyanathan, Department of Computer Science, University of Wisconsin, Madison, USA
Haryadi S. Gunawi, Department of Computer Science, University of Wisconsin, Madison, USA
Andrea C. Arpaci-Dusseau, Department of Computer Science, University of Wisconsin, Madison, USA
Remzi H. Arpaci-Dusseau, Department of Computer Science, University of Wisconsin, Madison, USA
Jeffrey F. Naughton, Department of Computer Science, University of Wisconsin, Madison, USA
Despite the best intentions of disk and RAID manufacturers, on-disk data can still become corrupted. In this paper, we examine the effects of corruption on database management systems. Through injecting faults into the MySQL DBMS, we find that in certain cases, corruption can greatly harm the system, leading to untimely crashes, data loss, or even incorrect results. Overall, of 145 injected faults, 110 lead to serious problems. More detailed observations point us to three deficiencies: MySQL does not have the capability to detect some corruptions due to lack of redundant information, does not isolate corrupted data from valid data, and has inconsistent reactions to similar corruption scenarios. To detect and repair corruption, a DBMS is typically equipped with an offline checker. Unfortunately, the MySQL offline checker is not comprehensive in the checks it performs, misdiagnosing many corruption scenarios and missing others. Sometimes the checker itself crashes; more ominously, its incorrect checking can lead to incorrect repairs. Overall, we find that the checker does not behave correctly in 18 of 145 injected corruptions, and thus can leave the DBMS vulnerable to the problems described above.
Citation:
Sriram Subramanian, Yupu Zhang, Rajiv Vaidyanathan, Haryadi S. Gunawi, Andrea C. Arpaci-Dusseau, Remzi H. Arpaci-Dusseau, Jeffrey F. Naughton, "Impact of disk corruption on open-source DBMS," icde, pp.509-520, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010), 2010
Usage of this product signifies your acceptance of the Terms of Use.