Shulou(Shulou.com)05/31 Report--

Editor to share with you what the commonly used relational database is, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article. Let's learn about it together.

Relational database is a database based on relational model, which deals with the data in the database with the help of mathematical concepts and methods such as set algebra. All kinds of entities in the real world and the relationships between them are represented by relational models. The standard data query language SQL is a language based on relational database, which performs the retrieval and operation of data in relational database.

The relational model consists of three parts: relational data structure, relational operation set and relational integrity constraints.

To put it simply, a relational database is a database composed of multiple two-dimensional row and row tables that can be connected to each other. At present, the mainstream relational databases are Oracle, DB2, Microsoft SQL Server, Microsoft Access, MySQL and so on.

1 、 Oracle

Oracle is the first open commercial relational database management system in the world, which was launched in 1983. It adopts standard SQL structured query language, supports multiple data types, provides data support for object-oriented storage, has the fourth generation language development tools, and supports many platforms such as Unix, Windows NT, OS/2, Novell and so on. In addition, it also has a good parallel processing function. Oracle products are mainly composed of Oracle server products, Oracle development tools, Oracle application software, and database products based on microcomputers. Mainly meet the needs of banking, finance, insurance and other enterprises and undertakings to develop large-scale databases.

2 、 DB2

DB2 is a set of relational database management system developed by IBM Company in the United States. Its main operating environment is UNIX (including IBM's own AIX), Linux, IBM I (formerly known as OS/400), z/OS, and Windows server version.

DB2 is mainly used in large-scale application systems, has good scalability, can support from mainframe to single-user environment, and can be applied to all common server operating system 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.

DB2 adopts data grading technology, which can easily download mainframe data to LAN database server, enable client / server users and LAN-based applications to access mainframe data, and make database localization and remote connection transparent.

DB2 is known for having a very complete query optimizer whose external joins improve query performance and support multitasking parallel queries. DB2 has a good network support ability, each subsystem can connect more than one hundred thousand distributed users and activate thousands of active threads at the same time, which is especially suitable for large-scale distributed application systems.

3 、 Microsoft SQL Server

SQL Server is a relational database management system developed by Microsoft Company. It has the advantages of easy to use, good scalability and high integration of related software. it can be used across a variety of platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2012.

Microsoft SQL Server is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management. The Microsoft SQL Server database engine provides more secure and reliable storage for relational and structured data, allowing you to build and manage highly available and high-performance data applications for your business.

4 、 Microsoft Access

Access is a relational database management system released by Microsoft. It combines the characteristics of MicrosoftJet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.

Access is a database management system in which Microsoft combines the graphical user interface of the database engine with software development tools. It is a member of Microsoft OFFICE and is sold separately in office versions that include professional and later versions. On September 25th, 2018, the latest Microsoft Office Access 2019 was released in Microsoft Office 2019.

MS ACCESS stores data in its own format in the Access Jet-based database engine. It can also import or link data directly (which is stored in other applications and databases).

5 、 MySQL

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

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

The above is all the contents of the article "what is a commonly used relational database?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.