Browse > Article
http://dx.doi.org/10.13089/JKIISC.2016.26.1.125

The Method of Deleted Record Recovery for MySQL MyISAM Database  

Noh, Woo-seon (Center for Information Security Technologies, Korea University)
Jang, Sung-min (Center for Information Security Technologies, Korea University)
Kang, Chul-hoon (Center for Information Security Technologies, Korea University)
Lee, Kyung-min (Center for Information Security Technologies, Korea University)
Lee, Sang-jin (Center for Information Security Technologies, Korea University)
Publication Information
Journal of the Korea Institute of Information Security & Cryptology / v.26, no.1, 2016 , pp. 125-134 More about this Journal
Abstract
MySQL database is currently used by many users and It has gained a big market share in the database market. Even though MyISAM storage engine was used as a default storage engine before, but records recovery method does not existed. Deleted records have a high possibility for important evidence and it is almost impossible to determine that investigators manually examine large amounts of database directly. This paper suggests the universal recovery method for deleted records and presents the experimental results.
Keywords
MySQL database analysis; MyISAM storage engine; digital forensics; record recovery;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Solid IT, DB-Engines Ranking, "http://db-engines.com/en.ranking"
2 P. Fruhwirt and M. Huber, "InnoDB datab ase forensics," 24th IEEE International Conference on Advanced Information Net working and Applications (AINA). pp. 1028-1036, Apr. 2010
3 P. Fruhwirt, P. Kieseberg, S. Schrittwieser, M. Huber and E. Weippl, "InnoDB data base forensics:Reconstructing data mani pulation queries from redo logs," Seventh International Conference on Availability, Reliability and Security (ARES), pp. 625-633, Aug. 2012
4 Jae-ung Namgung, Nam-heun Son, Sang -jun Jeon, Cheul-hoon Kang and Sang-jin Lee, "The scheme for recovering deleted records in MySQL database," Journal of Korean Digital Forensics Society, 7(1), pp. 1-14, Dec. 2013
5 Sung-min Jang, "Deleted records recovery research for MySQL InnoDB," Master's Thesis, Korea University, Feb. 2015
6 Oracle, MySQL Internals Manual, "https://dev.mysql.com/doc/internals/en"
7 Paul DuBois, MySQL Developer's Library, 4th Ed., Addison-Wesley Professional, Aug. 2008
8 Oracle, SHOW COLLATION Syntax, "https://dev.mysql.com/doc/refman/5.0/en/show-collation.html"
9 Oracle, Layout of the Record Storage Frame, "https://dev.mysql.com/doc/internals/ en/layout-record-storage-frame.html"