oracle和ms acceess之间的区别 [英] difference between oracle and ms acceess

问题描述

1)Oracle和MS Access有什么区别?
2)Oracle和MS Access的缺点是什么?
3)Oracle和MS Access有哪些功能和优点?

1)What is difference between Oracle and MS Access?
2) What are disadvantages in Oracle and MS Access?
3) What are feratures&advantages in Oracle and MS Access?

推荐答案

Oracle是一个严肃的企业级数据库.它是为跨多个位置的多个设备上的多个用户设计的.
Access是独立的内存桌面数据库.它是为单用户设计的，可以在单台计算机上进行单连接.

这两个数据库都使用SQL并提供可视化工具来使用它们.从而结束了相似之处.

但是，请使用Google"Oracle vs Access"了解更多信息.

Oracle is a serious enterprise level database. It is designed for multiple users across multiple devices in multiple locations.
Access is a stand-alone in memory desktop database. It is designed for a single user with a single connection on a single machine.

Both databases use SQL and provide visual tools to use them. Thus ends the similarities.

But do google "Oracle vs Access" for more information.

Oracle 是可伸缩的-它可用于单用户或大规模多用户(1000个)用户)访问.
在Oracle Enterprise数据库中，具有100亿行的表并不罕见.
Oracle是多平台的-Linux，Windows，OS X，Solaris ...

访问并不是特别可扩展的-尽管您可以有多个用户，但不支持回滚.
最好不要在Access的表中插入几百万行.
Access不提供Oracle提供的提交，事务记录和回滚功能.
Access是快速开发和部署中很好的原型工具
Access是单一平台-Windows.

Oracle is scaleable - it can be used for single user or massively multiuser(1000''s of users) access.
Tables with 100''s of millions of rows are not rare in an Oracle Enterprise database.
Oracle is multiplatform - Linux, Windows, OS X, Solaris...

Access is not particularly scaleable - while you can have multiple users, rollback is not supported.
It''s best not to insert more than a few million rows into a table in Access.
Access does not provide commit, transactions logging and rollback features that Oracle does.
Access is a good prototyping tool in the development and deployment are fast
Access is single platform - Windows.

1)Oracle是数据库服务器，Access是数据库引擎.一个是独立的，另一个是进行中的.

2)Oracle很难学习和保持运行.访问无法扩展大数据.

3)Oracle可以轻松处理大数据.访问很容易用于个人使用.

编辑
严重的是，您没想到像这样的质量检查中会完整描述这些产品的优点和缺点.

1) Oracle is a database server, Access is a database engine. One is standalone, the other is in process.

2) Oracle is hard to learn and keep running. Access does not scale with large data.

3) Oracle can handle large data with ease. Access is simple to use for personal use.

EDIT
Seriously you did not expect a full description of all the advantages and disadvantages of these products in a QA like this.

这篇关于oracle和ms acceess之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！