?
Solved

My SQL, SQL Server, DB2, Oracle Advantages Disadvantages?

Posted on 2003-03-25
3
Medium Priority
?
24,458 Views
Last Modified: 2012-08-14
Hi,
  I am designing a conference management system, I have not determined which database to use and would desperately like to know what are the main advantages/disadvantages to implmenting such a system in the following databases:

- MySQL
- SQL Server
- DB2
- Oracle

Any help would be greatly appreaciated

Thanks

Dan
0
Comment
Question by:danny1979
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Expert Comment

by:thehaze
ID: 8205142
MySQL: The software and support are free. All of the others cost money.
0
 
LVL 32

Accepted Solution

by:
Brendt Hess earned 80 total points
ID: 8205413
One other to consider - PostgreSQL ( http://www.postgresql.org )

Advantages:
SQL Server
   Good tools
   Much support available
   Stable
   Complete

DB2
   Much Support Available
   Runs on multiple platforms
   Easily Scalable
   Stable

Oracle
   Much Support Available
   Runs on multiple platforms
   Easily Scalable
   Stable
   Arguably fastest for large datasets

MySQL
   Free
   Much support available
   Good Developer community
   Stable
   Runs on multiple platforms

PostgreSQL
   Free
   Stable
   Runs on Multiple Platforms
   Good Developer community
   
Disadvantages:
SQL Server
   Only runs on MS platforms
   Not as robust as DB2 or Oracle (unknown compared to MySQL and PostgreSQL)
   Can be expensive
   Requires some administration

DB2
   Not as robust as Oracle
   Can be expensive  
   Requires administration

Oracle
   Can be Very expensive
   Requires trained administrator

MySQL
   Not as many features as above in default config
   No direct ADO support

PostgreSQL
   No direct ADO support

That's my 2c worth
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question