SQLite Forensics

SQLite Forensics
Author :
Publisher :
Total Pages : 315
Release :
ISBN-10 : 1980293074
ISBN-13 : 9781980293071
Rating : 4/5 (071 Downloads)

Book Synopsis SQLite Forensics by : Paul Sanderson

Download or read book SQLite Forensics written by Paul Sanderson and published by . This book was released on 2018-05-12 with total page 315 pages. Available in PDF, EPUB and Kindle. Book excerpt: SQLite is a self-contained SQL database engine that is used on every smartphone (including all iOS and Android devices) and most computers (including all Macs and Windows 10 machines). Each computer or phone using SQLite often has hundreds of SQLite databases and it is estimated that there are over one trillion SQLite databases in active use. Given the above, the importance of examining all of the data held in these databases in an investigation is paramount, and of course this includes examining deleted data whenever possible.In this book we cover the format of the SQLite database, and associated journal and Write-Ahead Logs (WAL) in great detail. We show how records are encoded, how to decode them manually and how to decode records that are partially overwritten. We also describe how the workings of SQLite, and in particular the journal and WAL, can be used to ascertain what has happened in a manner that cannot be determined from the data alone. We cover basic SQL queries and how they can be used to create a custom report that includes data from different tables, and we show how we can use SQL queries to test hypothesises about the relationships of data in different tables.This book is aimed mainly at forensic practitioners, and it is assumed that the reader has some basic knowledge of computer forensics; it will also be of interest to computer professionals in general particularly those who have an interest in the SQLite file format.


SQLite Forensics Related Books

SQLite Forensics
Language: en
Pages: 315
Authors: Paul Sanderson
Categories:
Type: BOOK - Published: 2018-05-12 - Publisher:

DOWNLOAD EBOOK

SQLite is a self-contained SQL database engine that is used on every smartphone (including all iOS and Android devices) and most computers (including all Macs a
Android Forensics
Language: en
Pages: 394
Authors: Andrew Hoog
Categories: Computers
Type: BOOK - Published: 2011-06-15 - Publisher: Elsevier

DOWNLOAD EBOOK

"Android Forensics" covers an open source mobile device platform based on the Linux 2.6 kernel and managed by the Open Handset Alliance. This book provides a th
iPhone and iOS Forensics
Language: en
Pages: 327
Authors: Andrew Hoog
Categories: Computers
Type: BOOK - Published: 2011-07-25 - Publisher: Elsevier

DOWNLOAD EBOOK

iPhone and iOS Forensics is a guide to the forensic acquisition and analysis of iPhone and iOS devices, and offers practical advice on how to secure iOS devices
Information and Communication Technology
Language: en
Pages: 567
Authors: Khabib Mustofa
Categories: Computers
Type: BOOK - Published: 2013-03-09 - Publisher: Springer

DOWNLOAD EBOOK

This book constitutes the refereed proceedings of the International Conference on Information and Communication Technology, ICT-EurAsia 2013, and the collocatio
An In-Depth Guide to Mobile Device Forensics
Language: en
Pages: 216
Authors: Chuck Easttom
Categories: Computers
Type: BOOK - Published: 2021-10-21 - Publisher: CRC Press

DOWNLOAD EBOOK

Mobile devices are ubiquitous; therefore, mobile device forensics is absolutely critical. Whether for civil or criminal investigations, being able to extract ev