Database types and pros and cons

1.MySQL

MySQL is the most popular open source SQL database management system, developed, distributed, and supported by MySQL AB. MySQL AB is a MySQL developer-based business company, a second-generation open source company that uses a successful business model to combine open source values and methodologies. MySQL is a registered trademark of MySQL AB.

MySQL is a fast, multi-threaded, multi-user, and robust SQL database server. MySQL server supports mission-critical, heavy-duty production system use, or it can be embedded in a large configuration (mass-deployed) software.

Compared to other database management systems, MySQL has the following advantages:

(1) MySQL is a relational database management system.

(2) MySQL is open source.

(3) MySQL server is a fast, reliable and easy-to-use database server.

(4) The MySQL server works in a client/server or embedded system.

(5) A large number of MySQL software can be used.

2.SQL Server

SQL Server, a database management system developed by Microsoft, is the most popular database for storing data on the web, and it has been widely used in the fields of e-commerce, banking, insurance, electricity and other related databases.

Currently the latest version is SQL Server 2005, which can only be run on Windows, and the system stability of the operating system is important for the database. The parallel implementation and coexistence model is immature, and it is difficult to handle the increasing number of users and data volumes with limited scalability.

SQL Server provides numerous web and e-commerce features, such as rich support for XML and Internet standards, easy and secure access to data through the Web, and powerful, flexible, web-based, and secure application management. Moreover, due to its ease of operation and its friendly operating interface, the majority of users are loved.

3.Oracle

, Oracle products cover dozens of models, including large, medium and small machines, and Oracle database is one of the most widely used relational data systems in the world.

Oracle database products have the following excellent features.

(1) Compatibility

Oracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM Sql/ds, DB2, INGRES, IDMS/R, and more.

(2) Portability

Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different large, medium and small machines, can be in VMs, DOS, UNIX, Windows and other operating systems under the work.

(3) Possible connectivity

Oracle can connect to a variety of communication networks, supporting a variety of protocols (TCP/IP, DECnet, LU6.2, etc.).

(4) High productivity

Oracle products provide a variety of development tools that can greatly facilitate further development of the user.

(5) Openness

Oracle's good compatibility, portability, connectivity, and high productivity make Oracle RDBMS a good open-ended.

4.Sybase

In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched the Sybase database product in 1987. Sybase has three main versions: one is the version running under the UNIX operating system, the other is the version running under Novell NetWare environment, and the third is the version running under Windows NT. For UNIX operating systems, the most widely used are Sybase 10 and syabse for SCO Unix.

Features of the Sybase database:

(1) It is a database based on the client/server architecture.

(2) It is a truly open database.

(3) It is a high-performance database.

5.db2

DB2 is a database management system embedded in IBM's AS/400 system, supported directly by the hardware. It supports the standard SQL language and has a gateway connected to heterogeneous databases. Therefore, it has the advantages of fast speed and good reliability. However, only the hardware platform chooses IBM's as/400 to choose to use the DB2 database management system.

DB2 can be run on all major platforms (including Windows), and is best suited for massive amounts of data.

DB2 is the most widely used enterprise-class, with nearly 85% of the world's 500 largest enterprises using DB2 database servers, and the country accounts for about 5% in 1997.

　

.

Database types and pros and cons