Database Engines

00:00

Hi we're gonna module to This is a lesson 2.1 database engines and module to We're just gonna do a quick review and go over some basic database concepts to get in the fuel of things.

00:11

And the first lesson that we're going to go over is database engines. So what is the database engine? It's software. The specializes in the management of databases. It's a major component of the database management system or D B. M s for short

00:27

database engines. Provide the four basic data operations which are create, read, update and delete.

00:33

They're very efficient. A lot of the database engines that we are all familiar with such is my sequel or Microsoft sequel have been around for quite a bit of time, and they've had a long time to develop and mature

00:46

that race engines also provides structures to promote customized efficiency, such as implementing your own custom indexes on data tables.

00:55

They provide structures for concurrency control,

00:58

which is what happens when multiple users are working on the same data. At the same time, we can program to account for this.

01:07

Also,

01:07

database engines aimed to provide something called acid, which is Adamis ity consistent, see isolation and durability. Or, to sum it up, they tried to make the database engine as resilient as possible so that the data is not easily corrupted in the event of a

01:26

events such as power failure.

01:30

And that brings us to summary

01:33

2.1 database engines summary.

01:34

We described a database engine at a very high level,

01:38

but put simply, a database engine provides the controls for effective and efficient data storage through pragmatic interactivity. And what is some of that pragmatic interactivity? Well, that's the sequel code it's or the sequel programming that will we will be doing later on in this lesson.