Pros and Cons of Different Databases{4}



The article i read was about the different types of databases and which ones are right for different applications. The first type of database the article talks about are desktop databases such as Microsoft Access, FileMaker Pro, and Lotus Approach. These databases are mainly used by small business’ because they are relative;y cheap and they often already have a graphical user interface built into them. The problem with these databases is the fact that they are usually not very safe. The next type of database is server databases. These can hold many more records than a desktop database but it comes at a cost. The licensing on server databases is generally much more expensive. This type also generally uses SQL and needs some sort of database design which is another cost that is incurred when using these. The main upside to server databases is that they are very fast and generally much safer to use. The nest type of database is cloud-based databases. The nice thing about the cloud based databases is that there is no need to have high end hardware to run the database. As a company you would not need to keep as many people staffed to run the database also. Cloud services are also widely available and for the most part allow you to have access to the information virtually anywhere. The problem with the cloud based services is the security issues, if you have access to it anywhere it is much easier for someone else to have access to it. The other problem is that it is kind of one-size-fits-all. The cloud services don’t generally allow you too much customization.

I found this article interesting because it gave me a good idea as to the different types of databases that are out there. It also put together the pros and cons of each of the databases which was nice to be able to see them side by side. I think this is important to this class because it gives us a good idea as to what kind of databases are being used and what some of the potential problems with are. It also allows us to see a side by side comparison of the databases and what their uses are.

 

Reference:

Gravelle, R. (2011, October 27). [Web log message]. Retrieved from http://www.databasejournal.com/features/which-database-is-best-for-you.html