OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Commercial and OpenSource offerings |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
SQL92 | |||||||
SQL99 | |||||||
SQL2003/SQL 200n | |||||||
Standard Schema | |||||||
Information Schema | |||||||
Views (Updatable via Triggers) | |||||||
Stored Procedures | |||||||
Triggers | |||||||
Constraints (Primary & Unique, Foreign, & Check) | |||||||
Joins (INNER and OUTER) | |||||||
Unions (Distinct/All) | |||||||
Intersection (Distinct/All) | |||||||
Except (Distinct/All) | |||||||
Sub-Selects/Nested Queries | |||||||
Query in FROM Clause | |||||||
Multi-column predicate | |||||||
Locking and Concurrency | |||||||
Transactions | |||||||
Referential Integrity | |||||||
Partial Rollback from Transaction | |||||||
Locking (Row, Table) | |||||||
Deadlock Detection | |||||||
Group By | |||||||
Order By | |||||||
User Defined Functions/Types | |||||||
Identity/Auto-Increment | |||||||
BLOB | |||||||
Inverse Function (Virtuoso Unique) | |||||||
EXPLAIN | |||||||
SQL Procedure Language | |||||||
Native XML | |||||||
SQLX Support | |||||||
XQuery | |||||||
XPath | |||||||
XSLT | |||||||
SQL to XML Mapping Schema | |||||||
XMLType | |||||||
XMLA Support | |||||||
SOAP/WS* Protocols/UDDI |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Data Providers for Sesame, Jena, and Redland | |||||||
OpenID, OAuth, and WebID authentication options for service endpoints (e.g., SPARQL) | |||||||
SPARQL 1.1 Support | |||||||
DBMS Hosted Pivot Engine (Faceted Linked Data Browser) with Web Services Interfaces (SOAP or RESTful interaction patterns) | |||||||
Partial Index Support (2+3 Index Layout) | |||||||
SPARQL GeoSpatial Extensions | |||||||
SPARQL Transitivity Extensions | |||||||
Reasoning for: owl:sameAs, owl:equivalentClass, owl:equivalentProperty, owl:InverseFunctionalProperty, rdfs:subClassOf, rdfs:subPropertyOf | |||||||
Additional Reasoning for: owl:TransitiveProperty, owl:SymmetricalProperty, owl:inverseOf | |||||||
ABAC (Attributed Based Access Controls) support for named graphs | |||||||
Custom Inference Rules |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Unicode Support | |||||||
GeoSpatial Indices & Queries | |||||||
Transitive Closure Queries | |||||||
Backup - Online/Full/Incremental | |||||||
Connections (Multiple/Concurrent) | |||||||
XA/2PC Support | |||||||
Full Text Search | |||||||
Federated Virtuoso Databases | |||||||
Federated External 3rd Party Databases (Heterogeneous Relational Data Virtualization) | |||||||
LDAP Account Management & Authentication Integration | |||||||
Federated (Same Type DBMS) | |||||||
VLDB (Multiple Gigabytes /Terabytes) | |||||||
Vectored Execution of Commands | |||||||
Compression of Column-wise Data | |||||||
RBAC (Role Based Access Controls) support for named graphs |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Row Store | |||||||
Column Store | |||||||
Unified Storage (WebDAV Repository) |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Clustering & High Availability | |||||||
Elastic Cluster |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Snapshot | |||||||
Transactional | |||||||
Bi-Directional | |||||||
RDF Graphs |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Grants & Roles | |||||||
WebID Authentication Protocol | |||||||
Encryption | |||||||
Row Level ACLS (aka RLS) | |||||||
User Passwords | |||||||
ABAC (Attributed Based Access Controls) support for named graphs |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
Interactive Command Line - ISQL | |||||||
Graphical (Web-based) - Conductor |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
ODBC Driver | |||||||
JDBC Driver (Hibernate-compatible) | |||||||
Redland Provider | |||||||
Jena Provider | |||||||
RDF4J Provider (a/k/a Sesame Provider) | |||||||
ADO.NET Provider (supports Entity Frameworks) | |||||||
OLEDB Provider |
OpenSource Edition 5.x |
Enterprise Edition 5.x |
OpenSource Edition 6.x |
Enterprise Edition 6.x |
OpenSource Edition 7.x |
Enterprise Edition 7.x |
Enterprise Edition 8.x |
|
64-bit server for Windows (x86_64 & IA_64) |
|||||||
32-bit server for Windows (x86, x86_64, & IA_64) |
|||||||
64-bit server for
macOS (x86_64) |
|||||||
32-bit server for
macOS (PowerPC, x86, & x86_64) |
|||||||
64-bit server for Linux (x86 & x86_64) |
|||||||
32-bit server for Linux (x86 & x86_64) |
|||||||
64-bit server for
Solaris (SPARC & x86_64) |
|||||||
32-bit server for
Solaris (SPARC & x86_64) |
|||||||
64-bit client for all OS | |||||||
32-bit client for all OS | |||||||
Others by request. |