rdms系统

Database systems are an important part of the IT system. Relational Database Management System is a database that mainly stored data in a relational model by creating different relations between different data. Relational Database Management Systems simply called RDMS. RDMS mainly uses the Structured Query Language simply SQL in order to store and query data.

数据库系统是IT系统的重要组成部分。 Relational Database Management System是一个数据库，主要通过在不同数据之间创建不同的关系将数据存储在关系模型中。 关系数据库管理系统简称为RDMS。 RDMS主要仅使用结构化查询语言SQL来存储和查询数据。

关系数据库管理系统(RDMS)的历史记录 (Relational Database Management System (RDMS) History)

Relational Database Management System was created in 1970 at IBM. The relational database term is described in the paper named “A Relational Model of Data for Large Shared Data Banks”. In 1974, IBM began developing System R which is a research project to develop an RDMS. The first commercial RDMS is created by oracle in 1979. Then other commercial RDMS like DB2, SAP Sybase, and Informix are created.

关系数据库管理系统是1970年在IBM创建的。 关系数据库术语在名为“大型共享数据库的数据关系模型”的论文中进行了描述。 1974年，IBM开始开发System R，这是开发RDMS的研究项目。 Oracle在1979年创建了*个商业RDMS。然后创建了其他商业RDMS，例如DB2，SAP Sybase和Informix。

关系数据库管理系统术语 (Relational Database Management System Terms )

With its popular use and long history RDMS has a lot of terms, technologies and methodologies. Below we will list some of the most popular RDMS terms.

RDMS具有广泛的用途和悠久的历史，拥有许多术语，技术和方法论。 下面我们将列出一些*受欢迎的RDMS术语。

Database is a containers for multiple tables. Single RDMS can store multiple databases for different projects and applications.

Database是多个表的容器。 单个RDMS可以存储用于不同项目和应用程序的多个数据库。

Table is the container for the records and data. Table stores different type of values in a single row which is also called as record.

Table是记录和数据的容器。 表将不同类型的值存储在一行中，这也称为记录。

Row or Record is a single entity which contains values and stored inside a table.

Row或Record是包含值并存储在表中的单个实体。

Column is used to store single type of values which is vertical line of a table.

Column用于存储单一类型的值，即表的垂直线。

Primary Key is a key used to created relations between different tables records.

Primary Key是用于在不同表记录之间创建关系的键。

Foreign Key is used to math another table primary key to create relations.

Foreign Key用于对另一个表的主键进行数学运算以创建关系。

LEARN MORE  How To List MySQL / MariaDB Database?
了解更多如何列出MySQL / MariaDB数据库？

Stored Procedure is an executable code that is stored inside the database and can be executed to complete different actions or return data.

Stored Procedure是存储在数据库内部的可执行代码，可以执行以完成不同的操作或返回数据。

Index is a way for quicker and faster data access for a table but creating and increasing index will take more storage for a table.

Index是一种越来越快地访问表的方法，但是创建和增加索引将占用表的更多存储空间。

Query is a command which is generally an SQL which is used to complate an action or return data.

Query是一个命令，通常是一个SQL，用于组合动作或返回数据。

Normalization is the process of organizing the data inside an RDMS for efficient and fast use. Normalization will mainly eliminate redundant data.

Normalization是在RDMS内部组织数据以便高效，快速使用的过程。 规范化将主要消除冗余数据。

Data Integrity is used to ensure the integrity of data inside different tables via explicit rules. Entity Integrity ensures no duplicate rows in a table. Domain Integrity enforces valid entries for a given column restricting type, format, and range of the values. Referential integrity used to prevent the deletion of rows which is used by other tables.

Data Integrity用于通过显式规则确保不同表内数据的完整性。 实体完整性可确保表中没有重复的行。 域完整性对给定的列强制执行有效的条目，以限制值的类型，格式和范围。 引用完整性，用于防止其他表使用的行被删除。

流行关系数据库管理系统(RDMS) (Popular Relational Database Management System’s (RDMS’s))

During its history different commercial RDMS’s are created. Below we will list some of the most popular and important commercial RDMS’s.

在其历史上，创建了不同的商业RDMS。 下面我们将列出一些*受欢迎和*重要的商业RDMS。

MySQL is the most popular open-source RDMS. It is used by big companies like Google, Facebook, Twitter, etc. MySQL mainly used with the PHP programming language.

MySQL是*受欢迎的开源RDMS。 它由Google，Facebook，Twitter等大公司使用。MySQL主要与PHP编程语言一起使用。

MariaDBis a fork of the MySQL and provides most of the features of the MySQL database.

MariaDB是MySQL的分支，并提供MySQL数据库的大多数功能。

MS SQL Server is the RDMS created by Microsoft. It is released as different versions where SQL Server Express is the free version.

MS SQL Server是Microsoft创建的RDMS。 它以不同版本发布，其中SQL Server Express是免费版本。

PostgreSQL is powerful and opensource RDMS. PostgreSQL is generally used alternative for MySQL but PostgreSQL requires more expertise to manage properly.

PostgreSQL是功能强大且开源的RDMS。 PostgreSQL通常是MySQL的替代方法，但是PostgreSQL需要更多的专业知识才能正确管理。

LEARN MORE  How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora
了解更多如何在Linux，Ubuntu，Debian，CentOS，Fedora上安装和配置MongoDB NoSQL数据库

Oracle is the most popular paid RDMS which is used by big enterprises. Oracle provides all enterprise-level features which are partially provided by other RDMS.

Oracle是大型企业使用的*受欢迎的付费RDMS。 Oracle提供了所有企业级功能，而其他RDMS则部分提供了这些功能。