Oracle vs Access

本文介绍了Oracle vs Access的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

在性能，安全性，成本等方面，有没有人有一个很好的URL或信息，而且Oracle和Access相互比较了。在 之前你跳我了知道甲骨文是凯迪拉克与Access the Ford相比 Fairlane。我需要这些信息才能完成学校项目。谢谢。

Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.

推荐答案

" Rosco" < RO *** @ cox>在消息中写道 news：6f ******************************** @ 4ax ... "Rosco" <ro***@cox> wrote in message news:6f********************************@4ax... 在性能，安全性，成本等方面，Oracle和Access之间是否有一个好的URL或信息相互比较你之前跳到我身上我知道甲骨文是凯迪拉克与Access the Ford Fairlane相比。我需要这些信息才能完成学校项目。谢谢。 Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.

要清楚，你应该意识到ms-access不是真正的数据库。 例如，它会很愚蠢比较VB和Oracle。 C ++，VB，VB和ms-access都是开发工具，可以让你创建 应用程序连接到一个数据库系统。 在ms-access的情况下，您可以选择所需的数据库引擎。那个 数据库引擎可以是： JET - 基于默认文件共享的系统 SQL server（a包括sql server的桌面编辑的免费副本 在每个办公室cd上用于ms-access）。 Oracle - （或任何其他odbc数据引擎）。 所以，比较VB和Oracle， 或 比较ms-access而且Oracle根本没有意义！ 您当然可能想要将基于服务器的数据库引擎（如 Oracle）与基于文件共享的引擎进行比较像JET一样*强调*差异 的运作方式。 （即：JET是一个文件共享，Oracle是一个客户端，用于服务器数据库系统）。 但是，JET数据引擎不需要使用 与ms访问。 因此，没有人会要求你比较VB和Oracle。同样的推理 适用于ms-access。 Ms-access只是一个集成开发工具 （IDE）来创建应用程序（这与VB，VB或c ++相同）。在 中，ms-access中的编程语言与VB相同（VB6确切地说是，实际上甚至共享相同的代码库）。 /> 您还注意到Microsoft的sql server（或者这个 的Oracle数据库）不允许您创建表单或开发用户界面。因此，这些 数据库服务器产品不允许您创建表单。因此，您必须选择 用于创建UI的内容。那个用户界面可能是VB，c ++，ms-access或 甚至是基于网络的界面。 所以，ms-access中有很少的东西，如果有的话你可以比较来自 Oracle。您当然可以使用ms-access作为客户端开发工具来支持 Oracle，在这种情况下，用户数量的唯一限制将是Oracle的 限制数据库，而不是ms访问的数据库。 有些公司有1000毫秒访问权限的用户同时在 工作 ....但当然他们正在连接到sql server。再一次，ms-access的限制是你连接的数据库服务器的限制（对于Oracle，MySql，Sybase或微软自己的sql来说是b ）服务器）。 我认为这个问题需要澄清，或者可能需要重新措辞，因为 ms-access不是数据库，也不是数据库数据引擎.... - Albert D. Kallal（访问MVP） 加拿大艾伯塔省埃德蒙顿 pl *************** **@msn http：// www .attcanada / ~kallal.msn

To be clear, you should realize that ms-access is not the actual database. For example, it would be silly to compare VB and Oracle. C++, VB, VB and ms-access are all development tools that let you create applications that CONNECT to a database system. In the case of ms-access, you can choose what database engine you want. That database engine can be: JET - the default file share based system SQL server (a free copy of the desktop editing of sql server is included on every office cd for use with ms-access). Oracle - (or any other odbc data engine). So, to compare VB and Oracle, Or To compare ms-access and Oracle don''t make sense at all! You certainly might want to compare a server based database engine like Oracle to a file share based engine like JET to *highlight* the differences in how they operate. (Ie: JET is a file share, and Oracle is a client to server database system). However, the JET data engine does NOT have to be used with ms-access. So, no one would ask you to compare VB and Oracle. This same reasoning applies to ms-access. Ms-access is simply a integrated development tool (IDE) to create applications with (this is same as VB, VB or c++). In fact, the programming language in ms-access is the same as VB (VB6 to be exact, and in fact even shares the same code base). You also note that Microsoft''s sql server (or the Oracle database for this matter) does NOT let you create forms or develop a User interface. So, these database server products do NOT let you create forms. So, you have to choose what you will use to create the UI. That UI might be VB, c++, ms-access or even web based interface. So, there is little, if anything in ms-access that you can compare to Oracle. You can certainly use ms-access as a client development tool to Oracle, and in this case the only limits in the numbers of users will be the limits of the Oracle database, and NOT that of ms-access. There are some companies that have 1000 ms-access users working at the same time ....but of course they are connecting to sql server. Once again, the limits of ms-access are that of the database server that you connect to (be it Oracle, MySql, Sybase or Microsoft''s own sql server). I think the question needs to be clarified, or perhaps re-worded as ms-access is not a database, nor is it even a data engine.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pl*****************@msn www.attcanada/~kallal.msn

" Albert D. Kallal" < PL ******************* @ msn>在消息中写道 news：0okQc.14481 "Albert D. Kallal" <Pl*******************@msn> wrote in message news:0okQc.14481

M95.1024@pd7tw1no ... M95.1024@pd7tw1no... Ms-access只是一个集成开发工具（IDE）来创建应用程序（这与VB，VB或c ++相同）。 [这就是新手总是试图用它来制作可执行文件的原因！] ms-access不是数据库，甚至也不是数据引擎.... Ms-access is simply a integrated development tool (IDE) to create applications with (this is same as VB, VB or c++). [That''s why the newbies are always trying to make an executable out of it!] ms-access is not a database, nor is it even a data engine....

[等到微软听到这个！]

[Wait til Microsoft hears about that!]