Shulou(Shulou.com)06/01 Report--

What are the advantages and disadvantages of Oracle and MySQL? I believe there are many people who don't know much about Oracle and MySQL. In order to let everyone know more about Oracle and MySQL, I summarized the following contents for everyone and looked down together.

Advantages of Oracle

Advantages:

Openness: oracle can run on all mainstream platforms (including windows), fully support all industry standards, adopt a fully open strategy, enable customers to choose suitable solutions, and fully support developers;

Scalability, parallelism: Oracle Parallel Server extends Windows T capabilities by enabling group nodes to share cluster work to provide high availability and scalability cluster solutions Windows NT can meet the needs of users to move databases UNIX Oracle Parallel Server has a high degree of integration with various UNIX platform clustering mechanisms;

Safety: ISO certification at the highest certification level.

Performance: Oracle maintains high performance TPC-D and TPC-C world records on open platforms;

Client support and application mode: Oracle multi-level network computing supports a variety of industrial standards with ODBC, JDBC, OCI and other network client connections

Use risk: Oracle long development experience fully backward compatible with widespread use of low risk

Disadvantages:

High requirements for hardware;

More expensive;

Management maintenance trouble some;

The operation is relatively complex and requires high technical content;

Disadvantages of MySQL

Advantages:

Small size, fast speed, low total cost of ownership, open source;

Support multiple operating systems;

Is an open source database, providing interfaces to support multi-language connection operations

Mysql's core program uses fully multithreaded programming. Threads are lightweight processes that provide flexibility to provide services to users without excessive system resources. MySql, which is implemented by multithreading and C language, can easily make full use of CPU;

MySql has a very flexible and secure permissions and password system. When clients connect to MySql servers, 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, can use Access to connect to MySql server, so that the application is 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 that can be used continuously without worrying about its stability;

MySQL also provides a high degree of versatility, providing 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 prepackaged client, or you can write a suitable application yourself. MySQL is available on Unix, Windows, and OS/2 platforms, so it can be used on personal computers or servers.

Disadvantages:

Hot backups are not supported;

MySQL's biggest weakness is its security system, which is mostly complex rather than standard, and changes only when mysqladmin is called to reread user permissions;

There is no stored procedure language, which is the biggest limitation for programmers accustomed to enterprise databases;

MySQL prices vary by platform and installation. MySQL for Linux is free if installed by the user himself or by a system administrator rather than by a third party, and a license fee must be paid for the third option. Unix or linux self-installation free, Unix or Linux third-party installation fee;

What are the advantages and disadvantages of oracle and mysql to share here, I hope the above content can have a certain reference value for everyone, you can learn to apply. If you like this post, share it with more people.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.