Setting up MySQL

[Trilex]

ok, so here is the back story, my dad is starting up a company, he is going to create a website and a email, he already has his domain name. The company will buy equipment which will be loaned to mining areas in Rural Australia. Would it be beatifically to setup a MySQL server to get information from databases (like mining trends/info, etc) to see when new equipment is needed to be bought so that what he can maximise profit? Do you need to have a website with MySQL built in? Can i host my own MySQL server at home and what system specs will i need? 

 

Thanks 

[Trilex]

Just now, Trilex said:

ok, so here is the back story, my dad is starting up a company, he is going to create a website and a email, he already has his domain name. The company will buy equipment which will be loaned to mining areas in Rural Australia. Would it be beatifically to setup a MySQL server to get information from databases (like mining trends/info, etc) to see when new equipment is needed to be bought so that what he can maximise profit? Do you need to have a website with MySQL built in? Can i host my own MySQL server at home and what system specs will i need? 

 

Thanks 

Also i am new to this stuff i usually am a networking person so excuse my mistakes. 

 

Thanks 

[fatfattie]

So why do you need MySQL specifically?

 

It's just a type of DB that you can attach to any system you'd like.

It depends what you'll be running MySQL with. It is possible to run an MySQL server from somewhere else, but the Software you are trying to use must support:

a) MySQL itself

b) support external DB access

 

Tough, from a security standpoint it is highly disencouraged to make any database publicly accessible.

 

I haven't heart of Inventory Systems on a Web-basis. Or, are you trying to use Inventory management features from an ecommerce platform?

[Trilex]

14 minutes ago, fatfattie said:

So why do you need MySQL specifically?

 

It's just a type of DB that you can attach to any system you'd like.

It depends what you'll be running MySQL with. It is possible to run an MySQL server from somewhere else, but the Software you are trying to use must support:

a) MySQL itself

b) support external DB access

 

Tough, from a security standpoint it is highly disencouraged to make any database publicly accessible.

 

I haven't heart of Inventory Systems on a Web-basis. Or, are you trying to use Inventory management features from an ecommerce platform?

Please explain what you mean, i am knew to this stuff. Also i want to MySQL server to tell me when to buy stuff based on current trends, Could MySQL do this or is it beyond its limits? 

 

Thanks 

[fatfattie]

1 minute ago, Trilex said:

Please explain what you mean, i am knew to this stuff. Also i want to MySQL server to tell me when to buy stuff based on current trends, Could MySQL do this or is it beyond its limits? 

 

Thanks 

MySQL is a relational database system, which (put simply) means you can store (write, save) and read Data. The Data you are trying to store can be associated with other set's of data. This makes it "relational".

 

 

Theoretically, it could do this. But it would need additional logic. Meaning, another piece of software, or code you wrote yourself.

 

Take a look at this graphic which I stole from here.

 

You see three tables. They all need to be populated and maintained by a human. There also needs to be a view (User-Interface) for that. But the key here is that there are only two Tables that contain effective Data. "Students Table" and "Activities Table", the third "Participants Table" is a union of information. Again, put simply, it's just yet another table that stores parts of Data from another table. By doing this, you can figure out that "John Smith", with it's Student-ID of 084 participates in Tennis, which would cost him 36$.

 

In order to estimate the probability how many Students will enroll to play Tennis next year, you'll need to store each and every student's activity from the past and present into yet another Table. In that, you put the mentioned informations above. The Student's-ID, it's activity and maybe a Date when the person enrolled into that particular activity.

 

You can then accumulate (or "query") new data over all four tables in order to answer various questions. Like:

- Did my Student "John Smith" ever enrolled into an other activity? If so, when did that happen?

- Is it likely that more students enroll into swimming during summer-time?

- Do students prefer cheap activities?

- Do enough students enroll for "Squash" in order to keep up the costs of this activity?

 

All of this can be analyzed using MySQL. But how does MySQL know this? Because of software that implemented the possibility to maintain the activities, students and their enrollment. The software then stores these information and adds an additional entry in the fourth table to then give the School's administrator insight (trends) into the effectiveness of it's offered activites.

 

Unless you're a real geek, it is impossible to maintain these set's of information using only MySQL, you need to have something else that can look at your Data (that is inside MySQL) and give a meaningful result from that.

 

 

[Trilex]

9 hours ago, fatfattie said:

MySQL is a relational database system, which (put simply) means you can store (write, save) and read Data. The Data you are trying to store can be associated with other set's of data. This makes it "relational".

 

 

Theoretically, it could do this. But it would need additional logic. Meaning, another piece of software, or code you wrote yourself.

 

Take a look at this graphic which I stole from here.

 

You see three tables. They all need to be populated and maintained by a human. There also needs to be a view (User-Interface) for that. But the key here is that there are only two Tables that contain effective Data. "Students Table" and "Activities Table", the third "Participants Table" is a union of information. Again, put simply, it's just yet another table that stores parts of Data from another table. By doing this, you can figure out that "John Smith", with it's Student-ID of 084 participates in Tennis, which would cost him 36$.

 

In order to estimate the probability how many Students will enroll to play Tennis next year, you'll need to store each and every student's activity from the past and present into yet another Table. In that, you put the mentioned informations above. The Student's-ID, it's activity and maybe a Date when the person enrolled into that particular activity.

 

You can then accumulate (or "query") new data over all four tables in order to answer various questions. Like:

- Did my Student "John Smith" ever enrolled into an other activity? If so, when did that happen?

- Is it likely that more students enroll into swimming during summer-time?

- Do students prefer cheap activities?

- Do enough students enroll for "Squash" in order to keep up the costs of this activity?

 

All of this can be analyzed using MySQL. But how does MySQL know this? Because of software that implemented the possibility to maintain the activities, students and their enrollment. The software then stores these information and adds an additional entry in the fourth table to then give the School's administrator insight (trends) into the effectiveness of it's offered activites.

 

Unless you're a real geek, it is impossible to maintain these set's of information using only MySQL, you need to have something else that can look at your Data (that is inside MySQL) and give a meaningful result from that.

 

 

Ok, I know what you mean, can the data from the tables be integrated into a website and then add new info based on who creates a account and there purchases? How hard is this all to setup and get working? What piece of software do I need? 

 

Thanks