Comparison of object-relational database management systems
This is a comparison of object-relational database management systems (ORDBMSs). Each system has at least some features of an object-relational database; they vary widely in their completeness and the approaches taken.
The following tables compare general and technical information; please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.
Basic data
| Name | Vendor | License | OS | Notes |
|---|---|---|---|---|
| Adaptive Server Enterprise | SAP | Proprietary | Cross-platform | |
| CUBRID | NHN Corporation | GPL/BSD | Linux, Windows | |
| DB2 | IBM | Proprietary | Cross-platform | |
| Greenplum Database | Greenplum division of EMC Corporation | Proprietary | ? | Uses PostgreSQL codebase |
| Informix | IBM | Proprietary | Cross-platform | |
| Caché | InterSystems | Proprietary | Cross-platform | |
| Microsoft SQL Server | Microsoft Corporation | Proprietary | Windows, Linux | Supports data objects in .NET languages |
| Oracle Database | Oracle Corporation | Proprietary | Linux, Windows, Unix | |
| PostgreSQL | PostgreSQL Global Development Group | PostgreSQL License | Cross-platform | |
| OpenEdge Advanced Business Language (formerly Progress 4GL) | Progress Software Corporation | Proprietary | Cross-platform | |
| Virtuoso Universal Server | OpenLink Software | GPLv2 or proprietary | Cross-platform | |
| VMDS (Version Managed Data Store) | GE Energy, a division of General Electric | Proprietary | ? | GIS for public utilities; can be stored inside Oracle Database |
| WakandaDB | 4th Dimension | AGPLv3 or proprietary | Windows, Linux, macOS | Based on REST and server-side JavaScript |
| XDB Enterprise Server | Micro Focus | Proprietary | DOS, Windows NT, OS/2 | |
| Zope Object Database | Zope Corporation | Zope Public License | Cross-platform | For Python, also included in Zope web application server |
Object features
Information about what fundamental ORDBMSes features are implemented natively.
| Type | Method | Type inheritance | Table inheritance | |
|---|---|---|---|---|
| CUBRID | Yes | Yes | Yes | Yes |
| Oracle | Yes | Yes[Note 1] | Yes | Yes |
| OpenLink Virtuoso | Yes | Yes | Yes | Yes |
| PostgreSQL | Yes | Yes | Yes | Yes |
| Informix | Yes | Yes | Yes | Yes |
| WakandaDB | Yes | Yes | Yes | Yes |
Data types
Information about what data types are implemented natively.
| Array | List | Set | Multiset | Object reference | |
|---|---|---|---|---|---|
| CUBRID | Yes | Yes | Yes | Yes | Yes |
| Oracle | Yes | Yes | Yes | Yes | Yes |
| OpenLink Virtuoso | Yes | Yes | Yes | Yes | Yes |
| PostgreSQL | Yes | Yes | Yes | Yes | Yes |
| Informix | No | Yes | Yes | Yes | Yes |
gollark: In what way?
gollark: The canonical ground is kept in a vault in Paris, like what they used to have for the prototype kilogram and metre.
gollark: It looms ever closer, as you can see from this image.
gollark: Great!
gollark: Minoteaur 8 has search now!
See also
Notes
- No private methods, no way to call super method from a child.
External links
- Arvin.dk, Comparison of different SQL implementations
| Types |
|
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
| |
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.