Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,550 --> 00:00:05,340
So what are all the differences with all these databases?
2
00:00:05,360 --> 00:00:09,950
I mean, I've only shown you a few of the options as we have for databases.
3
00:00:09,950 --> 00:00:18,830
There are hundreds of options, for example, if I search database management system.
4
00:00:20,630 --> 00:00:25,670
I'll probably get a list of database management system, let's do Wikipedia here.
5
00:00:30,120 --> 00:00:36,660
All right, so database management systems, as you can see, there are a lot of them.
6
00:00:38,600 --> 00:00:45,920
Once again, we should understand this, if we go to database's, we got a list of databases or lists
7
00:00:45,920 --> 00:00:47,620
of database management systems.
8
00:00:48,440 --> 00:00:51,340
So let's look at the list of database management systems.
9
00:00:51,350 --> 00:00:53,750
And again, there are a ton.
10
00:00:53,840 --> 00:00:58,430
Now, if we click on, let's say, the first link, yeah, that's a lot of databases.
11
00:00:59,390 --> 00:01:05,780
Now, you're never going to use all these databases throughout your career, you'll probably touch a
12
00:01:05,780 --> 00:01:09,190
few, just probably less than five.
13
00:01:09,200 --> 00:01:12,410
Most people might just have two or three databases that they work with.
14
00:01:12,710 --> 00:01:21,370
But you can categorize databases into five main types, these five main types of databases.
15
00:01:21,380 --> 00:01:27,830
I'm not going to go into full detail because you need to learn more about databases before you truly
16
00:01:27,830 --> 00:01:29,180
understand their differences.
17
00:01:29,180 --> 00:01:34,880
And later on in the course, it will actually cover some of the differences between databases and learn
18
00:01:34,880 --> 00:01:38,120
about some interesting popular databases that are out there.
19
00:01:38,450 --> 00:01:43,660
But for now, let's talk about the five kinds often called the five data models.
20
00:01:44,330 --> 00:01:47,220
One is the relational model.
21
00:01:47,360 --> 00:01:50,230
This is one of the most popular ones.
22
00:01:50,540 --> 00:01:53,330
This is the one that we kind of saw with my school.
23
00:01:53,330 --> 00:01:57,790
And PostgreSQL, they support something called asset transactions.
24
00:01:57,830 --> 00:02:00,680
Sounds complicated, will dive into what that is.
25
00:02:01,010 --> 00:02:09,680
But popular databases like postgrads, like MySQL, Microsoft's SQL Server all use this relational model
26
00:02:09,890 --> 00:02:12,950
and it's probably the most popular.
27
00:02:13,310 --> 00:02:17,140
And this relational databases work really, really well with escudo.
28
00:02:17,690 --> 00:02:23,090
So you'll see these types of databases and a lot of e-commerce websites, a lot of websites that have
29
00:02:23,090 --> 00:02:26,540
customers or users inside of businesses.
30
00:02:26,570 --> 00:02:32,120
They have a lot of applications and in the scores who are really going to dive deep into relational
31
00:02:32,150 --> 00:02:32,900
databases.
32
00:02:33,650 --> 00:02:39,230
Next is a document model, a document model database.
33
00:02:39,230 --> 00:02:43,940
You may have heard of things like Mongo, DB, Couche, DB or FIREBASE.
34
00:02:44,240 --> 00:02:46,700
They use what's called a document model.
35
00:02:47,180 --> 00:02:55,250
And in this case, data is almost in a document rather than rows and columns like we saw in the Amazon
36
00:02:55,250 --> 00:02:55,850
exercise.
37
00:02:56,090 --> 00:03:02,600
These databases are usually a big document that contain a ton of related information.
38
00:03:02,600 --> 00:03:08,840
Together, these types of databases are usually really, really good at what we call scalability databases
39
00:03:08,840 --> 00:03:12,770
that have to hold more and more data that have to be more and more performant.
40
00:03:13,400 --> 00:03:20,060
We'll talk about the differences between these types of databases and document databases, because it's
41
00:03:20,060 --> 00:03:21,080
a popular topic.
42
00:03:21,080 --> 00:03:25,460
You may have heard of PostgreSQL versus Mongo DB We'll have a video on that later on.
43
00:03:26,330 --> 00:03:29,360
Then we have key value databases.
44
00:03:30,200 --> 00:03:35,990
Now, you may have heard of things like retests at CD or Dinamo DB.
45
00:03:36,200 --> 00:03:38,870
These are key value storage systems.
46
00:03:39,080 --> 00:03:43,790
It's a model that is one of the simplest ways to access data.
47
00:03:43,790 --> 00:03:49,790
You essentially have a key that is, hey, I want to get user ID one and you get to user ID one back.
48
00:03:50,300 --> 00:03:52,280
We're going to have a section on Radice in the course.
49
00:03:52,280 --> 00:03:55,670
We can learn how a key value database might work.
50
00:03:56,480 --> 00:03:59,270
Then we have graph model databases.
51
00:03:59,450 --> 00:04:04,070
These are databases like Neo for or A.W..
52
00:04:04,070 --> 00:04:04,970
Yes, Neptun.
53
00:04:05,420 --> 00:04:11,300
These types of databases are a lot rarer because they're a little bit more complex and they use something
54
00:04:11,300 --> 00:04:13,070
called a graph model.
55
00:04:13,280 --> 00:04:17,450
That is, it's really good for data that is connected in different ways.
56
00:04:17,930 --> 00:04:20,870
It's all about relationship between different units.
57
00:04:21,650 --> 00:04:28,250
So a social network website might have graph databases because they want to see how different users
58
00:04:28,250 --> 00:04:29,600
are connected to one another.
59
00:04:30,320 --> 00:04:36,530
Out of all of these graph databases are probably one of the least used because they are so specific.
60
00:04:37,460 --> 00:04:41,360
And then finally, we have something called wide columnar model.
61
00:04:42,260 --> 00:04:51,170
These wide columnar models are fairly new and they were pioneered by Google's big table databases like
62
00:04:51,170 --> 00:04:51,710
Apache.
63
00:04:51,710 --> 00:04:57,080
Cassandre, Google's big table are very popular now, all linked to a resource.
64
00:04:57,080 --> 00:05:00,170
If you want to dive a little bit deeper into what these differences are.
65
00:05:00,260 --> 00:05:05,900
But I recommend to hold off on that until you are done with the course, because a lot of these are
66
00:05:05,900 --> 00:05:08,900
new topics that might be hard for you to understand.
67
00:05:09,080 --> 00:05:10,790
Ideally, you finished the course.
68
00:05:10,790 --> 00:05:16,760
We explore some of the relational document key value databases, understand what their differences are,
69
00:05:16,760 --> 00:05:20,120
what the pros and cons are, and then you can dive deeper and deeper.
70
00:05:20,870 --> 00:05:27,020
But I wanted to just mention it briefly here, because with this course, the goal is to get you comfortable
71
00:05:27,020 --> 00:05:33,950
with school, with the idea of databases and so that you are able to make decisions on when to use what
72
00:05:34,700 --> 00:05:35,570
I'll see in the next one.
73
00:05:35,870 --> 00:05:36,230
But by.
7689
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bengali
Bosnian
Bulgarian
Catalan
Cebuano
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Finnish
Frisian
Galician
Georgian
German
Greek
Gujarati
Haitian Creole
Hawaiian
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Khmer
Korean
Kurdish (Kurmanji)
Kyrgyz
Lao
Latvian
Lithuanian
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mongolian
Myanmar (Burmese)
Nepali
Norwegian
Pashto
Polish
Portuguese
Romanian
Russian
Samoan
Serbian
Sesotho
Shona
Sinhala
Slovak
Slovenian
Somali
Spanish
Swahili
Swedish
Tajik
Thai
Turkish
Ukrainian
Urdu
Uzbek
Vietnamese
