Relational Database Engine

Virtuoso includes a powerful native high-peformance and scalable relational database. It handles online transaction processing (local or distributed) and decision support (business analytics and data warehousing) in the manner expected of any enterprise grade RDBMS engine. Key features include:

• SQL-92 and SQL 200n support
  
  
• SQL extensions for Transitive Closures, SPARQL within SQL
  
  
• SQLX for XML based data access
  
  
• SQL extensions for XPath/XQuery, in-built XSLT processor, in-built XML Schema validate
  
  
• User Defined Types
  
  
• Anytime Query -- where configurable response times are assigned to queries
  
  
• Stored Procedures and Stored Procedure Views (also known as Table Value Functions) & Triggers
  
  
• Full Text Indexing, Queries, and Triggers
  
  
• Geo Spatial Indexing and Queries
  
  
• Compatible with XA compliant TP Monitors for Distributed Transactions Processing
  
  
• Row Level Security
  
  
• Cluster Mode that delivers Horizontal Partitioning and Parallel Task Execution
  
  
• Incremental Online Backups
  
  
• High Availability (Failsafe) Functionality for Cluster Configurations
  
  
• High-Performance ODBC, JDBC, ADO.NET (Entity Frameworks compatible), OLE DB, and XMLA data providers / drivers.