Virtuoso Feature Summary
The following table provides a comparative summary of features across versions 4.0 and 5.0.
|
SQL, XML, RDF, Free Text Data Management |
|||
| Area | Feature | 4.0 |
5.0 |
| License | Commercial and Open Source offerings | Commercial |
Commercial & GPL |
| SQL Support | SQL92 | • |
• |
| SQL99 | • |
• |
|
| SQL2003/SQL 200n | • |
• |
|
| Schema |
• |
• |
|
| Information Schema | • |
• |
|
| Views (Updatable via Triggers) | • |
• |
|
| Stored Procedures | • |
• |
|
| Triggers | • |
• |
|
| Constraints (Primary & Unique, Foreign, & Check) | • |
• |
|
| Joins | • |
• |
|
| 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 | • |
• |
|
| Expression Support | Group By | • |
• |
| Order By | • |
• |
|
| Extended Data Types | User Defined Functions/Types | • |
• |
| Identity/Auto-Increment | • |
• |
|
| BLOB | • |
• |
|
| Inverse Function (Virtuoso Unique) | • |
• |
|
| EXPLAIN | • |
• |
|
| PL/SQL | SQL Procedure Language | • |
• |
| XML Support | Native XML | • |
• |
| SQLX Support | • |
• |
|
| XQuery | • |
• |
|
| XPath | • |
• |
|
| XSLT | • |
• |
|
| Mapping Schema | • |
• |
|
| XMLType | • |
• |
|
| XMLA Support | • |
• |
|
| Web Services | SOAP/WS* Protocols/UDDI | • |
• |
| RDF | RDF Triple Store Engine | • |
|
| SPARQL Support | • |
||
| Database | Unicode Support | • |
• |
| Backup - Online/Full/Incremental | • |
• |
|
| LDAP | • |
• |
|
| Connections (Multiple/Concurrent) | • |
• |
|
| XA/2PC Support | • |
• |
|
| Full Text Search | • |
• |
|
| Federated (Same Type DBMS) | • |
• |
|
| Virtual/Federated (Heterogeneous) | • |
• |
|
| VLDB (Multiple Gigabytes /Terabytes) | • |
• |
|
| Storage Options | Unified Storage (WebDAV Repository) | • |
• |
| Replication Support | Snapshot - Commercial Version Only | • |
• |
| Transactional | • |
• |
|
| Bi-Directional | • |
• |
|
| Security | Grants & Roles | • |
• |
| SSL & Certificates | • |
• |
|
| Encryption | • |
• |
|
| Row Level ACLS (aka RLS) | • |
• |
|
| User Passwords | • |
• |
|
| User Interface | Interactive Command Line - ISQL | • |
• |
| Graphical (Web-based) - Conductor | • |
• |
|
| Platform Support | Cross-Platform Windows, U*X (HP, AIX,Sun,DEC,BSD,SCO), Linux(Redhat,SuSE), Mac OSX, (32 & 64 bit platforms) | • |
• |
| Data Access Drivers | UDA and 3rd Party (ODBC, JDBC 3.5 Drivers, ADO .Net Provider, OLEDB Providers) | • |
• |
| Resources | Documentation | • |
• |
| Tutorials & Web Demos | • |
• |
|
| Knowledge Base | • |
• |
|
| Weblog | • |
• |
|
| Support Site | • |
• |
|