Name: MySQL - 結構介紹 (MySQL - Structure Introduction)
Uploaded: 2021-01-14T10:10:39.000Z
Duration: 41 min 16 s
Description: 【看影片學英語】數萬部 YouTube 影片，搭配英漢字典即點即查，輕鬆掌握單字發音與用法，長久累積看電影不必再看字幕。

動名詞

creating these classes requires equipment and service.

If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

As you know, I am Eli the computer guy, and today we're going to be doing an introduction in it to the Maya sequel structure.

When you're going be building out a system using my sequel as the database back in, I want to give you an idea of basically like, logically, what does this look like?

So what I'm talking about here is that they were going to be talking about the servers were going to be talking about the database software.

So my sequel we're gonna be talking about the databases themselves were going to be talking about the tables we're gonna be talking about.

The columns were going to be talking about the records that a types basically giving you an eagle eye view of when we were talking about a database structure.

What does this actually look like so that you can then go and try to figure out each individual component and build out what you need So this class today is basically just going to be giving you that eagle eye view of what my sequel structure looks like s O that you have a better idea of what's going on when we start going into the more indepth classes.

So for this class today, we're primarily going to be on the white board again.

I know I have world class drawing skills.

Those drawing skills really help you folks understand how all of these things work and how they all go together.

So let's go over the white board so I can start drawing things out to try to explain to you how the my sequel structure looks when you're dealing with it in the real world.

So the first thing that we need to go over when we're talking about my sequel structure or really any kind of database structure we first need to talk about what is the front end and what is the back end?

So you will hear about the front end for applications and you will hear about the back end for applications.

So basically, what we're talking about with the back end for applications is this is going to be your database system.

So with us, but we're gonna be talking about is, of course, my sequel.

But for your back end, you could have Oracle.

You could have some kind of no sequel solution or whatever.

Basically, what the back end does is the back and actually stores all of the data so that it can be easily accessed by the front end.

So from the front end is the actual application your users are going to be using in order to access the data in the data base in the back end that you've created.

So this may be some kind of Web applications, So think about something like salesforce dot com.

Basically, you go to that Web site, you have a Web page in front of you you're able to put in from in information, you're able to pull out reports.

So basically, that's what's called a Web front, and or you might have a mobile front and right, So if you have your little iPhone or you have your smartphone somebody creates a native application for that phone.

And again, maybe this is a customer relationship management software.

Maybe this is a work order software again, sometime Type of data intensive software basically what'll happen is that mobile app will go back and communicate with your back end in order to be a bit pushy.

Data basically store that in the database and then pull it for when you're looking for records or whatever.

So when we start talking about things like front end and back ends, this is what we're talking about.

The front end, the front end for any of these service's or applications is basically the user interface that people are going to be interacting with.

Whether this is a Web interface, whether this is a mobile interface, whether it's the desktop interface, something like that, that is what the front end is.

And then the back end is the overall system that contains all of the data that the front end will require to actually give any kind of functionalities.

We're talking up front ends and back ends so past this.

Now let's talk about kind of the physical structure of the my sequel structure that we're gonna be dealing with here.

And so, basically, if you're going to be using my sequel database, generally you're going to actually be spinning up or turning on some kind of physical server on.

So, basically, you have the physical server.

So it's a physical server from a company like Dell or Lenovo or something that you just build on your own.

So again, you get your CPU RAM your hard drive.

You build it out however you want, then on this physical machine, then you're going to install an operating system so that operating system is most likely gonna be Lennox.

But it could be Windows, or it could even be Mac OS.

I guess some people are still running Solaris out there, right?

So basically, you're going to install the operating system onto that physical hardware and then on to this.

Then we're going to install installed the database software so it is important.

We're talking about my sequel or Maria de B or any of these other database solutions.

A piece of software, just like SharePoint is a piece of software.

You actually have to install this software onto onto a machine, whether it's a physical machine or a virtual machine s.

So then you will be installing my sequel onto your physical or virtual machine, and now you have something to work with.

So this is now a database server, and so this database server may be part of your back in for whatever solution that you're providing Now.

Understand when you start dealing with databases that you can create things called clusters.

So what clusters are clusters are awesome clusters or what you should be using If you have databases eyes.

Basically, you can light up multiple different servers, install my sequel onto his multiple different servers and then basically have the databases replicate data amongst all of these different servers so that have won the physical or virtual machine fails.

The cluster stays up and running, so basically in this instance, then right if we have a front end here.

So if we have a little smart smartphone and that's trying to communicate back with a server, that's one of things you ought to be thinking about when it's communicating with a back end.

It may be communicating with just one physical or virtual server, or it might be communicating with a whole cluster of these database servers.

And basically, how how the data is routed is determined by what you have coded that type of thing.

So the first thing that you need to be thinking about when you're thinking about the my sequel structure is that you actually have to have my sequel running on something, right?

If you take a database file and just dump it on a server and it doesn't have the software to actually run it, then nothing is going to happen.

So you're actually going to need to install my sequel onto a physical machine and depending on how complicated your infrastructure is, you then may actually create a cluster of these.

My sequel databases servers for things like fail over reliability, load balancing and that type of thing.

Now, once we get past the physical structure of your database system again with your server with your cluster, whatever you have going off your back end, then we need to actually go into my sequel and see how the databases are actually laid out, right so you have your server, it has my sequel on it.

And then within my sequel, you won't have databases.

Now, the important thing to understand with how you design your database within my sequel is it really is up to you.

It's It's how you look at things logically.

So basically, when you have databases, when you have tables, you are grouping things together a logically now when the problems you run into the room in the real world is what you can serological and what your buddy considers logical may be completely in different things.

And so that's one of the issues that you can run into with.

Basically, these database structures is that people can designed.

The database is really insane ways, because for them, it made a hell of a lot of sense, even though it doesn't make a lot of sense to anybody else.

The big thing is, when you're grouping things, what's supposed to be, is it supposed to be a logical So when people go in to do maintenance on the database, when people go and they try to write new code in order to interact with the database.

Basically, when they're trying to do the normal, you know, I t related task of the database.

It should be rather easy to understand what's going on.

You should be able to go in and very quickly be able to understand what's going on with the database.

The problem is, though, that's not a technical thing.

You can have software work, you can have a database, works that's ugly as hell.

It could be incredibly ugly, and it can be incredibly complicated, and nobody can understand what's going on.

But the computer can still make it work because it's still functionally works.

So that's one of the issues that you can run into s so the first thing when you're dealing with the my sequel infrastructure is that the highest level?

So the highest level we're gonna be dealing with is what is called that database, right?

So with n my sequel, So you have my sequel, install it on your server, and then you can create a database and the important thing to understand here is you can create one database or to databases or 20 databases if you want.

Just logical high level groupings for all the data that you're gonna have now, a lot of times, if you have a company, you will just have one.

So you're gonna have one single database that's gonna have your inventory that's gonna have your users that's gonna have her invoicing system and the whole nine yards, right?

So that may be what you want to do because one of the cool things with these databases is you can actually have, like, user accounts for the databases.