Virtuoso Universal Server - Feature Comparison Matrix
| 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. | |
|
|
|
|
|
|