SQL Server 和 Oracle 等产品是“ORDBMS”的示例吗？
根据维基百科！
http://en.wikipedia.org/wiki/ORDBMS
IBM 的 DB2、Oracle 数据库和 Microsoft SQL Server，声称 支持这项技术并这样做 不同程度的成功
那么，这些产品是否像 PostgreSQL 一样是真正的“ORDBMS”？或者说他们离这个目标还有很长的路要走？有人可以指出我可以阅读有关这些 RDBMS 仍需实现的功能以成为真正的 ORDBMS 的任何链接吗？
According to wikipedia!
http://en.wikipedia.org/wiki/ORDBMS
IBM's DB2, Oracle database, and
Microsoft SQL Server, make claims to
support this technology and do so with
varying degrees of success
So, are these products true "ORDBMS" like PostgreSQL? Or are they a long way from it? Can someone please point me to any link where I can read about the features still to be implemented by these RDBMS to become true ORDBMS!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
随着 8.0 版本的发布，Oracle 将自己重新命名为 ORDBMS，这是 TYPE 出现时的版本。然而它并不是一个非常完整的对象实现。第一个版本中没有继承，直到 9iR2（后来的三个主要版本）才获得用户定义的构造函数。即使是现在，随着 11g 的出现，封装仍然没有得到完全支持：TYPE 不能有私有变量或方法。
事实证明，现有的 Oracle 客户很少关心对象，也很少有 OO 程序员对数据库感兴趣。另外还有一个新的下一件大事：互联网。因此，当版本 8.1 发布时，Oracle 恢复为普通的 RDBMS，尽管它是支持互联网的。因此有 8i 标签（即它有 Java 存储过程）。
对于我们这些接触 SQL 的人来说，对象实现有点笨拙，并且在存储方面没有提供太多功能。然而，TYPE 已成为 PL/SQL 库的主要补充，特别是集合和批量处理。继承和多态性在某些利基场景中可能很有用。几年前，我在 UKOUG 年会上就这个话题发表过演讲。
编辑
Oracle 在每个版本的数据库中仍然包含其所有 ORDBMS 功能。它们非常全面（除了缺少私有变量和方法）。我不知道它与 PostgreSQL 相比如何。 Oracle 的在线文档中介绍了 Oracle 的 OR 功能，您可以阅读
Oracle re-branded itself as an ORDBMS with the release of 8.0, which was the version when TYPEs arrived. However it wasn't a very complete object implementation. There was no inheritance in the first release and it took until 9iR2 - three major releases later - to get user-defined constructors. Even now, with 11g out, encapsulation is not entirely supported: TYPEs cannot have private variables or methods.
It transpired that very few existing Oracle customers cared much about objects and very few OO programmers were interested in databases. Plus there was a new Next Big Thing: the internet. So when version 8.1 was released Oracle reverted to being a plain RDBMS, albeit an internet-enabled one. Hence the 8i tag (i.e. it had Java Stored Procedures).
To those of us brought up on SQL the object implementation is a bit clunky and doesn't offer much with regards to storage. However, TYPEs have been a major addition to the PL/SQL armoury, particularly collections and bulk processing. Inheritance and polymorphism can be useful in some niche scenarios. I presented on this topic at the UKOUG annual conference a few years ago. Find out more.
Edit
Oracle still includes all its ORDBMS features in every edition of the database. They are pretty comprehensive (except for that lack of private variables and methods). I don't know how it compares to PostgreSQL. Oracle's OR features are covered in Oracle's online documentation, which you can read here.
ORDBMS 没有绝对的定义。
Oracle 如何存储对象是通过 将它们隐藏在桌子下面。
十年前，当面向对象数据库被吹捧为下一个重大事件时，这一切都是雾里看花。
我怀疑主要供应商在其现有产品中投入的“对象支持”水平不会有大幅跃升。看起来像是对对象数据库/文档存储的需求，它可能是在不适合 RDBMS 的应用程序中。因此，供应商更有可能构建或购买不同的产品，并专注于用于集成数据的产品，无论数据如何存储。
There is no absolute definition of an ORDBMS.
How Oracle goes about storing objects is by hiding them in tables under the covers.
It is all smoke and mirrors going back ten years when Object Oriented Databases were being flogged as the next big thing.
I suspect that there won't be massive jumps in the level of 'object support' the major vendors put into their existing products. It looks like demand for Object Databases / Document Stores, it is probably in applications unsuited to an RDBMS. So the vendors are more likely to build or buy distinct products and focus on products that serve to integrate data irrespective of how it is stored.
对于 SQL Server，它本身不支持这些功能。
尽管您可能知道有许多工具可以帮助您完成此任务，例如 LINQ。
In the case of SQL server, it does not support these features itself.
Although as you may know there are many tools that will help you with that, like LINQ.
是的，Oracle 和 SQL Server 都是 ORDBMS，顺便说一句，IBM 的 Informix 也是 ORDBMS。
Yes both Oracle and SQL server are ORDBMSs and so is IBM's Informix btw.
这是一个包含对象的 Oracle 页面， “构造函数方法”和“对象比较”。
以及 Oracle 对象 简介
Here is a oracle page covering objects, "Constructor Methods" and "Object Comparison".
And an introduction to Oracle Objects