什么是rdbms ... sql不是关系数据库... [英] what is rdbms...sql is relational database are not...

问题描述

什么是 RDBMS ...给我一个关系数据库示例.. sql 是 rdbms 概念

What is RDBMS...give me a example for relational database..is sql is rdbms concept

推荐答案

摘自Wikipedia:

RDBMS的简短定义是:一种DBMS，其中数据存储在表中，并且数据之间的关系也存储在表中.可以用许多不同的方式访问或重组数据，而不必更改表格形式.

表之间具有关系的每个数据库都是关系数据库的一个示例.

SQL是一种用于插入，查询，更新和删除数据以及创建和修改模式的语言，它还可以帮助提供数据访问控制.
因此，SQL可以成为RDBMS中的工具.

也请尝试使用google了解有关这些概念的更多信息.

希望对您有帮助.

From wikipedia :

A short definition of an RDBMS is: a DBMS in which data is stored in tables and the relationships among the data are also stored in tables. The data can be accessed or reassembled in many different ways without having to change the table forms.

Every database that have relation between its tables is an example of Relational Database.

SQL is a language to insert, query, update and delete data, and to create and modify schemas , and also it can help to provide data access control.

So SQL can be a tool in RDBMSs.

Also try to use google to learn more about each of these concepts.

Hope it helps.

要添加到先前的好答案，一些归类为RDBMS(关系数据库管理系统)的产品包括:
-Oracle
-SQL Server
-DB2等.

但是，还有其他类型的DBMS系统.例如，诸如Versant，ZODB等的面向对象的数据库.

另外，还有许多平面文件"系统，例如Access，dBase等.尽管数据存储在关系模型中，但通常不会归类为完整的RDBMS系统.原因是它们缺乏单一的，负责任的数据库服务，并且数据库使用状况分散在使用程序中.

To add to the previous good answer, some products that are categorized as RDBMS (Relational DataBase Management System) include:
- Oracle
- SQL Server
- DB2 etc.

But there are other types of DBMS systems also. For example object-oriented databases such as Versant, ZODB and so on.

Also there are lots of ''flat-file'' systems such as Access, dBase etc. These are typically not categorized as full RDBMS systems although the data is stored in relational model. The reason is that they lack a single, responsible database service and the responsibility of the database well being is scattered among the using programs.

这篇关于什么是rdbms ... sql不是关系数据库...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！