On the Differences of Mysql SqlServer and Oracle Databases

  • 2021-11-24 03:11:51
  • OfStack

1. MySQL


Small size, fast speed, low total cost of ownership and open source; Support multiple operating systems; Is an open source database, which provides interfaces to support multi-language connection operations;

The core program of MySQL adopts complete multithreaded programming. Threads are lightweight processes that can flexibly provide services to users without too much system resources. mysql implemented with multithreading and C language can easily make full use of CPU;

MySql has a very flexible and secure permission and password system. When a client connects to an MySql server, all password transfers between them are encrypted, and MySql supports host authentication;

Support ODBC for Windows, support all ODBC 2.5 functions and many other functions, and connect MySql server with Access, so that the application can be extended;

Support large databases, which can easily support databases with tens of millions of records. As an open source database, it can be modified for different applications.

Have a very fast and stable thread-based memory allocation system, which can be used continuously without worrying about its stability;

MySQL also offers a high degree of diversity, providing a wide variety of user interfaces, including command-line client operations, web browsers, and a wide variety of programming language interfaces such as C +, Perl, Java, PHP, and Python. You can use a pre-packaged client, or simply write a suitable application yourself. MySQL can be used on platforms such as Unix, Windows, and OS/2, so it can be used on personal computers or servers.


Hot backup is not supported; The biggest disadvantage of MySQL is that its security system is mainly complex rather than standard, and it only changes when calling mysqladmin to reread user rights; There is no stored procedure (Stored Procedure) language, which is the biggest limitation for programmers accustomed to enterprise databases; The price of MySQL varies with the platform and installation method. MySQL of Linux is free if installed by the user or system administrator instead of a third party, and the third scheme must pay a license fee. Self-installation of Unix or linux is free, and third-party installation of Unix or Linux is charged.

2. SqlServer


Ease of use, scalability suitable for distributed organizations, data warehouse function for decision support, integration closely related to many other server software, good cost performance, etc.; It brings flexibility to data management and analysis, and allows organizations to respond calmly in a rapidly changing environment, thus gaining competitive advantage. From a data management and analysis perspective, it is important to translate raw data into business intelligence and take full advantage of the opportunities presented by Web. As a complete database and data analysis package, SQLServer opens the door to victory for the rapid development of new generation enterprise-level business applications and the core competitive advantage for enterprises. As the record holder of important benchmark scalability and speed awards, SQLServer is a database product with full Web support, providing core support for Extensible Markup Language (XML) and the ability to query on Internet and outside the firewall;


Openness: SQL Server can only run on windows without any openness. Operating system stability is important to database 10 points. Windows9X series products focus on desktop applications. NT server is only suitable for small enterprises. And windows platform is very limited in security and scalability. Like unix, it has been tested and especially handles large databases. Scalability Parallelism: The SQL server parallel implementation and coexistence model are mature and difficult to handle, increasing number of users and limited data volume scalability. Security: No security certificate has been obtained. Performance: SQL Server has good performance for multi-users. Client support and application mode: Client support and application mode. Only C/S mode is supported, and SQL Server C/S structure only supports windows customers to connect with ADO, DAO, OLEDB and ODBC. Use risk: SQL server completely rewrites the code to undergo the long test break latency many features take time to prove and 10 points compatible.

3. Oracle


Openness: Oracle can run on all mainstream platforms (including windows), fully support all industry standards, adopt a completely open strategy, enable customers to choose suitable solutions, and fully support developers. Scalability, parallelism: oracle parallel server expands windownt capability by making group nodes share and work in the same cluster. windowsNT can meet the needs of users moving databases. UNIXOracle parallel server is highly integrated with various UNIX platform clustering mechanisms. Security: Obtain the highest certification level of ISO standard certification. Performance: Oracle has high performance and keeps the world records of TPC-D and TPC-C under open platform. Client support and application mode: Oracle multi-level network computing supports network customer connection with ODBC, JDBC, OCI and other industry standards. Use risk: Oracle long development experience fully backwards compatible wide application risk is low.


The requirements for hardware are very high; The price is relatively expensive; Management and maintenance trouble 1; The operation is complicated and requires high technical content.

Related articles: