What is the commonly used database management system

This article mainly introduces what the commonly used database management system is, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Common database systems include IBM's DB2, Oracle's Oracle, Microsoft's SQL and Access, Sybase's Sybase, MySQL AB's MySQL and so on. Different database systems have different characteristics, and they also have relatively independent application fields and user support.

DB2:

A relational database system developed by IBM Company. DB2 is mainly used in large-scale application systems, with good scalability, can support from mainframe to single-user environment, applied to OS/2.Windows and other platforms.

DB2 provides high-level data utilization, integrity, security, recoverability, and the ability to execute small-to large-scale applications, with platform-independent basic functions and SQL commands.

Oracle:

Oracle is a database product developed at the same time as DB2, and it is also the second database product that adopts SQL. Oracle absorbs many advantages from DB2 and other products, avoids the bureaucracy and excessive technicalization of IBM, and boldly introduces many new theories and features, so Oracle is very good in terms of function, performance and usability.

Oracle has launched versions of different function combinations for users of different sizes and application needs, and the supported operating systems can also be said to be fully covered, including UNIX, Linux and Windows, so Oracle database is not only suitable for large companies, but also can meet the choices of enterprise users of different sizes.

SQL and Access:

The operating system environment of SQL and Access is Microsoft's Windows. At present, the server architecture that supports Windows operating system is very common, it can be said that all mainstream processor architectures have good support, including IBM's Power processor and Sun's UltraSparc processor. So in this respect, there is no restriction on the database server based on these two major database software.

SQLSever database management system has comprehensive functions and high efficiency, and can be used as a database management system for large and medium-sized enterprises and units. it is introduced by Microsoft and inherits the characteristics of Microsoft products such as friendly interface, easy to learn and easy to use.

Sybase:

Sybase is a kind of relational database system developed by American Sybase Company. It is a typical large database system under client / server environment on UNIX or WindowsNT platform. Sybase provides a set of application programming interfaces, which can be integrated with non-Sybase data sources and servers, allows data to be replicated between multiple databases, and is suitable for creating multi-tier applications.

MySQL:

MySQL is a small relational database management system developed by the Swedish company MySQL AB. At present, MySQL is widely used in small and medium-sized systems, especially in network applications. MySQL does not provide some features that are rarely used in small and medium-sized systems, so MySQL has a very small resource footprint and is easier to install, use, and manage.

MySQL can be used in a windows environment, but the most classic combination is Apache+PHP+Mysql. Nowadays, there are many small websites with this combination, which have very low requirements for server configuration. Of course, due to the limitations of the database itself, MySQL is not suitable for commercial applications with large traffic.

Thank you for reading this article carefully. I hope the editor can share what the commonly used database management system is helpful to everyone. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. detailed solutions are waiting for you to learn!