Keyword Search:
www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Virtuoso Cluster Operation
Conductor Administration Interface
Data Access Interfaces
SQL Reference
Datatypes
User Defined Types
XML Column Type
Identifier Case & Quoting
Wide Character Identifiers
Qualified Names
Literals, Brace Escapes
CREATE TABLE Statement
DROP TABLE Statement
CREATE INDEX Statement
DROP INDEX Statement
ALTER TABLE Statement
CREATE VIEW Statement
CREATE XML SCHEMA Statement
DROP XML SCHEMA Statement
Sequence Objects
INSERT Statement
UPDATE Statement
SELECT Statement
COMMIT WORK, ROLLBACK WORK Statement
CHECKPOINT, SHUTDOWN Statement
Stored Procedures as Views & Derived Tables
GRANT, REVOKE Statement
SET Statement
Best Effort Union
Standard and User-Defined Aggregate Functions
Virtuoso SQL Optimization
SQL Inverse Functions
SQL Grammar
Bitmap Indices
URL rewriting
Virtuoso Cluster Programming
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Database and SPARQL
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

Abstract

SQL Reference.

Table of Contents

10.1. Datatypes
10.1.1. Date Literals
10.1.2. Casting
10.1.3. Time & Date Manipulation
10.1.4. Declaring Collations of Expressions
10.2. User Defined Types
10.2.1. CREATE TYPE Statement
10.2.2. ALTER TYPE Statement
10.2.3. DROP TYPE Statement
10.2.4. CREATE METHOD Statement
10.2.5. Type Instances
10.2.6. Instance References
10.2.7. NEW Operator
10.2.8. Finding Methods - Method Signatures Generation & Comparison
10.2.9. Getting & Setting Member Values of Type Instances (member observers & mutators)
10.2.10. Calling Static Methods
10.2.11. Calling Instance Methods
10.2.12. Serializing & Deserializing Type Instances
10.2.13. User Defined Types Utility Functions
10.2.14. Hosted Foreign Objects in Virtuoso
10.2.15. Using User Defined Types to Represent SOAP Structures
10.2.16. Consuming Third-Party SOAP Services via User Defined Types
10.2.17. UDT Security
10.3. XML Column Type
10.4. Identifier Case & Quoting
10.5. Wide Character Identifiers
10.5.1. UTF-8 Implementation Notes For ODBC
10.5.2. UTF-8 Implementation Notes In JDBC
10.6. Qualified Names
10.6.1. Qualifiers and Owners
10.6.2. Default Qualifiers
10.6.3. USE Statement, USE identifier
10.7. Literals, Brace Escapes
10.7.1. Strings
10.7.2. Numbers
10.7.3. ODBC Brace Escapes
10.7.4. Hexadecimal Literals
10.7.5. Binary Literals
10.8. CREATE TABLE Statement
10.8.1. Syntax
10.8.2. NOT NULL
10.8.3. IDENTITY (Auto Increment)
10.8.4. DEFAULT
10.8.5. PRIMARY KEY Constraint
10.8.6. UNDER
10.8.7. FOREIGN KEY Constraint
10.8.8. The CHECK Constraint
10.8.9. The WITH SCHEMA Constraint
10.9. DROP TABLE Statement
10.10. CREATE INDEX Statement
10.11. DROP INDEX Statement
10.12. ALTER TABLE Statement
10.12.1. Adding a CHECK Constraint
10.13. CREATE VIEW Statement
10.14. CREATE XML SCHEMA Statement
10.15. DROP XML SCHEMA Statement
10.16. Sequence Objects
10.17. INSERT Statement
10.17.1. INSERT SOFT
10.17.2. INSERT REPLACING
10.18. UPDATE Statement
10.19. SELECT Statement
10.19.1. Syntax
10.19.2. Description
10.19.3. Column Aliasing - AS Declaration
10.19.4. Join examples
10.19.5. Ordering and Grouping
10.19.6. Derived Tables
10.19.7. Query Expressions
10.19.8. LIKE Predicate & Search Patterns
10.19.9. The TOP SELECT Option
10.19.10. CASE, NULLIF, COALESCE, CAST Value Expressions
10.19.11. SELECT BREAKUP
10.20. COMMIT WORK, ROLLBACK WORK Statement
10.21. CHECKPOINT, SHUTDOWN Statement
10.21.1. Checkpoint & Page Remapping
10.22. Stored Procedures as Views & Derived Tables
10.22.1. Procedure Table Parameters
10.22.2. Procedure Table Result Sets
10.22.3. Procedure Tables & Security
10.22.4. Procedure Table Cost and Join Order
10.22.5. Limitations
10.22.6. Procedure Table Examples
10.23. GRANT, REVOKE Statement
10.24. SET Statement
10.24.1. ISOLATION
10.24.2. LOCK_ESCALATION_PCT
10.24.3. PARAM_BATCH
10.25. Best Effort Union
10.26. Standard and User-Defined Aggregate Functions
10.26.1. Create Aggregate Statement
10.26.2. Drop Aggregate Statement
10.26.3. Examples of User-Defined Aggregates
10.27. Virtuoso SQL Optimization
10.27.1. Optimization Techniques
10.27.2. Query Options
10.27.3. VDB Statistics for the SQL Compiler Collection
10.28. SQL Inverse Functions
10.28.1. Updating through Inverses
10.29. SQL Grammar
10.30. Bitmap Indices
10.30.1. Bitmap Indices and Transactions
10.30.2. Performance Implications
10.30.3. Physical Structure and Overheads
10.31. URL rewriting
10.31.1. Using URL Rewriting to Solve Linked Data Deployment Challenges
10.31.2. The Virtuoso Rules-Based URL Rewriter
10.31.3. Virtual Domains (Hosts) & Directories
10.31.4. "Nice" URLs vs. "Long" URLs
10.31.5. Rule Processing Mechanics
10.31.6. Enabling URL Rewriting via the Virtuoso Conductor UI
10.31.7. Enabling URL Rewriting via Virtuoso PL
10.31.8. Example - URL Rewriting For the Northwind RDF View
10.31.9. Transparent Content Negotiation
10.31.10. Transparent Content Negotiation in Virtuoso HTTP Server