database Ms Access 是 DBMS 还是 RDBMS?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/15499145/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 08:54:13  来源:igfitidea点击:

Is Ms Access DBMS Or RDBMS?

ms-accessrdbmsdatabase

提问by Nilesh Rathod

IS Ms Access DBMS or RDBMS? I also do Google to find answer of this question,but in some website or blog says it is DBMS while others are says it is RDBMS.. so what is correct answer? and Please understand why it is DBMS or RDBMS?

Ms Access 是 DBMS 还是 RDBMS?我也用谷歌来找到这个问题的答案,但在一些网站或博客上说它是 DBMS 而其他人说它是 RDBMS ..那么正确答案是什么?并请理解为什么是 DBMS 或 RDBMS?

采纳答案by Matt Donnan

MS Access is a Relational Database Management Systemso therefore RDBMS, however you can use it in a non-relational fashion if you so wish so it can be used as a DBMS.

Relational Database Management System因此RDBMS,MS Access 是一个DBMS.

回答by Analytic Lunatic

Short Answer: Both.

简短的回答:两者都有。

Detail:

详情

Microsoft Access is a DBMS but also something more: a personal database system. That is, a DBMS plusan application generator. While Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query components that are the Microsoft Access application generator.

Microsoft Access 是一个 DBMS,但还有更多的东西:个人数据库系统。也就是说,一个 DBMS加上一个应用程序生成器。虽然 Microsoft Access 包含创建、处理和管理数据库的 DBMS 引擎,但它还包含作为 Microsoft Access 应用程序生成器的窗体、报表和查询组件。

Source:

来源

Page 13

第 13 页

Database Processing: Fundamentals, Design, and Implementation

数据库处理:基础、设计和实现

David M. Kroenke, David J. Auer

大卫·M·克伦克、大卫·J·奥尔

12th Edition

第十二版

ISBN13: 9780132145374

ISBN13:9780132145374

回答by nvogel

Microsoft Access is an application development tool, not a DBMS or an RDBMS.

Microsoft Access 是一种应用程序开发工具,而不是 DBMS 或 RDBMS。

The Access application is bundled with (but distinct from) Jet/ACE, which is a system for sharing data over a filesystem or via ODBC. In principle that can include accessing relational or non-relational databases. Jet/ACE isn't "relational" though. It is based (very loosely) on the SQL model of data rather than the relational model but is more of an ISAM cursor-engine than any SQL DBMS.

Access 应用程序与(但不同于)Jet/ACE 捆绑在一起,Jet/ACE 是一种通过文件系统或通过 ODBC 共享数据的系统。原则上,这可以包括访问关系或非关系数据库。Jet/ACE 不是“关系”。它(非常松散地)基于数据的 SQL 模型而不是关系模型,但它更像是一个 ISAM 游标引擎,而不是任何 SQL DBMS。

回答by Mansha

MicrosoftAcess is a type of mysql and it is a DBMS

MicrosoftAccess 是一种 mysql,它是一个 DBMS