Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

Virtuoso Universal Server - Feature Comparison Matrix

5.x OpenSource
5.x Commercial
6.x OpenSource
6.x Commercial
7.x OpenSource
7.x Commercial

License

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Commercial and OpenSource offerings tick tick tick tick tick tick

SQL Support

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

RDF Database Engine

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Data Providers for Sesame, Jena, and Redland tick tick tick tick tick tick
OpenID, OAuth, and WebID authentication options for service endpoints (e.g., SPARQL) tick tick tick tick tick tick
SPARQL 1.1 Support Y Y tick tick tick tick
DBMS Hosted Pivot Engine (Faceted Linked Data Browser) with Web Services Interfaces (SOAP or RESTful interaction patterns) Y Y tick tick tick tick
Partial Index Support (2+3 Index Layout) Y Y tick tick tick tick
SPARQL GeoSpatial Extensions Y Y tick tick tick tick
SPARQL Transitivity Extensions Y Y tick tick tick tick
Reasoning for: owl:sameAs, owl:equivalentClass, owl:equivalentProperty, owl:InverseFunctionalProperty, rdfs:subClassOf, rdfs:subPropertyOf tick tick tick tick tick tick
Additional Reasoning for: owl:TransitiveProperty, owl:SymmetricalProperty, owl:inverseOf Y Y tick tick tick tick

Database (Relational)

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Unicode Support tick tick tick tick tick tick
GeoSpatial Indices & Queries cross cross cross tick tick tick
Transitive Closure Queries cross cross tick tick tick tick
Backup - Online/Full/Incremental tick tick tick tick tick tick
Connections (Multiple/Concurrent) tick tick tick tick tick tick
XA/2PC Support tick tick tick tick tick tick
Full Text Search tick tick tick tick tick tick
Federated Virtuoso Databases tick tick tick tick tick tick
Federated External 3rd Party Databases (Heterogeneous Relational Data Virtualization) tick tick tick tick tick tick
Backup - Online/Full/Incremental tick tick tick tick tick tick
LDAP Account Management & Authentication Integration tick tick tick tick tick tick
Federated (Same Type DBMS) tick tick tick tick tick tick
VLDB (Multiple Gigabytes /Terabytes) tick tick tick tick tick tick
Vectored Execution of Commands cross cross cross cross tick tick
Compression of Column-wise Data cross cross cross cross tick tick

Storage Options

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Row Store tick tick tick tick tick tick
Column Store cross cross cross cross tick tick
Unified Storage (WebDAV Repository) tick tick tick tick tick tick

Clustering

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Clustering & High Availability cross cross cross tick cross tick
Elastic Cluster cross cross cross cross cross tick

Data Replication

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Snapshot cross tick cross tick cross tick
Transactional cross tick cross tick cross tick
Bi-Directional cross tick cross tick cross tick
RDF Graphs cross tick cross tick cross tick

Security

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Grants & Roles tick tick tick tick tick tick
WebID Authentication Protocol tick tick tick tick tick tick
Encryption tick tick tick tick tick tick
Row Level ACLS (aka RLS) tick tick tick tick tick tick
User Passwords tick tick tick tick tick tick

Interaction Interfaces

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Interactive Command Line - ISQL tick tick tick tick tick tick
Graphical (Web-based) - Conductor tick tick tick tick tick tick

Data Access Interfaces

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
ODBC 3.5 Driver tick tick tick tick tick tick
JDBC 4.0 Driver (supporting: Redland, Jena, Sesame, and Hibernate) tick tick tick tick tick tick
ADO.NET (Entity Frameworks compatible) Provider tick tick tick tick tick tick
OLE DB Provider tick tick tick tick tick tick

Platform Support

5.x (OpenSource) 5.x (Commercial) 6.x (OpenSource) 6.x (Commercial) 7.x (OpenSource) 7.x (Commercial)
Windows (32 & 64 Bit versions) tick tick tick tick tick tick
Mac OS X (Universal Binary) tick tick tick tick tick tick
Linux (32 & 64 Bit versions) tick tick tick tick tick tick
Solaris (SPARC & x86_64)(32 & 64 Bit versions). Others by request. tick tick tick tick tick tick
Others by request.