oracle ERP 和 DBMS 之间有什么区别?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/25466482/
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-19 02:29:09  来源:igfitidea点击:

What's the difference between an ERP and DBMS?

databaseoraclesaperp

提问by Hernan Demczuk

Can anyone tell me which one would you use and why? I did a little research and I see that you can integrate both but don't know how or under what circunstances.

谁能告诉我你会用哪一个,为什么?我做了一些研究,我发现你可以整合两者,但不知道如何或在什么情况下。

采纳答案by Jason Baker

Strictly speaking, a DBMS is a fancy way of talking about something like MySQL; it's a program that lets you interact with databases in the abstract. However, when business users talk about a DBMS, they usually mean a tool like MySQL Workbench. Really the only difference is that Workbench provides a pretty user interface, and occasionally add some reporting tools and other graphical utilities.

严格来说,DBMS 是谈论 MySQL 之类的东西的一种奇特方式;它是一个可以让您抽象地与数据库交互的程序。然而,当业务用户谈论 DBMS 时,他们通常指的是像MySQL Workbench这样的工具。真正唯一的区别是 Workbench 提供了一个漂亮的用户界面,偶尔会添加一些报告工具和其他图形实用程序。

An ERP, on the other hand, is essentially a single database with multiple points of entry. You may have a database administrator who would use a tool very much like Workbench (Although that depends on the vendor), but the accountant who enters transactions into the General Ledger is going to have a very different screen, and the VP of Sales, looking at aggregate sales figures, is going to see yet another screen.

另一方面,ERP 本质上是一个具有多个入口点的单一数据库。您可能有一个数据库管理员,他会使用与 Workbench 非常相似的工具(尽管这取决于供应商),但是将交易输入总帐的会计将有一个非常不同的屏幕,而销售副总裁则寻找在总销售额数字中,将看到另一个屏幕。

Which brings me in a roundabout way to another difference between them: target audience. A DBMS is designed to be used by a small subset of technical people like developers, DB Admins, and Data Architects. An ERP is designed to be used by everyone in a business, of varying technical skills and requirements.

这让我以一种迂回的方式了解它们之间的另一个区别:目标受众。DBMS 旨在供一小部分技术人员使用,例如开发人员、数据库管理员和数据架构师。ERP 旨在供企业中具有不同技术技能和要求的每个人使用。

回答by user2196728

This is an interesting question.

这是个有趣的问题。

Will write a short/simple answer (because it could quickly become complicated) :

将写一个简短/简单的答案(因为它可能很快变得复杂):

  • ERP is a global term to design a tool for business management.

  • As most serious tools, it needs a user application and a database. The database is called RDBMS.

  • ERP 是一个全球性的术语,旨在为企业管理设计一种工具。

  • 作为最重要的工具,它需要一个用户应用程序和一个数据库。该数据库称为 RDBMS。

So i would say :

所以我会说:

  • ERP is the complete suite : Apllication + Database.

  • RDMS : just the database, no application.

  • ERP 是完整的套件:应用程序 + 数据库。

  • RDMS:只有数据库,没有应用程序。