Two most popular relational database management systems are SQL and MySQL. SQL is developed and managed by Microsoft while MySQL is developed and managed by Sun Microsystems. These two databases work on data storage and data retrieval mechanism and both support ANSI-SQL. It is very difficult to say that which is the better database because one has better performance in some circumstances and another is better in other circumstances. If cost matter for you then prefer MySQL because it is free for non-commercial organization but chance to recover MySQL database is less in comparison of SQL.
Features
|
MSSQL
|
MySQL
|
Two tiered Scheme for License
|
Yes
|
Yes
|
Cost
|
Free & Paid
|
Free & Paid
|
Cheap
|
No
|
Yes in comparison of SQL
|
Open Source
|
No
|
Yes
|
Operation system support
|
Windows
|
Supports around 2 dozen
|
Storage Engine Support
|
Sybase-derived engine
|
MyISAM, Innodb & many others
|
Memory Use
|
Use large memory
|
Use less memory
|
Online Backup
|
Yes
|
No
|
Performance Scale
|
Good
|
Better in comparison with SQL due to its default table format
|
Recovery of Data after system shutdown
| Better because data passes through multiple checkpoints |
May loss of data
|
Transparent data encryption
|
Yes
|
No
|
Note: The above described chart is not enough to differentiate SQL vs MySQL but it will try to show you a quick view about what these database offer you.
Which is best? From my point of view, if a database will fulfill my all requirement then it is the best database for me.
No comments:
Post a Comment