help : Different Databeses

Question

MySql, SqlServer, Oracle , ......

What is the different between them?
and
which is the best?
and
what's their IDE or program use to work with?

Answer 1

For studying other db models (other than relational) you can study NoSQL. For some applications they work really nice.

Answer 2

@Vadim Ok no problem. Sorry if I was too greedy. I play from the start of the list to the end. And I'm from Iran ☺
Best Regards. Developer.

Answer 3

@Vadim No to what?!

Answer 4

SQL SERVER = Microsoft
Oracle = Oracle
MySQL = Oracle (free)
DB2 = IBM
Access = Microsoft

Each has its own management system (SQL Server has Management Studio/ SSMS, Oracle database has Oracle SQL Developer). All can be managed by SQL and GUI.

One textbook ranks in terms of performance (without details how they measured it):
1. Oracle
2. DB2
3. SQL Server
4. MySQL
5. Access
but as SQL Server is optimised for Windows, this can be easily #1 on a vast majority of machines.

Answer 5

Bad English))

Answer 6

@Developer, you were not. I also wanted to ask this question 😀

Answer 7

They are all built on the same concept called Relational calculus. The difference is only in their implementation but the interface they offer to interact with them will be almost same. For example all the database servers mentioned above support a standard language called SQL to interact them. In addition to the standard interface, each provider has custom additions useful for their loyalists. I can't pick one as the best because each one of them has their own advantages and disadvantages.
coming to the IDEs, for MSSQL server we have SQL server management studio, For MySql also we have an IDE. If you are developing web application using PHP, phpmyadmin is a useful tool. Apart these are some database agnostic interfaces are also available. We can also interact using command line.

Answer 8

@Developer I am don't play. I am from Russia

Answer 9

@Developer no

Answer 10

Addition:
As of November 2017 Microsoft's DBMS SQL Server is named #1 by Gartner:
https://info.microsoft.com/rs/157-GQE-382/images/Gartner_ODBMS_MQ_2017.jpg