SQL Server, Mysql, Oracle three kinds of database advantages and Disadvantages Summary _ database other

one, SQL Server
Advantages:
Ease of use, scalability for distributed organizations, data Warehouse functions for decision support, integration with many other server software, good price/performance, etc.
Provides flexibility for data management and analysis, allowing units to respond in a rapidly changing environment to gain a competitive advantage. From a data management and analysis perspective, translating raw data into business intelligence and taking full advantage of the opportunities offered by the Web is important. As a complete database and data analysis package, SQL Server opens the door to the success of developing a new generation of enterprise-class business applications and winning the core competitive advantage for the enterprise. As an important benchmark for testing scalability and speed Awards, SQL Server is a fully web-supported database product that provides core support for Extensible Markup Language (XML) and the ability to query on the Internet and outside the firewall;

Disadvantages:
Openness: SQL Server can only run on Windows without the slightest open OS 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 relies very limited on sexual security and scalability like Unix-like time-tested processing of large databases in particular;
Scalability parallelism: SQL Server parallel implementation and coexistence model and mature difficult to handle the increasing number of users and the limited scalability of data volumes;
Security: No security certificate has been obtained.
Performance: SQL Server multiuser performance is good;
Client Support and Application mode: Client support and Application mode. Only C/s mode is supported, SQL Server C/s structure only supports Windows customers with ADO, DAO, OLE DB, ODBC connection;
Use risk: SQL Server completely rewrites code experience long test break delay many features require time to prove and are very compatible;
Second, Oracle
Advantages:
Openness: Oracle can run on all major platforms (including Windows) fully support all industry standards using a fully open strategy to enable customers to choose the right solution for the developer's full support;
scalability, parallelism: Oracle The parallel server expands the WINDOWNT capability by making the group node share the same cluster work to provide the high usability and the highly scalable cluster solution WindowsNT can meet the need of the user to move the database unixoracle the parallel server to the various UNIX platform cluster mechanism has the very high integration;
Security: Obtain the highest certification level ISO standard certification.
Performance: Oracle High performance maintain open platform under tpc-d and Tpc-c World records;
Client Support and Application mode: Oracle Multi-level network Computing supports a wide range of industrial standards with ODBC, JDBC, OCI and other network customer connections
Use risk: Oracle long-time development experience completely backward-compatible with low risk of widespread application

Disadvantages:
High requirements for hardware;
The price is more expensive;
Some problems in management and maintenance;
The operation is more complicated and requires higher technical content;

Third, MySql
Benefits:
Small size, fast, low total cost of ownership, open source;
supports multiple operating systems;
is an open source database that provides interfaces to support multiple language connection operations
MySQL's core program uses full multithreaded programming. A thread is a lightweight process that provides the flexibility to provide services to users without excessive system resources. Using multithreading and C language MySQL can easily make full use of the CPU;
MySQL has a very flexible and secure permissions and password system. When the client connects to the MySQL server, all password transfers between them are encrypted, and MySQL supports host authentication;
supports ODBC for Windows, supports all ODBC 2.5 functions, and many other functions, and can connect to the MySQL server with access. Enables applications to be extended;
supports large databases that can easily support databases on thousands records. As an open source database, it can be modified for different applications. The
has a very fast and stable thread-based memory allocation system that can be used continuously without worrying about its stability;
MySQL provides a high degree of diversity and can provide a wide variety of user interfaces, including command-line client operations, Web browsers, and a wide variety of program language interfaces, such as c+,perl,java,php, and Python. You can use pre-packaged clients, 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 PCs or servers;

Disadvantage:
does not support hot backup;
MySQL's biggest drawback is its security system, which is mostly complex rather than standard, In addition to the call to Mysqladmin to reread the user rights only to change;
There is no stored procedure (Stored Procedure) language, which is the maximum limit for programmers accustomed to enterprise-level databases;
The price of MySQL varies with the platform and installation. Linux MySQL is free if it is installed by the user or by the system administrator rather than by a third party, and the third scheme must pay the license fee. UNIX or Linux installs its own free, UNIX or Linux third-party installation charges;