Virtuoso Universal Server - Feature Comparison Matrix

License

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 Yes Yes Yes Yes Yes Yes Yes

SQL Support

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 Yes Yes Yes Yes Yes Yes Yes
SQL99 Yes Yes Yes Yes Yes Yes Yes
SQL2003/SQL 200n Yes Yes Yes Yes Yes Yes Yes
Standard Schema Yes Yes Yes Yes Yes Yes Yes
Information Schema Yes Yes Yes Yes Yes Yes Yes
Views (Updatable via Triggers) Yes Yes Yes Yes Yes Yes Yes
Stored Procedures Yes Yes Yes Yes Yes Yes Yes
Triggers Yes Yes Yes Yes Yes Yes Yes
Constraints (Primary & Unique, Foreign, & Check) Yes Yes Yes Yes Yes Yes Yes
Joins (INNER and OUTER) Yes Yes Yes Yes Yes Yes Yes
Unions (Distinct/All) Yes Yes Yes Yes Yes Yes Yes
Intersection (Distinct/All) Yes Yes Yes Yes Yes Yes Yes
Except (Distinct/All) Yes Yes Yes Yes Yes Yes Yes
Sub-Selects/Nested Queries Yes Yes Yes Yes Yes Yes Yes
Query in FROM Clause Yes Yes Yes Yes Yes Yes Yes
Multi-column predicate Yes Yes Yes Yes Yes Yes Yes
Locking and Concurrency Yes Yes Yes Yes Yes Yes Yes
Transactions Yes Yes Yes Yes Yes Yes Yes
Referential Integrity Yes Yes Yes Yes Yes Yes Yes
Partial Rollback from Transaction Yes Yes Yes Yes Yes Yes Yes
Locking (Row, Table) Yes Yes Yes Yes Yes Yes Yes
Deadlock Detection Yes Yes Yes Yes Yes Yes Yes
Group By Yes Yes Yes Yes Yes Yes Yes
Order By Yes Yes Yes Yes Yes Yes Yes
User Defined Functions/Types Yes Yes Yes Yes Yes Yes Yes
Identity/Auto-Increment Yes Yes Yes Yes Yes Yes Yes
BLOB Yes Yes Yes Yes Yes Yes Yes
Inverse Function (Virtuoso Unique) Yes Yes Yes Yes Yes Yes Yes
EXPLAIN Yes Yes Yes Yes Yes Yes Yes
SQL Procedure Language Yes Yes Yes Yes Yes Yes Yes
Native XML Yes Yes Yes Yes Yes Yes Yes
SQLX Support Yes Yes Yes Yes Yes Yes Yes
XQuery Yes Yes Yes Yes Yes Yes Yes
XPath Yes Yes Yes Yes Yes Yes Yes
XSLT Yes Yes Yes Yes Yes Yes Yes
SQL to XML Mapping Schema Yes Yes Yes Yes Yes Yes Yes
XMLType Yes Yes Yes Yes Yes Yes Yes
XMLA Support Yes Yes Yes Yes Yes Yes Yes
SOAP/WS* Protocols/UDDI Yes Yes Yes Yes Yes Yes Yes

RDF Relational Property/Predicate Graph Database

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 Yes Yes Yes Yes Yes Yes Yes
OpenID, OAuth, and WebID authentication options for service endpoints (e.g., SPARQL) Yes Yes Yes Yes Yes Yes Yes
SPARQL 1.1 Support No No Yes Yes Yes Yes Yes
DBMS Hosted Pivot Engine (Faceted Linked Data Browser) with Web Services Interfaces (SOAP or RESTful interaction patterns) No No Yes Yes Yes Yes Yes
Partial Index Support (2+3 Index Layout) No No Yes Yes Yes Yes Yes
SPARQL GeoSpatial Extensions No No Yes Yes Yes Yes Yes
SPARQL Transitivity Extensions No No Yes Yes Yes Yes Yes
Reasoning for: owl:sameAs, owl:equivalentClass, owl:equivalentProperty, owl:InverseFunctionalProperty, rdfs:subClassOf, rdfs:subPropertyOf Yes Yes Yes Yes Yes Yes Yes
Additional Reasoning for: owl:TransitiveProperty, owl:SymmetricalProperty, owl:inverseOf No No Yes Yes Yes Yes Yes
ABAC (Attributed Based Access Controls) support for named graphs No No No No No Yes Yes
Custom Inference Rules No No No No No No Yes

SQL Relational Tables Database

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 Yes Yes Yes Yes Yes Yes Yes
GeoSpatial Indices & Queries No No No Yes Yes Yes Yes
Transitive Closure Queries No No Yes Yes Yes Yes Yes
Backup - Online/Full/Incremental Yes Yes Yes Yes Yes Yes Yes
Connections (Multiple/Concurrent) Yes Yes Yes Yes Yes Yes Yes
XA/2PC Support Yes Yes Yes Yes Yes Yes Yes
Full Text Search Yes Yes Yes Yes Yes Yes Yes
Federated Virtuoso Databases Yes Yes Yes Yes Yes Yes Yes
Federated External 3rd Party Databases (Heterogeneous Relational Data Virtualization) No Yes No Yes No Yes Yes
LDAP Account Management & Authentication Integration Yes Yes Yes Yes Yes Yes Yes
Federated (Same Type DBMS) Yes Yes Yes Yes Yes Yes Yes
VLDB (Multiple Gigabytes /Terabytes) Yes Yes Yes Yes Yes Yes Yes
Vectored Execution of Commands No No No No Yes Yes Yes
Compression of Column-wise Data No No No No Yes Yes Yes
RBAC (Role Based Access Controls) support for named graphs No No No No No Yes Yes

Storage Options

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 Yes Yes Yes Yes Yes Yes Yes
Column Store No No No No Yes Yes Yes
Unified Storage (WebDAV Repository) Yes Yes Yes Yes Yes Yes Yes

Clustering

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 No No No Yes No Yes Yes
Elastic Cluster No No No No No Yes Yes

Data Replication

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 No Yes No Yes No Yes Yes
Transactional No Yes No Yes No Yes Yes
Bi-Directional No Yes No Yes No Yes Yes
RDF Graphs No No No Yes No Yes Yes

Security

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 Yes Yes Yes Yes Yes Yes Yes
WebID Authentication Protocol Yes Yes Yes Yes Yes Yes Yes
Encryption Yes Yes Yes Yes Yes Yes Yes
Row Level ACLS (aka RLS) Yes Yes Yes Yes Yes Yes Yes
User Passwords Yes Yes Yes Yes Yes Yes Yes
ABAC (Attributed Based Access Controls) support for named graphs No No No No No Yes Yes

Interaction Interfaces

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 Yes Yes Yes Yes Yes Yes Yes
Graphical (Web-based) - Conductor Yes Yes Yes Yes Yes Yes Yes

Data Access Interfaces

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 Yes Yes Yes Yes Yes Yes Yes
JDBC Driver (Hibernate-compatible) Yes Yes Yes Yes Yes Yes Yes
Redland Provider Yes Yes Yes Yes Yes Yes Yes
Jena Provider Yes Yes Yes Yes Yes Yes Yes
RDF4J Provider (a/k/a Sesame Provider) Yes Yes Yes Yes Yes Yes Yes
ADO.NET Provider (supports Entity Frameworks) Yes Yes Yes Yes Yes Yes Yes
OLEDB Provider Yes Yes Yes Yes Yes Yes Yes

Platform Support

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)		 Yes Yes Yes Yes Yes Yes Yes
32-bit server for Windows
(x86, x86_64, & IA_64)		 Yes Yes Yes Yes No No No
64-bit server for macOS
(x86_64)		 No No No No Yes Yes Yes
32-bit server for macOS
(PowerPC, x86, & x86_64)		 Yes Yes Yes Yes No No No
64-bit server for Linux
(x86 & x86_64)		 Yes Yes Yes Yes Yes Yes Yes
32-bit server for Linux
(x86 & x86_64)		 Yes Yes Yes Yes No No No
64-bit server for Solaris
(SPARC & x86_64)		 Yes Yes Yes Yes Yes Yes Yes
32-bit server for Solaris
(SPARC & x86_64)		 Yes Yes Yes Yes No No No
64-bit client for all OS Yes Yes Yes Yes Yes Yes Yes
32-bit client for all OS Yes Yes Yes Yes Yes Yes Yes
Others by request. Yes Yes Yes Yes Yes Yes Yes