Turn from: http://www.qqread.com/mysql/z442108305.html
For program developers, MySQL and SQL Server are the two most popular background databases currently in use. The basic similarity between the two is the data storage and the query system. You can use SQL to access the data for both databases, because they all support ansi-sql. Also, both of these database systems support binary keywords and key indexes, which greatly speeds up the query. At the same time, both provide various formats that support XML. Apart from the obvious difference in the price of software, what is the obvious difference between the two products? How do you choose between the two? Let's look at the major differences between the two products, including release fees, performance, and their security.
The fundamental difference is the basic principles they follow.
The basic principles they follow are the main differences: openness vs conservatism. The narrow, conservative storage engine of SQL Server servers is extensible with the MySQL server, and the open storage engine is very different. While you can use the SQL Server's Sybase engine, MySQL can offer more choices, such as MyISAM, Heap, InnoDB, and Berkeley DB. MySQL does not fully support unfamiliar keywords, so it has fewer databases than SQL Server servers. At the same time, MySQL also lacks some of the functionality of the storage program, such as the MyISAM engine to support switching capabilities.
issue fee: MySQL is not all free, but very cheap
When it comes to the cost of distribution, the two products use two very different decisions. For SQL Server servers, the most common way to get a free development fee is to purchase the costs of Microsoft Office or Visual Studio. However, if you want to use the commercial product development, you must also purchase the SQL Server Standard Edition. Schools or non-profit enterprises may not consider this additional cost.
performance: Advanced MySQL
MySQL is pretty good for performance purely because it contains a default desktop format, MyISAM. The MyISAM database is very compatible with disk and does not consume too much CPU and memory. MySQL can run on the Windows system without conflict, and it is better to run on UNIX or similar UNIX systems. You can also use a 64-bit processor to get some extra performance. Because MySQL uses 64-bit integer processing in many cases internally. Yahoo! Commercial website uses MySQL as the background database.
When it comes to software performance, SQL Server servers are much more stable than their competitors. However, these characteristics also have to pay a price. For example, additional complex operations, disk storage, memory loss, and so on must be added. If your hardware and software do not adequately support SQL Server servers, I recommend that you choose other DBMS databases as well, because you will get better results.
Security Features
MySQL has a binary log that changes data. Because it is binary, this log can quickly replicate data from the host to the client. Even if the server crashes, the twos log will remain intact and the copied portions will not be corrupted.
In SQL Server servers, you can also log queries about SQL Server, but this is a high price to pay.
Security
Both of these products have their own complete security mechanisms. As long as you follow these security mechanisms, there will be no problem with the general program. Both use the default IP port, but sometimes unfortunately, these IPs are also hacked into by some hackers. Of course, you can also set up these IP ports yourself.
recoverability: Advanced SQL Server
Recoverability is also a feature of MySQL, which is mainly manifested in the MyISAM configuration. This approach has its inherent imperfections, and if you accidentally damage the database, the results may result in all data loss. However, it is very stable for SQL Server servers. SQL Server servers are able to monitor data exchange points at all times and to preserve the process of database corruption.
decide your choice as needed
For both of these databases, I might disappoint you if I had to say which one is better. In my opinion, any database that helps you with your work is a good database, no database is absolutely outstanding, and no database is absolutely bad. What I want to tell you is that you should start with your own needs, that is, what kind of task do you want to accomplish? Instead of simply starting with the function of the software.
If you want to build a. NET Server system that can access data from several different platforms and participate in database management, you can choose SQL Server servers. If you want to build a Third-party site, this site can read data from some clients, then MySQL will be the best choice.
Both databases are capable of operating under. NET or Java EE, and are also capable of leveraging raid.
===========================
Comparison of ORACLE, SQL Server, MySQL and DB2
Http://book.chinaz.com/CSDN/phppost5/php39602.htm
The following are cited: ORACLE large, perfect, secure
SQL Server simple, friendly interface, good choice under Windows platform
MYSQL free, features good
DB2 Super Large, similar to Oracle |
The following are cited: ORACLE large, perfect, secure
SQL Server simple, friendly interface, good choice under Windows platform
MYSQL free, features good
DB2 Super Large, similar to Oracle |
The following are cited: Oracle: Data integrity, high security requirements of the occasion;
SQL Server (Sybase and MS): MS SQL Server is simple and easy to use for enterprise-class data applications with no performance problems and supports the characteristics of all large RDBMS;
MySQL: basic free, suitable for personal website and some small business website application;
DB2: Large database, the specialty is the access of information. |
The following are cited: Oracle is suitable for larger systems, but it is difficult to get started, even if it is difficult to improve. Need to have long-term practice and groping, but it is really more suitable for large systems. Backup and recovery is more complete, but must be very experienced to do better. The amount of data is not more than 1T, you can use it
SQL Server: Personally think the best database to use under the MS platform. Simple and friendly interface, easy to operate, backup and recovery are easier to learn. and the learning of SQL Server and Sybase is also relatively close.
MySQL used to learn PHP, the feeling is relatively simple, whether it is hands-on or its own function.
DB2 I have used in as/400 and Ms Platform, the feeling is very rigorous, must have a very normative operation. If the amount of data is more than hundred g, it is recommended. |
is referenced below: Oracle actually has nothing to boast of, see his performance this year will know. His technology is now even Microsoft can achieve, from the technical point is that there is no reason to use the
DB2 Data Warehouse is quite good, data mining is also very good, especially the cluster technology can make DB2 's scalable performance to achieve the ultimate. Look at this year's performance to know the advantages of DB2, of course it's a little more expensive than the others, but it's acceptable, at least far below Oracle's price.
Sybase is dying, and few new systems are going to take it anymore anyway, my current company has given it up.
MySQL good stuff, highly recommended, but it is really different, such as no stored procedures, if not consider the cluster, in fact, his efficiency is much higher than the Oracle
SQL Server Microsoft things, use it to feel good, but because can not use on UNIX, so the enterprise, Telecoms, the government is not very willing to use. If it is not to do ERP best not to use this thing, otherwise the product may not buy out |
