Which database software fits your company best?

by Dean H
Summary:

There are so many databases in today’s market, raging from different editions and suppliers. How do you know which is the best one for you? Types of DBMS include Desktop, Server, Web-enabled, Cloud DBAAS, and Open Source. MySQL and PostgreSQL would be under Open Source category.  The article provides an overview of Pro & Cons on each of type. Generally, Desktop Databases are great for small businesses due to the lower overall cost and suitability for single users. The classic example would be Access from Microsoft and Lotus from IBM. Cons for the Desktop databases are obvious: Lack of security measures and prevention from expansion. On the other hand, Server Databases are fantastic in supporting security measures and provide great performance/capabilities to the company. The downside would be relatively expensive(When compared to Access) and requires some database knowledge such as coding in SQL. The server database would be the top choice for medium companies that have a budget for database. A hybrid in between the Desktop and Server Databases would be the Open Source. Open Source databases are cheap (if not free) and provides a good variety of features such as back up, admin tools, recovery..etc. In addition, many free resources are available online. The con is clear: not  formal support from the company. If anything goes one, the user would have to figure out how to resolve/troubleshoot the problem.

Reflection:

It is important to analyze the situation before jumping into the development phase. Choosing the right database for the right project can be cost efficient and deliver the ultimate results. True story: I was assigned to work on a data cleanup project that requires A LOT of data analysis. The company has been using excel – v-lookup to perform the analysis. I suggested that it would be a lot more time efficient and adequate to build a mini database and use it return the values that we are trying to get. At first I suggested SQL express(because we are learning it in class and I want to utilize it in the work place). However after taking a closer look I choice Access for its better GUI and easier to transfer the knowledge onto the next person, if needed. 

Source:

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

It takes me about 30 minutes to search for articles, scan through them, and pick the one to read it thorough.

It takes me about 25 minutes to write up the summary and reflection.

1 thought on “Which database software fits your company best?”

  1. No support from the company being a con for open source databases? I’m not so sure about that. I mean, Microsoft made EVERY ACCESS DATABASE EVER obsolete between Access 2007 and 2010, by arbitrarily taking out the calendar function. They still haven’t fixed it.

Comments are closed.