Summary of advantages and disadvantages of SQL Server, Mysql, and Oracle databases

Source: Internet
Author: User

I. sqlserver
Advantages:
Ease of use, scalability suitable for Distributed organizations, data warehouse functions for decision-making support, integration closely related to many other server software, and good cost-effectiveness;
It brings flexibility to data management and analysis, allowing organizations to respond calmly in a rapidly changing environment, thus gaining a competitive advantage. From the perspective of data management and analysis, it is very important to convert raw data into business intelligence and take full advantage of the opportunities brought by Web. As a complete database and data analysis package, SQLServer opens the door to quickly develop a new generation of enterprise-level commercial applications and win core competitive advantages for enterprises. As the record holder of important benchmark test scalability and speed awards, SQLServer is a database product with full Web support and provides scalable markup language (XML) core Support and query capabilities on the Internet and outside the firewall;

Disadvantages:
Openness: SQL Server can only run on windows without any open operating system stability is very important to the database Windows9X series products focus on desktop applications NT server is only suitable for small businesses and windows platform depends on security and scalability is very limited such as unix, which has been tested for a long time, especially handling large databases;
Scalability concurrency: the SQL server parallel implementation and coexistence model are mature and difficult to handle the increasing number of users and Limited scalability of data volumes;
Security: no security certificate is obtained.
Performance: Good Time Performance for multiple users of SQL Server;
Client Support and Application Mode: Client Support and application mode. Only the C/S mode is supported. The SQL Server C/S structure only supports connecting windows users with ADO, DAO, OLEDB, and ODBC;
Usage risk: SQL server completely overwrites the code and has experienced long-term test of the disconnection delay. Many functions require time to prove and are very compatible;
Ii. Oracle
Advantages:
Openness: Oracle can run on all mainstream platforms (including windows). It fully supports all industrial standards and adopts a fully open strategy to enable customers to choose suitable solutions to fully support developers;
Scalability and concurrency: the Oracle Parallel Server expands the zookeeper function by enabling group nodes to share the same cluster work. The high-availability and high-scalability cluster solution windowsNT can meet the needs of users to move the database to the UNIXOracle Parallel Server for various UNIX platform cluster mechanisms. both have a relatively high degree of integration;
Security: gets the highest level of ISO certification.
Performance: World Record of TPC-D and TPC-C under Oracle high-performance open platform;
Client Support and Application Mode: Oracle multi-layer network computing supports connection of network customers using ODBC, JDBC, OCI, and other industrial standards
Application risk: Oracle has long development experience and is fully backward compatible with low risks in a wide range of applications.

Disadvantages:
High hardware requirements;
Expensive;
Management and maintenance are troublesome;
The operation is complicated and requires a high technical level;

Iii. MySql
Advantages:
Small Size, fast speed, low total cost of ownership, open source;
Supports multiple operating systems;
It is an open-source database and provides interfaces that support multi-language connection operations.
MySql's core program adopts full multi-threaded programming. A thread is a lightweight process that can flexibly provide services to users, but not many system resources. MySql implemented with multithreading and C language can easily make full use of the CPU;
MySql has a flexible and secure permission and password system. When the customer connects to the MySql server, all the password transmission between them is encrypted, and MySql supports host authentication;
Supports ODBC for Windows and all ODBC 2.5 functions and many other functions. You can use Access to connect to the MySql server to extend the application;
Supports large databases to easily support databases with tens of millions of records. As an open-source database, you can modify different applications accordingly.
It has a fast and stable thread-based memory allocation system, which can be used continuously without worrying about its stability;
MySQL also provides a high degree of diversity and provides many different 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 an appropriate application on your own. MySQL can be used on Unix, Windows, OS/2, and other platforms, so it can be used on PCs or servers;

Disadvantages:
Hot Backup is not supported;
The biggest drawback of MySQL is its security system, which is mainly complicated and non-standard. In addition, it is changed only when mysqladmin is called to re-read user permissions;
There is no Stored Procedure language, which is the biggest restriction on programmers who are used to enterprise-level databases;
The price of MySQL varies with the platform and installation method. Linux MySQL is free of charge if it is installed by the user or the system administrator instead of a third party. The third solution requires a license fee. Installation of Unix or Linux is free of charge, and third-party installation of Unix or Linux is charged;

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.