Time
1 hour 57 minutes
Difficulty
Intermediate
CEU/CPE
4

Video Description

In this section we have a look at the various database models: - Hierarchical - this database structure is much like an org chart and is tree-like in fashion. Examples of this model are the DNS and Active Directory. - Distributed - in this model, there is no single server where the database resides. Instead, it is distributed across numerous locations. Again, DNS is an example. - Object-oriented - this model uses the concept of objects as opposed to just treating everything as text. As a result, it's more complex. Characteristics of the OO model are reusability and being modular in nature. - Relational - this model is based on tables that are related via fields that they hold in common. Examples of relational databases are MySQL and Oracle. We'll spend most of our time here!

Video Transcription

00:04
All right. Now we move on to database models, and when we're talking about databases, several different models and the the idea of the model has to do with how the information is stored, any sort of relationships or sort of context in which we house the data
00:22
and we've got four main models will have the hierarchical databases distributed, databases, object, worrying it and relation all databases.
00:34
So, uh, when we talk about a hierarchical data base, this is like an organizational chart. You know, if you think about it, you've got the president of the company of the top,
00:43
and then maybe you have the VPs of different departments and department heads and so on. So that's a hierarchical database. The information stored in the hierarchy Active directory is not a hierarchical database. As his d. N s. You started the route, then you've got the dot com dot or dot edu
01:02
and then the various, um,
01:03
other elements underneath.
01:07
Now, D. N s is also a distributed database because D. N s, you know, there is no single server that has the D. N s database. It's distributed throughout, so there's a dot com server a dot e D u and dot warg and dot mil and dot gov s so that makes the database distributed
01:26
object oriented databases. We're really not gonna get into those, but the terms that are always very, very common when we use the phrase object oriented, reusable and modular in nature. So ultimately, it's a means of story.
01:45
Sort of those. There's not not really talking about text here but graphical objects
01:49
and then having the properties and others informations of different objects. That would be odd Victorian date basis. But where we really want to spend our time is in the Relational Databases sequel. Oracle and many of the other databases are relational in nature. And ultimately, the building block
02:09
is the table in the tables or than related,
02:13
and we'll talk about the fields that create those relations. So relation all databases, really. We're going to spend the majority of our time

Up Next

Software Development Security

Domain 8 covers understanding, applying, and enforcing software security

Instructed By

Instructor Profile Image
Kelly Handerhan
Senior Instructor