Advantages and disadvantages of MySQL and Oracle

MySQL:
Advantages: 1. Supports 50 million Record Data Warehouses
2. Suitable for all platforms
3. It is an open-source software with fast version updates
4. excellent performance. For pure performance, MySQL is excellent because it contains a default desktop format MyISAM. The MyISAM database is very compatible with the disk without occupying too much CPU and memory. MySQL can run on windows without conflict. It is better to run on Unix or Unix-like systems. You can also use a 64-bit processor to obtain additional performance. Because MySQL uses 64-bit integers in many internal departments.
5. Low Price
Disadvantages: Some storage program functions are lacking. For example, the MyISAM engine supports the exchange function.

MSSQLServer:
Advantages: 1. Real Client/Server Architecture
2. graphical user interface, making system management and database management more intuitive and simple
3. A wide range of programming interface tools provide users with more options for programming.
4. It is fully integrated with WINNT and uses many nt functions, such as sending and receiving messages and managing logon security. SQL server can also be well integrated with Microsoft BackOffice.
5. good scalability and cross-platform use.
6. provides the data warehouse function, which is available only in Oracle and other expensive DBMS.

ORACLE:
Advantages: 1. Oracle is more stable than SQL Server.
2.oracle's data import tool sqlload.exe is more powerful than SQL Server's BCP. Oracle can import text file data as required.
3. Oracle has a better security mechanism than SQL Server.
4. SQL Server is easier to use than oracle in terms of ease of use and friendliness.
5. Oracle will be more stable in processing big data.
6. SQL Server is more powerful in data export.
7. The processing speed is faster than that of Oracle, which is related to the two Protocols.
Disadvantage: Expensive

 

MySQL features powerful functions, simple use, convenient management, fast operation, high reliability, and security and confidentiality.

ORACLE: large, powerful, supports a wide range of products, supports many platforms, and supports the largest data volume, suitable for large and super large applications
DB2: it is large, has good functions, supports many platforms, and supports a large amount of data. It can be used as an alternative to Oracle.
Sqlserver: only the Microsoft platform is supported. The data volume is inferior to the two, and the availability is the best, but the performance is inferior to the two. It is suitable for medium-sized, small-sized enterprises and commercial applications.

1. SQL Server is used for small and medium databases, and Oracle is used for large databases.

2. SQL server can only run in windows, and Oracle is cross-platform.

3. SQL Server is very civilian, lightweight, Oracle is very noble, safe and stable.

1. It mainly deals with the volume of data: Small SQL data volumes are fast and convenient. Oracle is slow, but the massive data processing is not oracle.
2. ease of operation: Easy and easy to use SQL operations. Oracle is difficult to use.
3. Security: SQL security is poor (the biggest drawback ). Oracle is safe.
4. Portability: SQL can only run on Windows and NT systems. Oracle can theoretically run on any system.

 

MySQL
Advantages
MySQL is a fast, multi-threaded, multi-user SQL database server. It is almost free of charge. It supports regular SQL query languages and multiple data types, and supports various detailed queries of data.
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 can run in different operating systems. In short, MySQL supports Windows 95/98/NT/2000, UNIX, Linux, Sun OS, and other operating system platforms. This means that applications implemented in one operating system can be easily transplanted to other operating systems.
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.
MySQL supports ODBC for Windows. MySQL supports all ODBC 2.5 functions and many other functions, so that access can be used to connect to the MySQL server, which greatly extends MySQL applications.
MySQL supports large databases. Although it is sufficient for a Web page written in PHP to store more than a hundred records, MySQL can easily support databases with over 10 million records. As an open-source database, MySQL can modify different applications accordingly.
MySQL has a fast and stable thread-based memory allocation system, which can be used continuously without worrying about its stability. In fact, MySQL is stable enough to deal with a very large scale database.
Powerful query functions. MySQL supports all the operators and functions of the select and where statements to be queried, and can mix tables from different databases in the same query to make the query fast and convenient.
PHP provides strong support for MySQL. php provides a complete set of MySQL functions to provide comprehensive support for MySQL.

Disadvantages
Difficult to learn;
MySQL does not fully support unfamiliar keywords;
MySQL also lacks some storage program functions;
Use the default IP port, but sometimes these IP addresses are broken into by some hackers;
Using MyISAM configuration, If you accidentally damage the database, the results may cause all data loss;
No transactions, no subqueries, and no views;

MSSQL

Advantages
Easy to use
Most of the daily data applications of small and medium-sized enterprises are built on the Windows platform. Because SQL Server has the same style as windows, it has a character interface and a graphical interface, and has many "Wizard" help, so it is easy to install and learn, documents and training on SQL Server are available everywhere. Currently, there are not a few engineers with mcba certification in China.
From another perspective, learning SQL Server is to master other platforms and large data, such as Oracle, Sybase,
DB/2. These large databases have high requirements on equipment, platforms, and personnel knowledge. But with the foundation of SQL Server, it is much easier to learn and use them.
Good compatibility
Because the Windows operating system occupies the dominant position today, selecting SQL server will certainly gain some advantages in compatibility. In addition to scalability and reliability, SQL Server 2000 also provides the ability to quickly develop new internet systems. In particular, it can directly store XML data and output search results in XML format, which facilitates the construction of interoperability between heterogeneous systems, it laid the foundation for Internet-oriented enterprise applications and services. These features play an important role in the. NET strategy.
2000 advantages over 7.0
Microsoft SQL Server 2000 extends the performance, reliability, quality, and ease of use based on SQL Server 7.0. SQL Server 2000 contains many new features that make it an excellent database platform for e-commerce, data warehousing, and online commerce solutions. Its enhanced features include support for a wide range of Extended Markup Language (XML), comprehensive analysis services, and convenient database management.
E-commerce
When Microsoft SQL Server 2000 relational database engine is used, XML data can be stored in a relational table, and query can return relevant results in XML format. In addition, the XML support simplifies backend system integration and implements seamless data transmission across firewalls. You can also use Hypertext Transfer Protocol (Hypertext Transfer Protocol, HTTP) to access SQL Server 2000, to achieve secure web connections for SQL Server 2000 databases and Online Analytical Processing (OLAP) multi-dimensional data sets without additional programming.
Data Warehouse
The obvious improvement of Microsoft SQL Server 2000 is the addition of the OLAP (Online Analytical Processing) function, which allows many small and medium-sized enterprise users to use some features of the data warehouse for analysis. OLAP can use multidimensional storage technology to perform quick and advanced analysis on large and complex datasets. The data mining function can reveal the tendency and trend hidden in a large amount of data. It allows organizations or organizations to obtain the maximum value from data. By effectively analyzing existing data, this function can predict future trends.
Enhanced online commerce
Microsoft SQL Server 2000 simplifies management and optimization, and enhances the reliability and scalability required for rapid and successful deployment of online business applications. The features used to improve reliability include log transmission, online backup, and Failover clusters. Improvements in scalability include support for up to 32 CPUs and 64 gb ram. Through Automatic Optimization and improved management features such as automatic management of data file sizes, wizard-based database copying, automatic memory management, and simplified failover cluster installation and management, online Business applications can be quickly deployed and managed.
Conducive to building "agile business"
The so-called "agile business" means to break the internal and external business boundaries and quickly respond to the rapidly changing environment .. Microsoft has established strategic relationships with key partners and created solutions that can be integrated with the products of many suppliers. Therefore, enterprise users do not need to make a solution, or not all. In the process of deploying the solution, enterprise users do not have to remove the original device from the ground up. Agile business allows enterprise users to make full use of their existing systems and determine the required hardware and software solutions and who can provide them with ease and ease of use.

Disadvantages
It can only run on windows without any openness. The stability of the operating system is very important to the database. The Windows9x series products focus on desktop applications, and the NT Server is only suitable for small and medium enterprises. In addition, the reliability, security, and scalability of the Windows platform are very limited. It is not as tested as UNIX, especially when dealing with key services with large data volumes;
The parallel implementation and coexistence model are not mature. It is difficult to process the increasing number of users and data volumes. Limited scalability;
In terms of security, no security certificate is obtained;
Client Support and application mode. It is a C/S structure and only supports windows customers. You can use ADO, Dao, oledb,
ODBC connection;
Not free;
Data cannot be easily recovered;

Oracle
Advantages
Can run on all major platforms (including windows ). Fully supports all industrial standards. Adopt a fully open policy. Customers can select the most suitable solution. Provide full support to developers.
The Parallel Server expands the function of the DRDs instance by allowing a group of nodes to share the work of the same cluster and provides a cluster solution with high availability and scalability.
If WindowsNT cannot meet your needs, you can move the database to Unix.
In terms of security, the performance is the highest.
Client Support and application mode, multi-layer network computing, supporting a variety of industrial standards, you can use ODBC, JDBC, OCI and other network customer connection requirements, you can build a database according to actual system requirements.
Standard structured SQL query language is used.
It has rich development tools covering all stages of the development cycle.
Supports large databases. The data type supports numbers, characters, and binary data up to 2 GB, providing data support for database object-oriented storage.
Development tools with the fourth generation of languages (SQL * forms, SQL * reports, SQL * menu, etc ).
It has a character interface and graphical interface, which is easy to develop.
Use SQL * DBA to control user permissions, provide data protection, monitor the running status of the database, and adjust the size of the data buffer.
Distribution Optimization query function.
Data Transparency and network transparency, supporting heterogeneous networks and heterogeneous database systems. Parallel Processing uses the Dynamic Data Partitioning technology.
Supports Client/Server architectures and hybrid architectures (centralized, distributed, and Client/Server ).
Two-phase submission and multi-clue query are implemented.
Data security protection measures: no locks are read, and the distributed read/write conflicts are completely eliminated through snapshot snap. Automatically detects deadlocks and conflicts and resolves them.
The data security level is C2 (highest level ).
The internal model of the Database supports multi-byte code and multi-language text encoding.
Management Information System and Financial System Application System for manufacturing systems.
Workgroup/2000 has oracle7workgroup server and power objects (graphical development environment, supporting OS/2, UNIX, Windows/NT platforms.
Sales share in China accounts for more than 50%.
　　
Disadvantages
Management and maintenance are troublesome;
It is very troublesome to reply after the database crashes, because he puts a lot of things in the memory;
The database connection is slower. It is best to use the connection pool;
The vchar2 field is too short to use large objects;
The Administrator's work is annoying and his/her experience is very important;
High hardware requirements;