How to plan and create hierarchical database MySQL?

Asked By janetsbraswell 50 points N/A Posted on - 12/09/2012

I think I need to create hierarchical database MySQL for bigger projects in the future.

What should I consider when creating bigger databases?

Can you give me an idea on  how to do it?

Can you give links for reference?

Thanks a lot.

• Status: Open
• Question Views: 815
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Whudson Audrey

Go To Solution

Answered By Vogt Joan 0 points N/A #135987

How to plan and create hierarchical database MySQL?

Hi,

When creating big databases I think it is very important to consider followings.

1. Usage of the database ( Whether it is a high or low transactional one)
2. Security features of database (This depends on the type of data you are going to use to store.)
3. Pattern of usage. (This means any peak or off peak hours to accessing the database & expected users in different time slogs.)
4. Up time of the database.
5. Size of the database. (Depend on the size of the DB you have to design your tables other relevant fields.
6. How to administer your database.
7. How to upload the data to your database. (Specially initial upload if required)
8. How to back up the data if required.
9. Hardware requirements. (This will depend on all the above requirements)

Further you can refer following web site to get more knowledge (Specially technical stuff) about the designing databases.

 

About Vogt Joan

Questions
9

Answers
35

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 12/16/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Whudson Audrey 0 points N/A #194927

How to plan and create hierarchical database MySQL?

Hi,

Any hierarchical data bank type can be an information type where the information is usually sorted in a treelike framework. A business might keep staff information in the table containing attributes/columns for instance staff amount, initially identify, finally identify, along with Division amount.

The business delivers each and every staff along with computers as essential, nevertheless computer system tools may possibly just be used because of the staff to be able to which often it can be given.

The business might keep the actual computer information in the different table that has each and every part's serial amount, variety, along with the staff that employs the item. Generally you must do is usually;

1. Using the database ( Be it a superior or even small transactions one)
3. Safety measures top features of information base (This depends upon the type of information you will definitely employ to be able to keep. )
3. Routine associated with usage. (This means any high or even down high a long time to be able to being able to view the database & estimated people in different time period slogs. )
4. Uptime period in the information base.
5. Measurement in the information base. (Depend on the dimensions of the actual DB you should pattern your own table's other appropriate fields.
6. The best way to dispense computer database.
7. The best way to upload the data to your information base. (Specially primary upload in case required)
8. The best way to backup the data in case necessary.
9. Components prerequisites. (This will depend on each of the earlier mentioned requirements)

It is possible to carry support:

About Whudson Audrey

Questions
3

Answers
102

Best Answers
59

• Vote Up 0 Vote Down

• Posted on - 02/25/2013
• Question Category: MySQL Server