WEBVTT

00:00:01.820 --> 00:00:03.730 align:middle line:84%
So let's look at some
of the basics here.

00:00:03.730 --> 00:00:06.460 align:middle line:84%
With these databases,
SQLite format 3

00:00:06.460 --> 00:00:08.560 align:middle line:84%
is the most common
that's still in use.

00:00:08.560 --> 00:00:11.650 align:middle line:84%
You can see SQLite format
3 file header here.

00:00:11.650 --> 00:00:13.840 align:middle line:84%
These file headers are
important because, when

00:00:13.840 --> 00:00:15.520 align:middle line:84%
we talk about
evidence destruction,

00:00:15.520 --> 00:00:17.860 align:middle line:84%
and we need to
carve for items, we

00:00:17.860 --> 00:00:19.660 align:middle line:84%
may need to carve
for that file header.

00:00:19.660 --> 00:00:22.850 align:middle line:84%
So any that you know of,
you can always Google these.

00:00:22.850 --> 00:00:25.300 align:middle line:84%
You want to make sure
you're documenting them.

00:00:25.300 --> 00:00:29.900 align:middle line:84%
There are other databases in
use that you're going to see.

00:00:29.900 --> 00:00:32.270 align:middle line:84%
When we look at
databases in general,

00:00:32.270 --> 00:00:34.310 align:middle line:84%
these are relational
databases that

00:00:34.310 --> 00:00:37.010 align:middle line:84%
are used to store/modify
access data.

00:00:37.010 --> 00:00:38.210 align:middle line:90%
They are efficient.

00:00:38.210 --> 00:00:39.720 align:middle line:90%
They can grow in size.

00:00:39.720 --> 00:00:41.550 align:middle line:90%
They are open source.

00:00:41.550 --> 00:00:44.480 align:middle line:84%
You will see a vast
amount of sizes and things

00:00:44.480 --> 00:00:47.930 align:middle line:84%
that differ depending on
the artifact of interest.

00:00:47.930 --> 00:00:50.540 align:middle line:84%
You could have some
enormous databases.

00:00:50.540 --> 00:00:54.230 align:middle line:84%
A good example is my
Photos.sqlite database.

00:00:54.230 --> 00:00:56.840 align:middle line:90%
I use my iPhone as my camera.

00:00:56.840 --> 00:01:00.120 align:middle line:84%
My Photos.sqlite
database is enormous.

00:01:00.120 --> 00:01:02.660 align:middle line:84%
It's not something I probably
want to use for testing.

00:01:02.660 --> 00:01:05.240 align:middle line:84%
I have another iPhone that
I still take pictures on

00:01:05.240 --> 00:01:06.630 align:middle line:90%
that I leverage that.

00:01:06.630 --> 00:01:08.720 align:middle line:84%
So if you have a person
and their photos,

00:01:08.720 --> 00:01:12.500 align:middle line:84%
that SQLite database on
their iPhone is small,

00:01:12.500 --> 00:01:14.000 align:middle line:84%
and you're seeing
a lot of pictures,

00:01:14.000 --> 00:01:15.300 align:middle line:90%
that doesn't make sense.

00:01:15.300 --> 00:01:18.020 align:middle line:84%
So sometimes the
size of the database

00:01:18.020 --> 00:01:20.855 align:middle line:84%
can be a great example
on what you could find.
