EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC-ND 4.0

Database memory forensics: Identifying cache patterns for log verification

James Wagner, Mahfuzul I. Nissan, Alexander Rasin

Forensic Science International: Digital Investigation · 2023-07 · 45 · 301567

DOI: 10.1016/j.fsidi.2023.301567 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Forensic Science International: Digital Investigation, 2023-07. Verfasst von James Wagner und 2 weiteren Autor:innen. Die Arbeit wurde bisher 3-mal zitiert (Crossref) und nennt 25 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-NC-ND 4.0). Gefördert von: Louisiana Board of Regents, National Science Foundation.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Cyberattacks continue to evolve and adapt to state-of-the-art security mechanisms. Therefore, it is critical for security experts to routinely inspect audit logs to detect complex security breaches. However, if a system was compromised during a cyberattack, the validity of the audit logs themselves cannot necessarily be trusted. Specifically, for a database management system (DBMS), an attacker with elevated privileges may temporarily disable the audit logs, bypassing logging altogether along with any tamper-proof logging mechanisms. Thus, security experts need techniques to validate logs independent of a potentially compromised system to detect security breaches. This paper demonstrates that SQL query operations produce a repeatable set of patterns within DBMS process memory. Operations such as full table scans, index accesses, or joins each produce their own set of distinct forensic artifacts in memory. Given these known patterns, we propose that collecting forensic artifacts from a trusted memory snapshot allows one to reverse-engineer query activity and validate audit logs independent of the DBMS itself and outside the scope of a database administrator's privileges. We rely on the fact the queries must ultimately be processed in memory regardless of any security mechanisms they may have bypassed. This work is generalized to all relational DBMSes by using two representative DBMSes, Oracle and MySQL.

Förderung

  • Louisiana Board of Regents
  • National Science Foundation

Zitieren

APA

Wagner, J., Nissan, M. I., & Rasin, A. (2023). Database memory forensics: Identifying cache patterns for log verification. Forensic Science International: Digital Investigation, 45, 301567. https://doi.org/10.1016/j.fsidi.2023.301567

Vancouver

Wagner J, Nissan MI, Rasin A. Database memory forensics: Identifying cache patterns for log verification. Forensic Science International: Digital Investigation. 2023;45:301567. doi:10.1016/j.fsidi.2023.301567

BibTeX
@article{Wagner2023,
  author = {Wagner, James and Nissan, Mahfuzul I. and Rasin, Alexander},
  title = {Database memory forensics: Identifying cache patterns for log verification},
  journal = {Forensic Science International: Digital Investigation},
  year = {2023},
  volume = {45},
  pages = {301567},
  doi = {10.1016/j.fsidi.2023.301567}
}
Kostenlos starten →