Home > Ask the Data management / BI Experts > DBMS and data warehousing Questions & Answers > Tips for evaluating top database management systems and choosing a small DBMS
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

Tips for evaluating top database management systems and choosing a small DBMS

Mark Whitehorn EXPERT RESPONSE FROM: Mark Whitehorn

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 15 April 2009
My small business is beginning to research DBMSes and we need to come up with a shortlist. Can you give me an overview of the market and any vendors/products we should be sure to consider?

>
It really depends how small your business is and what your requirements are, of course. If it is a very small business, say under 10 people, you might want to look at products like Microsoft Access. This is a fine product for small non-mission-critical databases; however, it is inappropriate for larger systems.

If you need something larger the good news is that there are only three major players left in the DBMS market: Oracle, IBM and Microsoft.

Oracle's product is called, not unreasonably, Oracle. IBM has DB2 and Microsoft SQL Server.

If you talk to an advocate of any of these systems you will rapidly learn that that, rather luckily, the advocate uses the one-true-database-engine and the other two are so badly flawed that no one in their right minds would use them. A fractionally more balanced view is that all three of them are extremely robust, highly scalable and perfectly competent.

I would counsel you to look at the applications you want to run, find out which engines they sit on and make your choice on that basis.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
DBMS and data warehousing
Definition of primary, super, foreign and candidate key in the DBMS
What is the difference between a logical and physical warehouse design?
What are some emerging data warehouse and DBMS trends?
How to get data/database independence with a three-tier architecture
How to select an MPP database: DB2 vs. Teradata
What comes first — the data mart or the data warehouse?
What are the top database management systems (DBMS)?
What is the role of DBMS in RDBMS?
Is an Inmon-modeled BI system, like Madison, the future of data warehousing?
What are the benefits and disadvantages of a RDBMS?

IBM DB2 management
How to select an MPP database: DB2 vs. Teradata
What are the top database management systems (DBMS)?
Are there benefits to using both Teradata and a DB2 database?
Exec explains IBM's Information On Demand (IOD) initiative
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 7
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 6
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5
DB2 basics
IBM DB2 basics
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 4

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts