Database and Storage

by Eric H
In this article it talked about the importance of physical storage of the database and how to manage it. Storage management is a important factors in the whole database operation, but most time the database administrator leave the task of for other people in the IT department to handle. For best result the database administrators should work together with the storage administrators. There are more data now than ever before, large dad warehouses are becoming very common these days. To store these data the most commonly used disk drives or disk subsystems are RAID, other storage devices like SSD, optical storage are always used. While managing a database the database administrators should focus on preventing loss of data, making sure there are enough capacity for future growth of the database, picking storage systems that have a good balance of reliability and performance, and with all the above requirements and still stay within the budget of the company(Mullins, 2010).

I find this interesting relates to the project and everything we talked about in class. Currently the project we are working on has very little data, but the database files thatĀ  i get after detachingĀ  from SQL Server is pretty big at about 3MB. It doesn’t matter much, because it’s only a little bit of data. But what if the amount of data we have to enter were thousands times of the one we have now, then storage will become a problem. The concept of physical disk storage doesn’t cross my mind when i think about database, but reading the article got me thinking about the actual storage medium. If i were to get into database administration i will make sure i pay more attention in picking the perfect amount of storage, and the perfect storage system that are easily upgrade

Citation:

Mullins, C. S. (2010). Managing database storage. Database Trends and Applications, 24(3), 29-29. Retrieved from http://search.proquest.com/docview/750364445?accountid=10357

1 thought on “Database and Storage”

  1. I agree, many developers often forget about the physical storage capacity they setup their databases. They are too tied up with the actual code that it it often too late when they start to notice it. Adding too much data into limited capacity storage system will affect the performance by a large margin.

Comments are closed.