Which Database Is Best for You?{3}

by Polun L
The article talks about the pros and cons of the various relational database management system products and solutions. It mentions that there are different types of database management systems which are Desktop, Server, Web-enabled, Cloud DBaaS and Open Source. The most economic one is Desktop because it is low cost and suitability for single-users or non-interactive Web application batch processes. Also, a user can easily manage a desktop database by using Microsoft Access, FileMaker Pro, and Lotus Approach. Next, Server Database is good for heavy workload such as webhosting company, and ecommerce site…etc. The advantages of running server database are that it delivers hundred of millions data in a fast speed performance, and it allows an administrator to manage data easily with business intelligence tools. However, each server requires various types of licenses depending on the software a business uses in the server. For instance, a webhosting company may need to spend a lot of money on buying licenses because the company runs more than one server at least. The third type of database is Open Source Database. Basically, open source software/database means that it is free to everyone to install its database on a user’s computer. This disadvantage is that it does not have full support to solve an issue immediately when the software encounter any errors or bugs. Last, Cloud Service consists of one or more databases that are hosted by a third party. Its advantages are that it efficiently stores, backups, collects data from the end user to its database. Then, the database sends out information back to the user immediately whenever a request is made. It is very popular and widely used nowadays because it contains accurate abundant resources and allows users to access its own data anytime.

I really like this article because it clearly points out the advantage and the disadvantage of each type of database. Before I read this article, I was quite familiar with desktop database, server database as well as open source offerings. As for the cloud, the first time I heard it was the new application, iCloud, released by Apple Inc. By that time, I only had a basic concept of how the iCloud worked. After I read the article, I’ve finally known that the advantage of cloud supports scalablility, modestly flexibility and high availability, as in 99.999% uptime.

Gravelle, Rob. “Database Buyer’s Guide Conclusion: Which Database Is Best for You? — DatabaseJournal.com.” Database Journal – Daily Database Management & Administration News and Tutorials. ITBUSINESSEDGE, 27 Oct. 2011. Web. 08 Jan. 2012. <http://www.databasejournal.com/features/which-database-is-best-for-you.html>.