OpenLink Virtuoso Universal Server: Documentation - Contents
Contents
|
Prev
|
Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Administration
Data Access Interfaces
SQL Reference
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Data Access and Data Management
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide
OpenLink Virtuoso Universal Server: Documentation - Contents
1. Overview
1.1. What is Virtuoso?
1.2. Why Do I Need Virtuoso?
1.3. Key Features of Virtuoso
1.3.2. XML Document Storage & Creation
1.3.3. Web Page Hosting
1.3.4. Web Services Creation & Hosting
1.3.5. WebDAV Compliant Web Store
1.3.6. Content Replication & Synchronization
1.3.7. Transparent Access To Heterogeneous Data
1.3.8. Mail Delivery & Retrieval Services
1.3.9. NNTP Aggregation & Serving
2. Installation Guide
2.1. Virtuoso for Windows 95/98/NT/2000/XP
2.1.1. Existing Virtuoso 2.7 Users
2.1.2. Before You Start
2.1.3. Getting To Know Your Virtuoso Components
2.1.4. Installation Steps
2.1.5. Starting Your Virtuoso Server
2.1.6. Post-Installation Sanity Check
2.1.7. Creating and Deleting Virtuoso Services
2.1.8. Configuring Virtuoso Client Components
2.1.9. Default passwords
2.2. Virtuoso for Linux (Enterprise Edition)
2.2.1. Existing Virtuoso 2.7 Users
2.2.2. Before You Install
2.2.3. Installation Process
2.2.4. Post-Installation Sanity Check
2.2.5. Starting Virtuoso Automatically on Reboot
2.2.6. Default passwords
2.3. Virtuoso for Unix (Enterprise Edition)
2.3.1. Existing Virtuoso 2.7 Users
2.3.2. Before You Install
2.3.3. Installation Process
2.3.4. Post-Installation Sanity Check
2.3.5. Starting Virtuoso Automatically on Reboot
2.3.6. Default passwords
2.4. Virtuoso for Unix (Personal Edition)
2.4.1. Installation
2.4.2. Configuration
2.4.3. Demo Database
2.5. Virtuoso for Mac OS X
2.5.1. Existing Virtuoso 2.7 Users
2.5.2. Before You Install
2.5.3. Installation Process
2.5.4. Configuration
2.5.5. Configuring an ODBC Data Source
2.5.6. Testing an ODBC Data Source
2.5.7. Post-Installation Sanity Check
2.5.8. Default passwords
2.5.9. Demo Database
3. Quick Start & Tours
3.1. Where to Start
3.1.1. Default Passwords
3.1.2. Post-Installation Sanity Check
3.1.3. Administering Your Virtuoso Installation
3.2. Client Connections
3.2.1. ODBC
3.2.2. JDBC
3.2.3. OLEDB
3.3. Virtual Database Server
3.3.1. Configuring Your ODBC Data Sources
3.3.2. Datasource Check
3.3.3. Demo Datasource Query
3.3.4. Linking Remote Tables Into Virtuoso
3.3.5. Listing or Unlinking Tables
3.3.6. Querying Linked Tables
3.4. Web Server
3.4.1. Virtual Directories
3.4.2. Multi Homing
3.5. WebDAV
3.5.1. Web Folders
3.6. Web Services
3.7. Exposing Persistent Stored Modules as Web Services
3.7.1. Publishing Stored Procedures as Web Services
3.7.2. XML Query Templates
3.7.3. Publishing VSE's as Web Services
3.8. VSMX - Virtuoso Service Module for XML
3.9. SQL to XML
3.9.4. FOR XML Execution Modes
3.9.5. Tables With XML Columns
3.10. NNTP
3.10.1. NNTP Server Setup
3.10.2. Local & Remote Groups
3.10.3. NNTP Client Setup
3.11. Dynamic Web Pages
3.12. VSP Examples
3.12.1. Simple HTML FORM usage
3.12.2. Manipulating Database Data in VSP
3.12.3. Simple Tutorial
3.13. Third-Party Runtime Typing, Hosting & User Defined Types
3.14. Troubleshooting Tips
3.14.1. General Tips
3.14.2. DBMS Server will not start
3.14.3. Case Mode
4. Sample ODBC & JDBC Applications
4.1. Binary & Source File Locations
4.1.1. ODBC Demonstration Applications
4.1.2. JDBC Demonstration Applications
4.2. Sample ODBC Applications
4.2.1. Mac OS X
4.2.2. Windows 95/98/NT/2000
4.2.3. Linux & UNIX
4.2.4. MS DTC ODBC Sample Application
4.2.5. MS DTC OLE DB Sample Application
4.3. Sample JDBC Applications & Applets
4.3.1. JDBCDemo Java Application
4.3.2. ScrollDemo2 Java Application
4.3.3. ScrollDemo2 Java Applet
4.3.4. JBench Application
4.3.5. JTA Demo Application
5. Conceptual Overview
5.1. Core Database Engine
5.1.1. Logical Data Model
5.1.2. Data Types
5.1.3. Locking
5.1.4. Internationalization & Unicode
5.1.5. Creating A Collation
5.2. Virtual Database (VDB) Engine
5.2.1. The Need for VDB Engines
5.2.2. First Generation Virtual Database Products
5.2.3. VDB Implementation Issues
5.2.4. VDB Engine Components
5.3. Web & Internet Protocol Support
5.4. Web Services Protocol Support
5.5. Architecture
6. Administration
6.1. Database Server Administration
6.1.1. Database
6.1.2. Virtual Database
6.1.3. Virtuoso User Model
6.1.4. VAD - Virtuoso Application Distribution
6.1.5. Data Backup & Recovery
6.1.6. Performance diagnostics
6.1.7. Performance Tuning
6.2. HTML based Administration Console (Conductor) Guide
6.2.1. Virtuoso Conductor Administration
6.2.2. Runtime Hosting
6.2.3. Web Services
6.2.4. WebDAV Administration
6.2.5. Internet Domains
6.2.6. XML Services
6.2.7. Query Tools
6.2.8. Replication & Synchronization
6.2.9. Database Administration
6.2.10. Conductor News Server Administration
8. Data Access Interfaces
8.1. Virtuoso .NET Data Provider
8.1.2. VirtDbType Enumeration
8.1.3. VirtuosoCommand Class
8.1.4. VirtuosoCommandBuilder Class
8.1.5. VirtuosoConnection Class
8.1.6. VirtuosoDataAdapter Class
8.1.7. VirtuosoDataReader Class
8.1.8. VirtuosoError Class
8.1.9. VirtuosoErrorCollection Class
8.1.10. VirtuosoException Class
8.1.11. VirtuosoInfoMessageEventArgs Class
8.1.12. VirtuosoInfoMessageEventHandler Delegate
8.1.13. VirtuosoParameter Class
8.1.14. VirtuosoParameterCollection Class
8.1.15. VirtuosoPermission Class
8.1.16. VirtuosoPermissionAttribute
8.1.17. VirtuosoRowUpdatedEventArgs Class
8.1.18. VirtuosoRowUpdatedEventHandler Delegate
8.1.19. VirtuosoRowUpdatingEventArgs Class
8.1.20. VirtuosoRowUpdatingEventHandler Delegate
8.1.21. VirtuosoTransaction Class
8.2. Interactive SQL Utility
8.2.1. Invoking ISQL
8.2.2. ISQL Commands
8.2.3. ISQL Macro Substitution
8.2.4. ISQL Variables
8.2.5. Using isql as a General Purpose Test Driver
8.3. Virtuoso Driver for ODBC
8.3.1. Windows ODBC Driver Configuration
8.3.2. Using X509 Certificates With ODBC Connection
8.3.3. Manually configuring a Virtuoso ODBC DSN on Unix
8.3.4. ODBC Compliance
8.3.5. Virtuoso Scrollable Cursor Engine
8.3.6. Effect of Connection & Statement Options
8.3.7. Efficient Use of API
8.3.8. Executing SQL from Python script
8.4. Virtuoso Driver for JDBC
8.4.1. Virtuoso Drivers for JDBC Packaging
8.4.2. Virtuoso Driver For JDBC URL Format
8.4.3. Virtuoso Driver JDBC 3.0 features
8.4.4. Installation & Configuration Steps
8.5. OLE DB Provider for Virtuoso
8.5.1. Using the OLE DB Provider for Virtuoso
8.5.2. Known Limitations
8.5.3. Data Types
8.5.4. Metadata
8.5.5. Supported Interfaces
8.5.6. Data Source Objects
8.5.7. Sessions
8.5.8. Rowsets
8.6. Virtuoso In-Process Client
8.7. Unix Domain Socket Connections
9. SQL Reference
9.1. Datatypes
9.1.1. Date Literals
9.1.2. Casting
9.1.3. Time & Date Manipulation
9.1.4. Declaring Collations of Expressions
9.2. User Defined Types
9.2.1. CREATE TYPE Statement
9.2.2. ALTER TYPE Statement
9.2.3. DROP TYPE Statement
9.2.4. CREATE METHOD Statement
9.2.5. Type Instances
9.2.6. Instance References
9.2.7. NEW Operator
9.2.8. Finding Methods - Method Signatures Generation & Comparison
9.2.9. Getting & Setting Member Values of Type Instances (member observers & mutators)
9.2.10. Calling Static Methods
9.2.11. Calling Instance Methods
9.2.12. Serializing & Deserializing Type Instances
9.2.13. User Defined Types Utility Functions
9.2.14. Hosted Foreign Objects in Virtuoso
9.2.15. Using User Defined Types to Represent SOAP Structures
9.2.16. Consuming Third-Party SOAP Services via User Defined Types
9.2.17. UDT Security
9.3. XML Column Type
9.4. Identifier Case & Quoting
9.5. Wide Character Identifiers
9.5.1. UTF-8 Implementation Notes For ODBC
9.5.2. UTF-8 Implementation Notes In JDBC
9.6. Qualified Names
9.6.1. Qualifiers and Owners
9.6.2. Default Qualifiers
9.6.3. USE Statement, USE identifier
9.7. Literals, Brace Escapes
9.7.1. Strings
9.7.2. Numbers
9.7.3. ODBC Brace Escapes
9.7.4. Hexadecimal Literals
9.7.5. Binary Literals
9.8. CREATE TABLE Statement
9.8.1. Syntax
9.8.2. NOT NULL
9.8.3. IDENTITY (Auto Increment)
9.8.4. DEFAULT
9.8.5. PRIMARY KEY Constraint
9.8.6. UNDER
9.8.7. FOREIGN KEY Constraint
9.8.8. The CHECK Constraint
9.8.9. The WITH SCHEMA Constraint
9.9. DROP TABLE Statement
9.10. CREATE INDEX Statement
9.11. DROP INDEX Statement
9.12. ALTER TABLE Statement
9.12.1. Adding a CHECK Constraint
9.13. CREATE VIEW Statement
9.14. CREATE XML SCHEMA Statement
9.15. DROP XML SCHEMA Statement
9.16. Sequence Objects
9.17. INSERT Statement
9.17.1. INSERT SOFT
9.17.2. INSERT REPLACING
9.18. UPDATE Statement
9.19. SELECT Statement
9.19.1. Syntax
9.19.2. Description
9.19.3. Column Aliasing - AS Declaration
9.19.4. Join examples
9.19.5. Ordering and Grouping
9.19.6. Derived Tables
9.19.7. Query Expressions
9.19.8. LIKE Predicate & Search Patterns
9.19.9. The TOP SELECT Option
9.19.10. CASE, NULLIF, COALESCE, CAST Value Expressions
9.19.11. SELECT BREAKUP
9.20. COMMIT WORK, ROLLBACK WORK Statement
9.21. CHECKPOINT, SHUTDOWN Statement
9.21.1. Checkpoint & Page Remapping
9.22. Stored Procedures as Views & Derived Tables
9.22.1. Procedure Table Parameters
9.22.2. Procedure Table Result Sets
9.22.3. Procedure Tables & Security
9.22.4. Procedure Table Cost and Join Order
9.22.5. Limitations
9.22.6. Procedure Table Examples
9.23. GRANT, REVOKE Statement
9.24. SET Statement
9.24.1. ISOLATION
9.24.2. LOCK_ESCALATION_PCT
9.24.3. transaction_timeout
9.24.4. PARAM_BATCH
9.25. Best Effort Union
9.26. Standard and User-Defined Aggregate Functions
9.26.1. Create Aggregate Statement
9.26.2. Drop Aggregate Statement
9.26.3. Examples of User-Defined Aggregates
9.27. Virtuoso SQL Optimization
9.27.1. Optimization Techniques
9.27.2. Query Options
9.27.3. VDB Statistics for the SQL Compiler Collection
9.28. SQL Inverse Functions
9.28.1. Updating through Inverses
9.29. SQL Grammar
9.30. Bitmap Indices
9.30.1. Bitmap Indices and Transactions
9.30.2. Performance Implications
9.30.3. Physical Structure and Overheads
10. SQL Procedure Language Guide
10.1. General Principles
10.2. Scope of Declarations
10.3. Data Types
10.4. Handling Result Sets
10.5. Result Sets and Array Parameters
10.6. Exception Semantics
10.7. Virtuoso/PL Syntax
10.7.1. Create Procedure Statement
10.7.2. Stored Procedures as Views & Derived Tables
10.7.3. Keyword and Optional Procedure Arguments
10.7.4. if, while, for, foreach statements
10.7.5. compound statement
10.7.6. goto, return statements
10.7.7. whenever statement
10.7.8. call, assignment statements
10.7.9. open, fetch, close, select ... into statements
10.7.10. FOR Select Statement
10.7.11. SET statement
10.7.12. SET Triggers
10.8. Execute Stored Procedures via SELECT statement
10.9. Execute Stored Procedures In Background
10.10. CREATE ASSEMBLY Syntax - External Libraries
10.11. CREATE PROCEDURE Syntax - External hosted procedures
10.12. Asynchronous Execution and Multithreading in Virtuoso/PL
10.12.1. Synchronization
10.13. Performance Tips
10.13.1. Remember the following:
10.14. Procedures and Transactions
10.15. Distributed Transaction & Two Phase Commit
10.15.1. Initiating Distributed Transactions
10.15.2. Responding to Distributed Transactions
10.15.3. 2PC Log & Recovery
10.15.4. Error Codes
10.16. Triggers
10.16.1. The CREATE TRIGGER statement
10.16.2. Triggers on Views
10.16.3. The DROP TRIGGER statement
10.16.4. Triggers and Virtual Database
10.17. Character Escaping
10.17.1. Statement Level
10.17.2. Connection Level
10.17.3. Server Default
10.18. Virtuoso/PL Scrollable Cursors
10.18.1. Declaring a Scrollable Cursor
10.18.2. Opening a Scrollable Cursor
10.18.3. Fetching Data From a Scrollable Cursor
10.18.4. Virtuoso/PL Scrollable Cursor Examples
10.18.5. FORWARD-ONLY (traditional cursor statement) Example
10.18.6. DYNAMIC (traditional cursor statement) Example
10.18.7. KEYSET (traditional cursor statement) Example
10.19. Virtuoso PL Modules
10.19.1. Syntax
10.19.2. Security
10.20. Handling Conditions In Virtuoso/PL Procedures
10.20.1. Declaring Condition Handlers
10.20.2. Stack Trace Reporting On Sql Error Generation
10.21. Procedure Language Debugger
10.21.1. Branch Coverage
10.21.2. Coverage Functions
10.22. Row Level Security
10.22.1. Row Level Security Functions
11. Database Event Hooks
11.1. Database Startup
11.2. Database Connections
11.3. Database Logins
11.4. Database Disconnections
11.5. Database Shutdown
11.6. SQL Statement Preparation
11.7. SQL Parse Tree
11.7.1. Notes on Special Features of the Parse Tree
11.7.2. SQL Security and Parse Trees
11.7.3. Debugging with Parse Trees
11.8. WebDAV Logins
11.9. Associating Auxiliary Data With A Connection
12. Data Replication, Synchronization and Transformation Services
12.1. Introduction
12.1.1. Snapshot replication
12.1.2. Transactional replication
12.2. Snapshot Replication
12.2.1. Non incremental snapshot replication
12.2.2. Incremental snapshot replication
12.2.3. Command reference
12.2.4. Bi-Directional Snapshot Replication
12.2.5. Registry variables
12.2.6. Heterogeneous snapshot replication
12.2.7. Data type mappings
12.2.8. Objects created by incremental snapshot replication
12.2.9. Objects created by bi-directional snapshot replication
12.2.10. Replication system tables
12.2.11. Table snapshot logs
12.3. Transactional Replication
12.3.1. Publishable Items
12.3.2. Errors in Replication
12.3.3. Publisher Transactional Replication Functions
12.3.4. Subscriber Functions
12.3.5. Common Status Functions
12.3.6. Bi-Directional Transactional Replication
12.3.7. Purging replication logs
12.3.8. Objects created by transactional replication
12.4. Virtuoso scheduler
12.4.1. SYS_SCHEDULED_EVENT
12.5. Transactional Replication Example
12.5.1. Transactional Replication Objects Example
12.6. Replication Logger Sample
12.6.1. Configuration of the Sample
12.6.2. Synchronization
12.6.3. Running the Sample
12.6.4. Notes on the Sample's Dynamics
13. Web Application Development
13.1. The HTTP Server
13.1.2. HTTP Server Base Configuration
13.1.3. Virtual Directories
13.1.4. Authentication
13.1.5. Session Management
13.1.6. Writing Your Own Authentication and Session Handling
13.1.7. Cancellation of Web Requests
13.1.8. Virtuoso WebRobot API
13.1.9. HTTP Server Extensions
13.1.10. Chunked Transfer Encoding
13.1.11. Using Virtuoso Server capabilities via Apache Web Server
13.2. Web Services ACL (Access Control List)
13.2.1. General purpose ACLs
13.2.2. ACL Definition/Removal
13.2.3. Using ACL's Within Application Logic
13.2.4. Predefined ACLs
13.3. Virtuoso Server Pages (VSP)
13.3.2. VSP Markup & Basic Functions
13.3.3. Access Request Information
13.3.4. Errors in Page Procedures
13.3.5. /INLINEFILE HTTP Server Pseudo-Directory
13.3.6. Beyond Basics
13.3.7. Long HTTP Transactions
13.3.8. Using chunked encoding in HTTP 1.1
13.3.9. Making Simple Dynamic Web Pages
13.3.10. Generation of non-HTML output
13.3.11. Post VSP XSLT Transformation Mode
13.3.12. XML & XSLT Generated VSP Pages
13.4. Virtuoso Server Pages for XML (VSPX)
13.4.1. Processing Model
13.4.2. Object Model
13.4.3. Keeping Page and Session State
13.4.4. Application Code
13.4.5. A Simple Example
13.4.6. VSPX Event Handler Parameters
13.4.7. Registering a VSPX Event Callbacks
13.4.8. Commonly Used Types of Attributes of VSPX Controls
13.4.9. VSPX Controls
13.4.10. XForms rendering
13.4.11. XMLSchema for VSPX page
13.5. Deploying ASP.Net Web Applications
13.5.2. Programming Concepts
13.5.3. ASP.Net Deployment & Configuration
13.5.4. The Mono Project
13.5.5. Migrating ASP.Net Applications to Virtuoso
13.6. ASMX Web Service Hosting
13.7. Blogging & Weblogs
13.7.1. The Virtuoso Blogging Application
13.7.2. Blogger Clients Compatibility
13.7.3. Blogs Management User Interface
13.7.4. Community Blog Site
13.7.5. Blogger API
13.7.6. MetaWeblog API
13.7.7. Movable Type API
13.7.8. Atom API
13.7.9. XML-RPC Endpoint Configuration
13.7.10. Blog Hooks - Customizing the Blog Server
13.7.11. Blogger Client API
13.7.12. xmlStorageSystem API
13.7.13. User's Blog quota
13.7.14. Posting a message in to the Blog
13.7.15. Multi-author blogging
13.7.16. Posting a comments
13.7.17. Blog Post Upstreaming (bridging)
13.7.18. Weblogs API
13.7.19. Subscriptions
13.7.20. Trackback API
13.7.21. Pingback API
13.7.22. E-mail Notifications
13.7.23. Comments tracking options
13.7.24. Subscription Harmonizer API
13.7.25. Mobile Blogging (Moblog)
13.7.26. Posting a dynamic content
13.7.27. Notification Services
13.7.28. Rendering the RSS feed in WML format
13.8. Deploying PHP Applications
13.8.2. Building the Virtuoso Server With PHP Extension
13.8.3. PHP Extension Functions
13.8.4. PHP Examples
13.9. Deploying JSP Applications
13.9.2. Environment Setup & Verification
13.10. Perl Hosting
13.11. Python Hosting
13.12. Ruby Hosting
14. XML Support
14.1. Rendering SQL Queries as XML (FOR XML Clause)
14.1.1. FOR XML EXPLICIT Mode
14.1.2. Examples of FOR XML
14.1.3. Functions
14.1.4. FOR XML Syntax
14.2. XML Composing Functions in SQL Statements (SQLX)
14.3. Virtuoso XML Services
14.3.1. XPATH Implementation and SQL
14.3.2. XPATH Query Options
14.3.3. XML Views - Representing SQL Data as Dynamic and Persistent XML
14.3.4. External Entity References in Stored XML
14.3.5. Using XPATH in SQL Queries and Procedures
14.3.6. XQUERY and XML view
14.3.7. Mapping Schemas as XML Views
14.3.8. Differences Between SQLX, FOR XML and XML Views
14.4. Querying Stored XML Data
14.4.1. XPATH_CONTAINS SQL Predicate
14.4.2. Using xpath_eval()
14.4.3. External Entity References in Stored XML
14.4.4. XML Schema & DTD Functions
14.4.5. Using XML and Free Text
14.4.6. XCONTAINS predicate
14.4.7. text-contains XPath Predicate
14.4.8. XML Free Text Indexing Rules
14.4.9. XML Processing & Free Text Encoding Issues
14.5. Using UpdateGrams to Modify Data
14.5.1. Updategrams Basics
14.5.2. Elements Description
14.5.3. Determining Actions
14.5.4. Using Input Parameters
14.5.5. Examples
14.6. XML Templates
14.6.2. Syntax
14.6.3. Saving SQL Queries to XML Template
14.6.4. Saving XQUERY Queries to XML Template
14.6.5. Saving XPATH Queries to XML Template
14.6.6. Programmatic Examples
14.7. XML DTD and XML Schemas
14.7.1. XML Document Type Definition (DTD)
14.7.2. Configuration Options of the DTD Validator
14.7.3. XML Schema Definition Language
14.7.4. XML Schema Functions
14.7.5. XML Schema & SOAP
14.8. XQuery 1.0 Support
14.8.1. Types of XQuery Expressions
14.8.2. Details of XQuery Syntax
14.8.3. Pre-compilation of XPath and XQuery Expressions
14.9. XSLT Transformation
14.9.1. Namespaces
14.9.2. The <xsl:output> Tag
14.9.3. External Parameters in XSLT Stylesheets
14.9.4. Functions
14.9.5. XSLT Examples
14.9.6. XPath Function Extensions for XSLT
14.9.7. Status Of XSLT And XPath Implementation
14.10. XMLType
14.11. Changing XML entities in DOM style
14.11.1. Composing Document Fragments From DOM Function Arguments
15. RDF Data Access and Data Management
15.1. Data Representation
15.1.1. IRI_ID Type
15.1.2. RDF_BOX Type
15.1.3. RDF_QUAD and other tables
15.1.4. Short, Long and SQL Values
15.1.5. Special Cases and XML Schema Compatibility
15.1.6. SQL Compiler Support - QUIETCAST option
15.1.7. Dynamic Renaming of Local IRI's
15.2. SPARQL
15.2.1. SPARQL Implementation Details
15.2.2. Query Constructs
15.2.3. SPARQL Web Services & APIs
15.2.4. Troubleshooting SPARQL Queries
15.2.5. Extensions
15.2.6. SPARQL Inline in SQL
15.2.7. API Functions
15.2.8. Useful Internal Functions
15.2.9. Default and Named Graphs
15.2.10. Calling SQL from SPARQL
15.2.11. SPARQL DESCRIBE
15.3. RDF Graphs Security
15.3.1. RDF Graph Groups
15.3.2. NOT FROM and NOT FROM NAMED Clauses
15.3.3. Graph-Level Security
15.3.4. Understanding Default Permissions
15.3.5. Initial Configuration of SPARQL Security
15.3.6. Application Callbacks for Graph Level Security
15.4. Automated Generation of RDF Views over Relational Data Sources
15.4.1. Introduction
15.4.2. One Click Linked Data Generation & Deployment
15.4.3. Manual Linked Data Generation & Deployment using the Conductor's HTML-based wizard
15.5. RDF Insert Methods in Virtuoso
15.5.1. HTTP Post using Content-Type: application/sparql-query
15.5.2. HTTP PUT using Content-Type: application/rdf+xml
15.5.3. SPARQL Insert using LOAD
15.5.4. SPARQL Insert via /sparql endpoint
15.5.5. SPARQL Insert via HTTP Post using Content-Type: application/sparql-query and ODS wiki
15.5.6. Using WebDAV
15.5.7. Using Virtuoso Crawler
15.5.8. Using SPARQL Query and Sponger (i.e. we Sponge the Resources in the FROM Clause or values for the graph-uri parameter in SPARQL protocol URLs)
15.5.9. Using Virtuoso PL APIs
15.5.10. Using SIMILE RDF Bank API
15.5.11. Using RDF NET
15.5.12. Using the RDF Proxy (Sponger) Service
15.6. Integration Middleware
15.6.1. RDFizer Middleware (Sponger)
15.6.2. Enterprise Data Access & Integration
15.6.3. RDF Views over RDBMS Data Source
15.7. Linked Data
15.7.1. IRI Dereferencing For FROM Clauses, "define get:..." Pragmas
15.7.2. IRI Dereferencing For Variables, "define input:grab-..." Pragmas
15.7.3. URL rewriting
15.7.4. Examples of other Protocol Resolvers
15.8. Inference Rules & Reasoning
15.8.1. Introduction
15.8.2. Making Rule Sets
15.8.3. Changing Rule Sets
15.8.4. Subclasses and Subproperties
15.8.5. OWL sameAs Support
15.8.6. Implementation
15.8.7. Enabling Inferencing
15.8.8. Examples
15.9. Performance Tuning
15.9.1. General
15.9.2. Index Scheme Selection
15.9.3. Erroneous Cost Estimates and Explicit Join Order
15.9.4. Loading
15.9.5. Using SPARUL
15.9.6. DBpedia Benchmark
15.9.7. RDF Store Benchmarks
15.10. RDF Data Access Providers (Drivers)
15.10.1. Virtuoso Jena Provider
15.10.2. Virtuoso Sesame Provider
15.10.3. Virtuoso Redland Provider
16. Web Services
16.1. SOAP
16.1.1. Virtuoso SOAP Support Overview
16.1.2. Handling of SOAP HTTP Requests
16.1.3. Extending Datatypes for SOAP Objects
16.1.4. Inheritance of Datatypes for SOAP Objects
16.1.5. Complex Types in PL Procedure and UDT Method Definition
16.1.6. Complex Types in Procedure Definition using a pre-defined XML Schema datatypes
16.1.7. Default SOAP-SQL Datatype Mappings
16.1.8. Exposing Stored Procedures as SOAP Objects
16.1.9. Creation of SOAP proxy based on User Defined Types
16.1.10. Exposing User Defined Type Methods as SOAP Objects
16.1.11. Exposing Remote Third Party SQL Stored Procedures as SOAP Services
16.1.12. Virtuoso/PL SOAP Client
16.1.13. Execution Privileges
16.1.14. Custom Soap Server Support
16.1.15. PL Procedures and UDT Methods Syntax Affecting WSDL & SOAP Processing
16.1.16. Exposing & Processing SOAP Header Messages
16.1.17. Exposing & Processing SOAP Fault Messages
16.1.18. Document Literal Encoding
16.1.19. DIME encapsulation of SOAP messages
16.1.20. SOAP Endpoint Options
16.2. WSDL
16.2.1. Exposing Stored Procedures as WSDL Services
16.2.2. Exposing SQL Stored Procedures containing complex datatype definitions
16.2.3. Exposing Third Party SQL Stored Procedures as WSDL-Compliant Web Services
16.2.4. WSDL Descriptions of SOAP Header Messages
16.2.5. Importing A WSDL File & SOAP/WSDL Proxying
16.2.6. SOAP/WSDL Interoperability
16.3. FOAF+SSL Support
16.3.1. x.509 certificate
16.3.2. Setting up Virtuoso HTTPS
16.3.3. Setting Up Firefox
16.3.4. Configuring ODS Account to use FOAF+SSL
16.3.5. Testing the setup
16.3.6. FOAF+SSL ACLs
16.3.7. CA Keys Import using Conductor
16.3.8. Set Up X.509 certificate issuer, HTTPS listener and generate ODS user's certificates
16.4. OAuth Support
16.4.1. OAuth Access Tokens
16.4.2. Virtuoso OAuth server
16.4.3. OAuth Implementation in OpenLink Data Spaces
16.4.4. OAuth Generate Keys for ODS Controllers (Web Services)
16.4.5. ODS Ubiquity Commands
16.4.6. OAuth Test Tool for ODS Controllers
16.4.7. OAuth QA
16.5. WS-Security (WSS) Support in Virtuoso SOAP Server
16.5.1. Client and Server side Certificates & Keys
16.5.2. SOAP Server WS-Security Endpoint
16.5.3. Virtual Directory SOAP WSS Options
16.5.4. Accounting & Accounting Hook
16.5.5. Signature Templates
16.5.6. SOAP Client
16.6. Web Services Routing Protocol (WS-Routing)
16.6.1. Configuration
16.6.2. Traversing Message Paths
16.7. Web Services Reliable Messaging Protocol (WS-ReliableMessaging)
16.7.1. SOAP CLIENT API Extensions
16.7.2. WS-RM Sender API
16.7.3. WSRM Receiver API
16.7.4. WS-RM Protocol Endpoint Configuration
16.7.5. Message Examples
16.7.6. WS-RM Schema
16.8. Web Services Trust Protocol (WS-Trust)
16.9. XML for Analysis Provider
16.10. XML-RPC support
16.11. SyncML
16.12. UDDI
16.12.1. Concepts
16.12.2. Dealing with SOAP
16.12.3. Supported API Calls
16.12.4. Authorization Mechanism
16.12.5. UDDI API Calls
16.12.6. Examples
16.13. Exposing Persistent Stored Modules as Web Services
16.13.1. Publishing Stored Procedures as Web Services
16.13.2. XML Query Templates
16.13.3. Publishing VSE's as Web Services
16.14. Testing Web Published Web Services
16.15. BPEL Reference
16.15.1. Activities
16.15.2. Protocol Support
16.15.3. Process lifecycle
16.15.4. Using virtual directories
16.15.5. Process archiving
16.15.6. Configuration parameters
16.15.7. Process Statistics
16.15.8. Deployment file suitcase format
16.15.9. SQL API
16.15.10. BPEL XPath Functions
16.15.11. Tables
16.15.12. Errors
16.15.13. Samples
16.15.14. References
16.15.15. BPEL4WS VAD Package installation
16.16. XSQL
16.16.1. XSQL Syntax
16.16.2. XSQL Directives
17. Runtime Hosting
17.1. Runtime Environments
17.2. CLR, .Net & ASPX Host
17.2.1. Environment Setup
17.2.2. Testing the Virtuoso .NET Runtime Environment
17.3. CLR & Mono
17.3.1. Environment Setup
17.3.2. Testing the Virtuoso Mono Runtime Environment
17.4. Embedded Java VM API
17.4.1. Correspondence Between Virtuoso & Java VM Threads
17.4.2. Virtuoso/PL <-> Java VM Type Mapping Schema
17.4.3. References to Java VM Class Instances in Virtuoso/PL
17.4.4. Specifying the Correct Java Type When Passing Values from Virtuoso/PL
17.4.5. Virtuoso Java PL API VSEs
17.4.6. Java Security
17.5. Virtuoso Server Extension Interface (VSEI) (C Interface)
17.5.1. Virtuoso Server Extension Interface (VSEI)
17.5.2. SQL Run Time Objects
17.5.3. Memory Management Rules
17.5.4. Server Main Function
17.5.5. Compiling & Linking
17.5.6. Functions by Category
17.5.7. VSEI Definition
17.5.8. SQL Exceptions
17.5.9. Executing SQL
17.5.10. Adding New Languages And Encodings Into Virtuoso
17.6. VSEI Plugins
18. Internet Services
18.1. WebDAV Server
18.1.2. DAV User Accounts
18.1.3. WebDAV Authentication
18.1.4. WebDAV Symbolic Links
18.1.5. Access Right Permissions of Web Resources
18.1.6. DAV and RDF Metadata
18.1.7. Special Attributes of Web Resources
18.2. URIQA Semantic Web Enabler
18.2.1. URIQA HTTP Methods
18.2.2. URIQA Web Service
18.2.3. URIQA Section in Virtuoso Configuration File
18.2.4. URI Matching Rules
18.3. Mail Delivery & Storage
18.3.1. The SMTP Client
18.3.2. POP3 Server
18.3.3. Storing Email in Virtuoso
18.4. NNTP Newsgroups
18.4.1. NNTP Client
18.4.2. NNTP Server
18.5. MIME & Internet Messages
18.5.1. About Simple Internet (RFC 822) Messages
18.5.2. MIME Messages - Extension to Simple Internet Messages
18.5.3. S/MIME Support
18.6. FTP Services
18.6.1. FTP Client
18.6.2. FTP Server
18.7. VSP Guide
18.7.1. Introduction
18.7.2. Simple HTML FORM usage
18.7.3. Interacting with the Database
18.7.4. The Forums Application
18.8. LDAP
18.8.1. LDAP Client
18.8.2. LDAP Server
19. Free Text Search
19.1. Basic Concepts
19.2. Creating Free Text Indexes
19.2.1. The CREATE TEXT INDEX statement
19.2.2. Choosing An Application Specific Document ID
19.2.3. The composite Data Type
19.2.4. Free Text Index Examples
19.2.5. Pre-processing and Extending the Content Being Indexed
19.2.6. Hit Scores
19.2.7. Word Ranges
19.2.8. Using Offband Data for Faster Filtering
19.2.9. Order of Hits
19.2.10. Noise Words
19.3. Querying Free Text Indexes
19.3.1. CONTAINS predicate
19.3.2. Comments
19.3.3. Text Expression Syntax
19.4. Text Triggers
19.4.1. Creating Text Triggers
19.4.2. Created Database Objects
19.5. Generated Tables and Internals
19.5.1. Generated Tables and Procedures
19.5.2. The procedures are:
19.5.3. Tables and Procedures Created By Text Triggers
19.6. Removing A Text Index
19.7. Removing A Text Trigger
19.8. Internationalization & Unicode
19.9. Performance
19.9.1. Restrictions
19.10. Free Text Functions
20. TPC C Benchmark Kit
20.1. Building the Test Database
20.2. Using the Test Program
20.3. Tuning Parameters and Number of Users
20.4. Omissions, Exceptions from the Definition
20.5. Sample Configuration
20.6. Other Factors
20.7. TPC C Procedures
20.7.1. Introduction
20.7.2. New Order
20.7.3. Payment
20.7.4. Delivery
20.7.5. Order Status
20.7.6. Stock Level
20.8. DDL Statements
20.9. Stored Procedures
21. Using Virtuoso with Tuxedo
21.1. Building the Transaction Manager Server
21.2. Configuration
21.3. Services
21.3.1. Introduction
21.3.2. VQL functions
21.3.3. Services concept
21.3.4. OPENINFO
21.4. Clients
21.5. Service example
22. Appendix
22.1. YACC SQL Grammar Reference
22.2. Error Codes Reference
22.2.1. Virtuoso Error Codes
22.2.2. Data Type Errors
22.3. Release Notes
22.3.1. New Features
22.3.2. Bugs Fixed
22.4. Product Support
22.4.1. OpenLink Discussion Forums
22.5. Virtuoso System Tables
22.5.1. Core System Tables
22.5.2. System Tables
22.5.3. Row Level Security Table
22.5.4. SYS_CHARSETS
22.5.5. Collations System Table
22.5.6. UDDI Schema
22.5.7. Web Robot System Tables
22.5.8. Web Server & DAV System Tables
22.5.9. Mail Table Description
22.5.10. NNTP Server Tables
22.5.11. WS Reliable Messaging
22.5.12. WS Trust
22.5.13. SyncML Schema Objects
22.5.14. INFORMATION_SCHEMA views
22.6. Database Migration Guides
22.6.1. Migration of Virtuoso from Version 2.7 to Version 3.0
22.7. Basic Syntax of Regular Expressions
22.8. Server & client versions compatibility
23. Virtuoso Functions Guide