数据库和ERP
我正在尝试掌握一个新的 ERP 应用程序。我有很好的函数知识，有人建议我学习 SQL。我不知道从哪里开始。我有两本书，《SQL for Dummies》和《Database Development for Dummies》，我应该先读哪本书？这个想法是为了更好地理解 ERP 和数据库之间的关系，并理解 ERP 应用程序背景下的数据库概念，
您好，HLGEM 和其他人，我将担任生产支持顾问的角色，并将参与升级项目。
产品支持：我们从客户端站点获取问题，并使用 SQL 查找必要的信息。升级项目：我们将升级到最新版本。我认为我们必须迁移数据并进行一些配置。你能帮我计划一下要学什么吗？我的同事建议我需要了解表、模式、ERD。这是我应该关注的吗？
I am trying to master a new ERP application. I have good functional knowledge and I was advised to learn SQL. I do not know where to start. I have two books, SQL for Dummies and Database Development for Dummies, Which book should I read first? The idea is to get a good understanding of the relationship between ERP and database and to understand the database concepts in the context of an ERP application
Hi HLGEM and others I will be working in the roles of production support consultant and will be participating in an upgrade project.
Prod support: We get issues from the client site and we use SQL to find the necessary information. Upgrade Project: We will be upgrading to the newest version. I think we will have to migrate the data and do some configuration. Can you help me in planning what to learn? My colleagues suggested that I need to understand the tables, schemas, ERDs. Is that what I should be focusing on?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您的 ERP 有 DBA 吗？我将从与他们交谈开始。你需要学习两件事； SQL 和 ERP 的数据结构。
1) SQL - 如果您刚刚开始，请看一下 O'Reilly 的书。除了学习SQL和Headfirst SQL 将是一个好的开始。 Headfirst 是学习新主题的非常实用的方法。
2) 您的 ERP 数据结构。您将需要一个数据字典以及您能找到的任何文档。您需要记住，在您和数据库之间通常存在大量业务逻辑，当您尝试访问数据时，您需要使用 SQL 重新创建这些逻辑。我将从您非常熟悉的领域开始，并围绕该领域构建 SQL 以学习一些约定。请记住，您的 ERP 可能已经建立了数十年，有数百名人员参与其中，因此其中会存在许多奇怪之处和不一致之处。
有时，SQL 是从 ERP 获取数据的最快方法。但是您是否调查过您的 ERP 是否公开了 .Net 或 COM 甚至 Java 的业务对象？如果您希望将数据放入 ERP，或者确保从 ERP 检索的数据正确，通常需要采用这种方法。
Do you have a DBA for your ERP? I would start by talking to them. You will need to learn two things; SQL and your ERP's data structures.
1) SQL - if you are just starting out have a look at O'Reilly's books. I haven't read either but Learning SQL and Headfirst SQL would be a good start. The Headfirst ones are very good practical ways of learning a new topic.
2) Your ERP data structure. You'll need a data dictionary and whatever documentation you can get hold of. You need to remember that between you and the database there is usually a ton of business logic that you'll need to recreate with your SQL when trying to access data. I would start with an area you are very familiar and build your SQL around that to learn some of the conventions. Remember that your ERP has probably been built over decades with 100's of people working on it so there will be many oddities and inconsistencies in there.
Sometimes SQL is the fastest way to get data from your ERP.. but have you investigated whether your ERP exposes it's business objects for .Net or COM or even Java? This is usually the way you'll need to go if you wish to put data into your ERP, or be assured that the data you retrieve from your ERP is correct.
我不知道 Oracle 的等效项，但在 SQL Server 数据库中，我们可以运行 Profiler 来准确查看当应用程序的特定部分运行时发送到数据库的内容。这对于尝试解决您所遇到的某些类型的问题非常有用。我确信 Oracle 有某种等效的方法可以做同样的事情，或者市场上还有其他产品可以做到这一点，但我不知道它们是什么。我只是放弃了为您提供一种需要寻找的工具的想法。
您需要了解 SQL，因为所有 ERPS 都是数据密集型的，如果不了解 SQL，您就无法了解数据库中发生的情况。请记住，Oracle 有自己的 SQL 风格，与其他数据库非常不同。所以在学习中一定要学好PL/SQL。如果 ERP 是为多个数据库后端设计的，则它可能使用 ANSII 标准 SQL，而不是更强大的 PL/SQL。如果你既不懂SQL，又不懂关系数据库设计理论，那你根本就不懂ERP，因为数据库是ERP系统中最关键的部分。 ERP数据库查询通常相当复杂。您至少需要彻底了解关系设计、所有类型的联接以及远远超出基本级别的 CRUD 操作。
您将在 ERP 中支持哪些类型的任务？这可能会带来更多更好的学习建议。例如，如果您需要从 ERP 数据创建自定义报告或数据仓库应用程序，这与仅以管理员身份保持系统运行有很大不同。如果您打算进行性能调优，则需要快速超越基础知识。这是先进的东西，需要多年的专业知识才能做好。还有关于性能调优的整本书，但如果您正在看“傻瓜书”，那么您还没有准备好理解它们。
I don't know about the Oracle equivalent but in SQL Server databases we can run Profiler to see exactly what was sent to the databases when a particular part of the application is run. This is invaluable in trying to fugure out some of the types of questions you have. I'm sure Oracle has some equivalent way to do the same thing or there are other products inthe the marketplace that do that, but I don't know what they are. I just throw out the idea to give you a a type of tool to be looking for.
You need to understand SQL because all ERPS are data intensive and you cannot understand what is going on in the database without understanding SQL. Remember Oracle has it's own flavor of SQL which is very differnt from other databases. So in learning make sure you learn PL/SQL. If the ERP was designed for multiple database backends, it may have used ANSII standard SQL instead of the more robust PL/SQL. If you don't understand both SQL and the theory of relational database design, you really don't understand ERP at all as the database is the most critical part of an ERP system. ERP database queries are generally quite complicated. At a minumum you need to thoroughly understand relational design, all types of joins and far more than the basic level CRUD operations.
What types of tasks are you go ing to be supporting in your ERP? This might lead to more and better suggestions of what to learn. For instance if you need to create custom reporting or data warehouse applications from the ERPs data, that is very different than just keeping the system running as an admin. If you are going to do performance tuning, you need to advance very quickly beyond the basics. This is advanced stuff that requires years of expertise to do well. There are also whole books on performance tuning but if you are looking at the "For Dummies" books, then you are not yet ready to understand them.
我阅读了开发 ERP 软件（使用 .Net 技术）。该应用程序基于分层架构。内容可在此处获取
I read Develop ERP software (using .Net technology). The application is based on layered architecture. The contents is available here