MySQL Developing And Programming Blog

Working with MySQL SQL 26 The database administrator, who can also be the developer, creates databases by using the DBMS to hold specific data. For instance, an application might include general data such as accounts, addresses, and other forms of basic information. In addition to the account information, the application scans documents into the database from a scanner. This binary data has a much greater space need than the account information, so it is given a separate database. By separating the data into different databases, the DBMS generally allows them to be assigned different disk drive locations. The image data might be stored on a large array of disks, while the account information is stored on smaller disks but configured as a redundant array of independent disks (RAID). Figure 3.1 shows how this might look. Server running MySQL Raid Level 1 MySQL Database Large image data Account Information Figure 3.1 A multiple-database system. Once the databases for the application have been laid out, tables are introduced to each of the databases. While all of the data could be thrown together into the database, it is usually better to group the data into logical bunches. In an account database, you might have a table for account numbers and some identifying information. Another table in the account database could contain address information. Figure 3.2 shows an example. MySQL Account Database acc_account table acc_address table Figure 3.2 Tables within the database.

Hint: This post is supported by Gama web hosting php mysql provider