Oracle and SQL Server, MySql introduction, advantages and disadvantages comparison

Oracle’s brief introduction:

define

Oracle Database, also known as Oracle RDBMS, or Oracle for short. Oracle relational database management system is a leading product in the database field.

advantages

• Openness: Oracle can run on all major platforms, fully support all industry standards adopt a fully open strategy, enabling customers to choose the right solution to fully support developers.
• Scalability, parallelism :Oracle Parallel Servers extend Windownt capabilities by enabling group nodes to share cluster work, providing high availability and high scalability cluster solutions, WindowsNT can meet the needs of users to move the database to UNIX oracle parallel server for various UNIX platform cluster mechanism has a high degree of integration.
• Safety: obtain the highest level of ISO certification. *
• Oracle high performance: Holds the tPC-D and TPC-C world records under open platform.
• Client support and application mode: Oracle multi-level network computing supports a variety of industry standards using ODBC, JDBC, OCI and other network client connections.
• Risk of use :Oracle’s long development experience is fully backward compatible with a low risk of widespread use.

disadvantages

• Hardware: High requirements for hardware (take Orcle12C as an example)

• Management: Management is more complex,
• Price: The price is relatively higher than the price.
• Operation: the operation is complex and requires technology. It provides both GUI and command line. The operation is the same under windowsNT and Unix

SQL Serve

Introduction to the

SQL Server is a relational database management system launched by Microsoft. In October 2008, THE SIMPLIFIED Chinese version of SQL Server 2008 was officially launched in China. SQL Server 2008 can directly store the data of structured, semi-structured and unstructured documents into a database. Data can be queried, searched, synchronized, reported, and analyzed. Data can be stored on a variety of devices, from the largest servers in data centers to desktop computers and mobile devices, and it can control the data regardless of where it is stored.

In addition, SQL Server 2008 allows the use of data in custom applications developed using Microsoft.NET and Visual Studio, Use data in service-oriented architecture (SOA) and business processes conducted through Microsoft BizTalk Server. Information workers have direct access to the data through tools they use on a daily basis.

In addition to the enterprise edition, standard edition, workgroup edition, 180-day trial evaluation edition and free Learning edition are available for small to medium sized applications.

Advantages of SQL Serve

• Ease of use
• Scalability: Suitable for distributed organizations
• Integration: Closely associated with many other server software
• ** Decision facilitation :** Data warehouse functionality for decision support
• ** Cost performance :** Good cost performance
• Flexibility: Allows organizations to respond in a rapidly changing environment to gain a competitive advantage. Turning raw data into business intelligence and profitability from a data management and analytics perspective

Essentially a disadvantage

• Openness: SQL Server runs only on Windows without any hint of an open operating system. System stability is very important for databases. Windows 9X products have a heavy emphasis on desktop applications, NT Server is only suitable for small businesses and the Windows platform is very limited in terms of security and scalability as well as unix-proven especially with large databases;
• Scalability parallelism: SQL Server parallel implementation and coexistence model and mature difficult to deal with the increasing number of users and limited data volume scalability;
• Security: Did not obtain any security certificate.
• Performance: The PERFORMANCE is best when the SQL Server has multiple users.
• Client support and application mode: Client support and application mode. Only support C/S mode, SQL Server C/S structure only support Windows customers with ADO, DAO, OLEDB, ODBC connection;
• Risk of use: SQL Server completely rewritten code has experienced long testing delays and many features take time to prove and are quite compatible;

MySQL

Introduction of MySQL

A relational database management system developed by MySQL AB, a Swedish company, is currently a product of Oracle. MySQL is one of the most popular Relational Database Management systems. In WEB applications, MySQL is the best RDBMS (Relational Database Management System) application software.

MySQL advantages

• Ease of use :MySQL is a high-performance and relatively simple database system, with less complexity than setting up and managing some larger systems.
• Price :MySQL is free for most individual users.
• Small: The database distribution is a mere 21M and the installation is a mere 51M.
• Performance: Many clients can connect to the server simultaneously. There is no limit to the number of users of the MySQL database, and multiple clients can use the same database simultaneously. You can interactively access MySQL with several interfaces for entering queries and viewing the results. These interfaces are: command-line client programs, Web browsers, or X Window System client programs. In addition, there are interfaces written in various languages such as C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl. Therefore, you can choose to use a preprogrammed client program or write your own client application.
• Connectivity and security: MySQL is fully networked and its database can be accessed from anywhere on the Internet, so it can be shared with anyone, anywhere. And MySQL also has access control over who can’t see your data.
• Portability :MySQL runs on all versions of UNIX and other non-UNIX systems, such as Windows and OS/2. MySQL runs on everything from home PCS to advanced servers.
• Open distribution: MySQL is easy to get; Just use a Web browser. If you can’t understand how something works, or if you’re curious about an algorithm, you can take its source code and analyze it. If you don’t like something, you can change it.
• Speed: MySQL runs fast. The developers claim MySQL is probably the fastest database available today.

MySQL shortcomings

• Hot backup not supported: The biggest drawback of MySQL is its security system, which is mainly complex rather than standard, and only changes when the user permissions are reread by calling mysqladmin; The lack of a Stored Procedure language is a major limitation for programmers used to enterprise-level databases;
• The price of MySQL varies depending on the platform and installation method :Linux MySQL is free if installed by the user or system administrator rather than a third party, and third solutions must pay a license fee. Unix or Linux installation free, Unix or Linux third-party installation charge;