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
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

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.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
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.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. Server Administration
6.1. Database
6.1.1. Installation Requirements
6.1.2. Operational Requirements
6.1.3. Operating System Support
6.1.4. Limits
6.1.5. Server Instance Creation
6.1.6. Installing Application Packages
6.1.7. Server Licensing
6.1.8. Server Logging - Detecting Errors
6.1.9. Configuring Server Startup Files
6.1.10. Server Startup Command Line Options
6.1.11. ZeroConfig ("Zero Configuration") Support
6.1.12. Server Status Monitoring
6.1.13. Re-labeling Server Executable on Win32 Platforms
6.1.14. Transport Level Security
6.2. Virtual Database
6.2.1. Linking Remote Tables & Views
6.2.2. Linking Remote Procedures
6.2.3. Data Type Mappings
6.2.4. Transaction Model
6.2.5. Virtual Database and SQL Functions
6.2.6. Virtual Database and SQL Optimizer Statistics
6.2.7. Distributed Query Optimization
6.2.8. Use of Array Parameters
6.2.9. Timestamps & Autoincrement
6.2.10. VDB Stored Procedures & Functions
6.2.11. Manually Setting Up A Remote Data Source
6.2.12. Caveats
6.3. Virtuoso User Model
6.3.1. Security Objects Management
6.3.2. User Options
6.3.3. Login Extension PL Hook
6.3.4. SQL Role Semantics
6.4. VAD - Virtuoso Application Distribution
6.4.1. Summary of VAD Operations
6.4.2. VAD Package Composition
6.4.3. Package Versioning
6.4.4. Processing of Resources
6.4.5. Unsupported Features of VAD
6.4.6. Security
6.4.7. Building VAD Packages
6.4.8. VAD Utilities
6.4.9. VAD Administrator Responsibilities
6.4.10. Package Overlap
6.4.11. VAD Sticker
6.5. Data Backup & Recovery
6.5.1. Log Audit Trail
6.5.2. On-Line Backups
6.5.3. Other Backup Methods
6.5.4. Off-Line Backups
6.5.5. Database Recovery
6.6. Performance Tuning
6.6.1. I/O
6.6.2. Schema Design Considerations
6.6.3. Efficient Use of SQL - SQL Execution profiling
6.6.4. Meters & System Views
6.6.5. Transaction Metrics, Diagnostics and Optimization
7. Virtuoso Cluster Operation
7.1. General
7.1.1. cluster.ini fields
7.2. Setting up a Cluster
7.3. Using Clustering with an Existing Database
7.4. Partitioning
7.4.1. CREATE CLUSTER Statement
7.4.2. ALTER INDEX and CREATE INDEX Statements and Partitioning
7.5. Transactions
7.5.1. Performance Considerations
7.5.2. Row Autocommit Mode
7.6. Administration
7.6.1. Status Display
8. Conductor Administration Interface
8.1. Virtuoso Conductor Administration
8.2. Runtime Hosting
8.2.1. Loaded Modules
8.2.2. Import Files
8.2.3. Modules Grants
8.3. Web Services
8.3.1. Import Targets
8.3.2. Import Queues
8.3.3. Retrieved Sites
8.3.4. Export
8.3.5. Access Control
8.3.6. Import WSDL
8.4. WebDAV Administration
8.4.1. DAV Resource Types
8.4.2. Content Management
8.4.3. Free Text
8.5. Internet Domains
8.5.1. HTTP Virtual Directories
8.6. XML Services
8.6.1. SQL-XML Statements
8.6.2. XQuery Search
8.7. Query Tools
8.7.1. Relational Data using SQL
8.7.2. XML Data Using XQuery
8.8. Replication & Synchronization
8.8.1. Snapshot Replication
8.8.2. Transactional Replication
8.9. Database Administration
8.9.1. Users & Group Accounts
8.9.2. Databases
8.9.3. External Data Sources
8.9.4. Event Scheduler
8.9.5. Virtuoso Configuration Editor
8.9.6. Dashboard and Monitor
8.10. Conductor News Server Administration
8.10.1. Conductor Newsgroups Administration
8.10.2. News Message Free Text Search
9. Data Access Interfaces
9.1. Virtuoso .NET Data Provider
9.1.2. VirtDbType Enumeration
9.1.3. VirtuosoCommand Class
9.1.4. VirtuosoCommandBuilder Class
9.1.5. VirtuosoConnection Class
9.1.6. VirtuosoDataAdapter Class
9.1.7. VirtuosoDataReader Class
9.1.8. VirtuosoError Class
9.1.9. VirtuosoErrorCollection Class
9.1.10. VirtuosoException Class
9.1.11. VirtuosoInfoMessageEventArgs Class
9.1.12. VirtuosoInfoMessageEventHandler Delegate
9.1.13. VirtuosoParameter Class
9.1.14. VirtuosoParameterCollection Class
9.1.15. VirtuosoPermission Class
9.1.16. VirtuosoPermissionAttribute
9.1.17. VirtuosoRowUpdatedEventArgs Class
9.1.18. VirtuosoRowUpdatedEventHandler Delegate
9.1.19. VirtuosoRowUpdatingEventArgs Class
9.1.20. VirtuosoRowUpdatingEventHandler Delegate
9.1.21. VirtuosoTransaction Class
9.2. Interactive SQL Utility
9.2.1. Invoking ISQL
9.2.2. ISQL Commands
9.2.3. ISQL Macro Substitution
9.2.4. ISQL Variables
9.2.5. Using isql as a General Purpose Test Driver
9.3. Virtuoso Driver for ODBC
9.3.1. Windows ODBC Driver Configuration
9.3.2. Using X509 Certificates With ODBC Connection
9.3.3. ODBC Compliance
9.3.4. Virtuoso Scrollable Cursor Engine
9.3.5. Effect of Connection & Statement Options
9.3.6. Efficient Use of API
9.4. Virtuoso Driver for JDBC
9.4.1. Virtuoso Drivers for JDBC Packaging
9.4.2. Virtuoso Driver For JDBC URL Format
9.4.3. Virtuoso Driver JDBC 3.0 features
9.4.4. Installation & Configuration Steps
9.5. OLE DB Provider for Virtuoso
9.5.1. Using the OLE DB Provider for Virtuoso
9.5.2. Known Limitations
9.5.3. Data Types
9.5.4. Metadata
9.5.5. Supported Interfaces
9.5.6. Data Source Objects
9.5.7. Sessions
9.5.8. Rowsets
9.6. Virtuoso In-Process Client
9.7. Unix Domain Socket Connections
10. SQL Reference
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
11. Virtuoso Cluster Programming
11.1. Cluster SQL Execution Model
11.2. Sequences, Identity and Registry
11.3. SQL Options
11.3.1. Parallel INSERT Options
11.3.2. INSERT KEY Option
11.4. Calling Procedures in Cluster
11.5. Partition Functions
11.6. Distributed Pipe
11.6.1. SQL optimization and Dpipe
11.7. Cluster and RDF
11.8. Cluster, Virtual Database and Replication
11.9. Limitations of Alpha 6.0
11.10. Troubleshooting
12. SQL Procedure Language Guide
12.1. General Principles
12.2. Scope of Declarations
12.3. Data Types
12.4. Handling Result Sets
12.5. Result Sets and Array Parameters
12.6. Exception Semantics
12.7. Virtuoso/PL Syntax
12.7.1. Create Procedure Statement
12.7.2. Stored Procedures as Views & Derived Tables
12.7.3. Keyword and Optional Procedure Arguments
12.7.4. if, while, for, foreach statements
12.7.5. compound statement
12.7.6. goto, return statements
12.7.7. whenever statement
12.7.8. call, assignment statements
12.7.9. open, fetch, close, select ... into statements
12.7.10. FOR Select Statement
12.7.11. SET statement
12.7.12. SET Triggers
12.8. Execute Stored Procedures via SELECT statement
12.9. CREATE ASSEMBLY Syntax - External Libraries
12.10. CREATE PROCEDURE Syntax - External hosted procedures
12.11. Asynchronous Execution and Multithreading in Virtuoso/PL
12.11.1. Synchronization
12.12. Performance Tips
12.12.1. Remember the following:
12.13. Procedures and Transactions
12.14. Distributed Transaction & Two Phase Commit
12.14.1. Initiating Distributed Transactions
12.14.2. Responding to Distributed Transactions
12.14.3. 2PC Log & Recovery
12.14.4. Error Codes
12.15. Triggers
12.15.1. The CREATE TRIGGER statement
12.15.2. Triggers on Views
12.15.3. The DROP TRIGGER statement
12.15.4. Triggers and Virtual Database
12.16. Character Escaping
12.16.1. Statement Level
12.16.2. Connection Level
12.16.3. Server Default
12.17. Virtuoso/PL Scrollable Cursors
12.17.1. Declaring a Scrollable Cursor
12.17.2. Opening a Scrollable Cursor
12.17.3. Fetching Data From a Scrollable Cursor
12.17.4. Virtuoso/PL Scrollable Cursor Examples
12.17.5. FORWARD-ONLY (traditional cursor statement) Example
12.17.6. DYNAMIC (traditional cursor statement) Example
12.17.7. KEYSET (traditional cursor statement) Example
12.18. Virtuoso PL Modules
12.18.1. Syntax
12.18.2. Security
12.19. Handling Conditions In Virtuoso/PL Procedures
12.19.1. Declaring Condition Handlers
12.19.2. Stack Trace Reporting On Sql Error Generation
12.20. Procedure Language Debugger
12.20.1. Branch Coverage
12.20.2. Coverage Functions
12.21. Row Level Security
12.21.1. Row Level Security Functions
13. Database Event Hooks
13.1. Database Startup
13.2. Database Connections
13.3. Database Logins
13.4. Database Disconnections
13.5. Database Shutdown
13.6. SQL Statement Preparation
13.7. SQL Parse Tree
13.7.1. Notes on Special Features of the Parse Tree
13.7.2. SQL Security and Parse Trees
13.7.3. Debugging with Parse Trees
13.8. WebDAV Logins
13.9. Associating Auxiliary Data With A Connection
14. Data Replication, Synchronization and Transformation Services
14.1. Introduction
14.1.1. Snapshot replication
14.1.2. Transactional replication
14.2. Snapshot Replication
14.2.1. Non incremental snapshot replication
14.2.2. Incremental snapshot replication
14.2.3. Command reference
14.2.4. Bi-Directional Snapshot Replication
14.2.5. Registry variables
14.2.6. Heterogeneous snapshot replication
14.2.7. Data type mappings
14.2.8. Objects created by incremental snapshot replication
14.2.9. Objects created by bi-directional snapshot replication
14.2.10. Replication system tables
14.2.11. Table snapshot logs
14.3. Transactional Replication
14.3.1. Publishable Items
14.3.2. Errors in Replication
14.3.3. Publisher Transactional Replication Functions
14.3.4. Subscriber Functions
14.3.5. Common Status Functions
14.3.6. Bi-Directional Transactional Replication
14.3.7. Purging replication logs
14.3.8. Objects created by transactional replication
14.4. Virtuoso scheduler
14.4.1. SYS_SCHEDULED_EVENT
14.5. Transactional Replication Example
14.5.1. Transactional Replication Objects Example
14.6. Replication Logger Sample
14.6.1. Configuration of the Sample
14.6.2. Synchronization
14.6.3. Running the Sample
14.6.4. Notes on the Sample's Dynamics
15. Web Application Development
15.1. The HTTP Server
15.1.2. HTTP Server Base Configuration
15.1.3. Virtual Directories
15.1.4. Authentication
15.1.5. Session Management
15.1.6. Writing Your Own Authentication and Session Handling
15.1.7. Cancellation of Web Requests
15.1.8. Virtuoso WebRobot API
15.1.9. HTTP Server Extensions
15.1.10. Chunked Transfer Encoding
15.1.11. Using Virtuoso Server capabilities via Apache Web Server
15.2. Web Services ACL (Access Control List)
15.2.1. General purpose ACLs
15.2.2. ACL Definition/Removal
15.2.3. Using ACL's Within Application Logic
15.2.4. Predefined ACLs
15.3. Virtuoso Server Pages (VSP)
15.3.2. VSP Markup & Basic Functions
15.3.3. Access Request Information
15.3.4. Errors in Page Procedures
15.3.5. /INLINEFILE HTTP Server Pseudo-Directory
15.3.6. Beyond Basics
15.3.7. Long HTTP Transactions
15.3.8. Using chunked encoding in HTTP 1.1
15.3.9. Making Simple Dynamic Web Pages
15.3.10. Generation of non-HTML output
15.3.11. Post VSP XSLT Transformation Mode
15.3.12. XML & XSLT Generated VSP Pages
15.4. Virtuoso Server Pages for XML (VSPX)
15.4.1. Processing Model
15.4.2. Object Model
15.4.3. Keeping Page and Session State
15.4.4. Application Code
15.4.5. A Simple Example
15.4.6. VSPX Event Handler Parameters
15.4.7. Registering a VSPX Event Callbacks
15.4.8. Commonly Used Types of Attributes of VSPX Controls
15.4.9. VSPX Controls
15.4.10. XForms rendering
15.4.11. XMLSchema for VSPX page
15.5. Deploying ASP.Net Web Applications
15.5.2. Programming Concepts
15.5.3. ASP.Net Deployment & Configuration
15.5.4. The Mono Project
15.5.5. Migrating ASP.Net Applications to Virtuoso
15.6. ASMX Web Service Hosting
15.7. Blogging & Weblogs
15.7.1. The Virtuoso Blogging Application
15.7.2. Blogger Clients Compatibility
15.7.3. Blogs Management User Interface
15.7.4. Community Blog Site
15.7.5. Blogger API
15.7.6. MetaWeblog API
15.7.7. Movable Type API
15.7.8. Atom API
15.7.9. XML-RPC Endpoint Configuration
15.7.10. Blog Hooks - Customizing the Blog Server
15.7.11. Blogger Client API
15.7.12. xmlStorageSystem API
15.7.13. User's Blog quota
15.7.14. Posting a message in to the Blog
15.7.15. Multi-author blogging
15.7.16. Posting a comments
15.7.17. Blog Post Upstreaming (bridging)
15.7.18. Weblogs API
15.7.19. Subscriptions
15.7.20. Trackback API
15.7.21. Pingback API
15.7.22. E-mail Notifications
15.7.23. Comments tracking options
15.7.24. Subscription Harmonizer API
15.7.25. Mobile Blogging (Moblog)
15.7.26. Posting a dynamic content
15.7.27. Notification Services
15.7.28. Rendering the RSS feed in WML format
15.8. Deploying PHP Applications
15.8.2. Building the Virtuoso Server With PHP Extension
15.8.3. PHP Extension Functions
15.8.4. PHP Examples
15.9. Deploying JSP Applications
15.9.2. Environment Setup & Verification
15.10. Perl Hosting
15.11. Python Hosting
15.12. Ruby Hosting
16. XML Support
16.1. Rendering SQL Queries as XML (FOR XML Clause)
16.1.1. FOR XML EXPLICIT Mode
16.1.2. Examples of FOR XML
16.1.3. Functions
16.1.4. FOR XML Syntax
16.2. XML Composing Functions in SQL Statements (SQLX)
16.3. Virtuoso XML Services
16.3.1. XPATH Implementation and SQL
16.3.2. XPATH Query Options
16.3.3. XML Views - Representing SQL Data as Dynamic and Persistent XML
16.3.4. External Entity References in Stored XML
16.3.5. Using XPATH in SQL Queries and Procedures
16.3.6. XQUERY and XML view
16.3.7. Mapping Schemas as XML Views
16.3.8. Differences Between SQLX, FOR XML and XML Views
16.4. Querying Stored XML Data
16.4.1. XPATH_CONTAINS SQL Predicate
16.4.2. Using xpath_eval()
16.4.3. External Entity References in Stored XML
16.4.4. XML Schema & DTD Functions
16.4.5. Using XML and Free Text
16.4.6. XCONTAINS predicate
16.4.7. text-contains XPath Predicate
16.4.8. XML Free Text Indexing Rules
16.4.9. XML Processing & Free Text Encoding Issues
16.5. Using UpdateGrams to Modify Data
16.5.1. Updategrams Basics
16.5.2. Elements Description
16.5.3. Determining Actions
16.5.4. Using Input Parameters
16.5.5. Examples
16.6. XML Templates
16.6.2. Syntax
16.6.3. Saving SQL Queries to XML Template
16.6.4. Saving XQUERY Queries to XML Template
16.6.5. Saving XPATH Queries to XML Template
16.6.6. Programmatic Examples
16.7. XML DTD and XML Schemas
16.7.1. XML Document Type Definition (DTD)
16.7.2. Configuration Options of the DTD Validator
16.7.3. XML Schema Definition Language
16.7.4. XML Schema Functions
16.7.5. XML Schema & SOAP
16.8. XQuery 1.0 Support
16.8.1. Types of XQuery Expressions
16.8.2. Details of XQuery Syntax
16.8.3. Pre-compilation of XPath and XQuery Expressions
16.9. XSLT Transformation
16.9.1. Namespaces
16.9.2. The <xsl:output> Tag
16.9.3. External Parameters in XSLT Stylesheets
16.9.4. Functions
16.9.5. XSLT Examples
16.9.6. XPath Function Extensions for XSLT
16.9.7. Status Of XSLT And XPath Implementation
16.10. XMLType
16.11. Changing XML entities in DOM style
16.11.1. Composing Document Fragments From DOM Function Arguments
17. RDF Database and SPARQL
17.1. Data Representation
17.1.1. IRI_ID Type
17.1.2. RDF_QUAD and other tables
17.1.3. Short, Long and SQL Values
17.1.4. Special Cases and XML Schema Compatibility
17.1.5. SQL Compiler Support - QUIETCAST option
17.2. RDF and SPARQL API and SQL
17.2.1. SPARQL Inline in SQL
17.2.2. API Functions
17.2.3. Useful Internal Functions
17.2.4. Default and Named Graphs
17.2.5. Calling SQL from SPARQL
17.3. SPARUL -- an Update Language For RDF Graphs
17.3.1. Introduction
17.3.2. Manage RDF Storage
17.3.3. Examples
17.3.4. More Detailed Examples
17.4. Dereferencable IRIs and RDF Linked Data
17.4.1. IRI Dereferencing For FROM Clauses, "define get:..." Pragmas
17.4.2. IRI Dereferencing For Variables, "define input:grab-..." Pragmas
17.4.3. Examples of other Web Resolvers
17.5. RDF Views -- Mapping Relational Data to RDF
17.5.1. Introduction
17.5.2. Rationale
17.5.3. Quad Map Patterns, Value and IRI Classes
17.5.4. Configuring RDF Storages
17.5.5. Translation Of SPARQL Triple Patterns To Quad Map Patterns
17.5.6. Describing Source Relational Tables
17.5.7. RDF Metadata Maintenance and Recovery
17.6. SPARQL Implementation
17.6.1. SPARQL and XQuery
17.7. RDF Inference in Virtuoso
17.7.1. Introduction
17.7.2. Making Rule Sets
17.7.3. Changing Rule Sets
17.7.4. Subclasses and Subproperties
17.7.5. OWL same-as Support
17.7.6. Implementation
17.7.7. Enabling Inference
17.7.8. Examples
17.8. Using Full Text Search in SPARQL
17.8.1. Specifying What to Index
17.8.2. Time of Indexing
17.8.3. Free-Text Indexes on RDF Views
17.9. Aggregates in SPARQL
17.9.1. Examples
17.9.2. Note on Aggregates and Inference
17.10. Virtuoso SPARQL Query Service
17.10.1. Introduction
17.10.2. Service Endpoint
17.10.3. Request Methods
17.10.4. Functions
17.10.5. Request Parameters
17.10.6. Response Codes
17.10.7. Response Format
17.10.8. Additional Response Formats -- SELECT
17.10.9. Examples
17.10.10. Implementation Notes
17.10.11. Virtuoso Semantic Bank end point
17.10.12. RDF proxy service
17.10.13. SPARQL ini service
17.11. Virtuoso RDF Performance Tuning
17.11.1. General
17.11.2. Loading
17.11.3. Using SPARUL
17.12. RDF Insert Methods in Virtuoso
17.12.1. HTTP Post using Content-Type: application/sparql-query
17.12.2. HTTP PUT using Content-Type: application/rdf+xml
17.12.3. SPARQL Insert using LOAD
17.12.4. SPARQL Insert via /sparql endpoint
17.12.5. SPARQL Insert via HTTP Post using Content-Type: application/sparql-query and ODS wiki
17.12.6. Using WebDAV
17.12.7. Using Virtuoso Crawler
17.12.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)
17.12.9. Using Virtuoso PL APIs
17.12.10. Using SIMILE RDF Bank API
17.12.11. Using RDF NET
17.13. RDF Store Benchmarks
17.13.1. Introduction
17.13.2. Using bitmap indexes
17.14. Virtuoso Sponger
17.14.1. Virtuoso Cartridge-Supported Data Sources
17.14.2. Virtuoso Sponger Cartridge RDF Extractor
17.14.3. Extending SPARQL IRI Dereferencing with RDF Mappers
18. Web Services
18.1. SOAP
18.1.1. Virtuoso SOAP Support Overview
18.1.2. Handling of SOAP HTTP Requests
18.1.3. Extending Datatypes for SOAP Objects
18.1.4. Inheritance of Datatypes for SOAP Objects
18.1.5. Complex Types in PL Procedure and UDT Method Definition
18.1.6. Complex Types in Procedure Definition using a pre-defined XML Schema datatypes
18.1.7. Default SOAP-SQL Datatype Mappings
18.1.8. Exposing Stored Procedures as SOAP Objects
18.1.9. Creation of SOAP proxy based on User Defined Types
18.1.10. Exposing User Defined Type Methods as SOAP Objects
18.1.11. Exposing Remote Third Party SQL Stored Procedures as SOAP Services
18.1.12. Virtuoso/PL SOAP Client
18.1.13. Execution Privileges
18.1.14. Custom Soap Server Support
18.1.15. PL Procedures and UDT Methods Syntax Affecting WSDL & SOAP Processing
18.1.16. Exposing & Processing SOAP Header Messages
18.1.17. Exposing & Processing SOAP Fault Messages
18.1.18. Document Literal Encoding
18.1.19. DIME encapsulation of SOAP messages
18.1.20. SOAP Endpoint Options
18.2. WSDL
18.2.1. Exposing Stored Procedures as WSDL Services
18.2.2. Exposing SQL Stored Procedures containing complex datatype definitions
18.2.3. Exposing Third Party SQL Stored Procedures as WSDL-Compliant Web Services
18.2.4. WSDL Descriptions of SOAP Header Messages
18.2.5. Importing A WSDL File & SOAP/WSDL Proxying
18.2.6. SOAP/WSDL Interoperability
18.3. WS-Security (WSS) Support in Virtuoso SOAP Server
18.3.1. Client and Server side Certificates & Keys
18.3.2. SOAP Server WS-Security Endpoint
18.3.3. Virtual Directory SOAP WSS Options
18.3.4. Accounting & Accounting Hook
18.3.5. Signature Templates
18.3.6. SOAP Client
18.4. Web Services Routing Protocol (WS-Routing)
18.4.1. Configuration
18.4.2. Traversing Message Paths
18.5. Web Services Reliable Messaging Protocol (WS-ReliableMessaging)
18.5.1. SOAP CLIENT API Extensions
18.5.2. WS-RM Sender API
18.5.3. WSRM Receiver API
18.5.4. WS-RM Protocol Endpoint Configuration
18.5.5. Message Examples
18.5.6. WS-RM Schema
18.6. Web Services Trust Protocol (WS-Trust)
18.7. XML for Analysis Provider
18.8. XML-RPC support
18.9. SyncML
18.10. UDDI
18.10.1. Concepts
18.10.2. Dealing with SOAP
18.10.3. Supported API Calls
18.10.4. Authorization Mechanism
18.10.5. UDDI API Calls
18.10.6. Examples
18.11. Exposing Persistent Stored Modules as Web Services
18.11.1. Publishing Stored Procedures as Web Services
18.11.2. XML Query Templates
18.11.3. Publishing VSE's as Web Services
18.12. Testing Web Published Web Services
18.13. BPEL Reference
18.13.1. Activities
18.13.2. Protocol Support
18.13.3. Process lifecycle
18.13.4. Using virtual directories
18.13.5. Process archiving
18.13.6. Configuration parameters
18.13.7. Process Statistics
18.13.8. Deployment file suitcase format
18.13.9. SQL API
18.13.10. BPEL XPath Functions
18.13.11. Tables
18.13.12. Errors
18.13.13. Samples
18.13.14. References
18.13.15. BPEL4WS VAD Package installation
18.14. XSQL
18.14.1. XSQL Syntax
18.14.2. XSQL Directives
19. Runtime Hosting
19.1. Runtime Environments
19.2. CLR, .Net & ASPX Host
19.2.1. Environment Setup
19.2.2. Testing the Virtuoso .NET Runtime Environment
19.3. CLR & Mono
19.3.1. Environment Setup
19.3.2. Testing the Virtuoso Mono Runtime Environment
19.4. Embedded Java VM API
19.4.1. Correspondence Between Virtuoso & Java VM Threads
19.4.2. Virtuoso/PL <-> Java VM Type Mapping Schema
19.4.3. References to Java VM Class Instances in Virtuoso/PL
19.4.4. Specifying the Correct Java Type When Passing Values from Virtuoso/PL
19.4.5. Virtuoso Java PL API VSEs
19.4.6. Java Security
19.5. Virtuoso Server Extension Interface (VSEI) (C Interface)
19.5.1. Virtuoso Server Extension Interface (VSEI)
19.5.2. SQL Run Time Objects
19.5.3. Memory Management Rules
19.5.4. Server Main Function
19.5.5. Compiling & Linking
19.5.6. Functions by Category
19.5.7. VSEI Definition
19.5.8. SQL Exceptions
19.5.9. Executing SQL
19.5.10. Adding New Languages And Encodings Into Virtuoso
19.6. VSEI Plugins
20. Internet Services
20.1. WebDAV Server
20.1.2. DAV User Accounts
20.1.3. WebDAV Authentication
20.1.4. WebDAV Symbolic Links
20.1.5. Access Right Permissions of Web Resources
20.1.6. DAV and RDF Metadata
20.1.7. Special Attributes of Web Resources
20.2. URIQA Semantic Web Enabler
20.2.1. URIQA HTTP Methods
20.2.2. URIQA Web Service
20.2.3. URIQA Section in Virtuoso Configuration File
20.2.4. URI Matching Rules
20.3. Mail Delivery & Storage
20.3.1. The SMTP Client
20.3.2. POP3 Server
20.3.3. Storing Email in Virtuoso
20.4. NNTP Newsgroups
20.4.1. NNTP Client
20.4.2. NNTP Server
20.5. MIME & Internet Messages
20.5.1. About Simple Internet (RFC 822) Messages
20.5.2. MIME Messages - Extension to Simple Internet Messages
20.5.3. S/MIME Support
20.6. FTP Services
20.6.1. FTP Client
20.6.2. FTP Server
20.7. VSP Guide
20.7.1. Introduction
20.7.2. Simple HTML FORM usage
20.7.3. Interacting with the Database
20.7.4. The Forums Application
20.8. LDAP
20.8.1. LDAP Client
20.8.2. LDAP Server
21. Free Text Search
21.1. Basic Concepts
21.2. Creating Free Text Indexes
21.2.1. The CREATE TEXT INDEX statement
21.2.2. Choosing An Application Specific Document ID
21.2.3. The composite Data Type
21.2.4. Free Text Index Examples
21.2.5. Pre-processing and Extending the Content Being Indexed
21.2.6. Hit Scores
21.2.7. Word Ranges
21.2.8. Using Offband Data for Faster Filtering
21.2.9. Order of Hits
21.2.10. Noise Words
21.3. Querying Free Text Indexes
21.3.1. CONTAINS predicate
21.3.2. Comments
21.3.3. Text Expression Syntax
21.4. Text Triggers
21.4.1. Creating Text Triggers
21.4.2. Created Database Objects
21.5. Generated Tables and Internals
21.5.1. Generated Tables and Procedures
21.5.2. The procedures are:
21.5.3. Tables and Procedures Created By Text Triggers
21.6. Removing A Text Index
21.7. Removing A Text Trigger
21.8. Internationalization & Unicode
21.9. Performance
21.9.1. Restrictions
21.10. Free Text Functions
22. TPC C Benchmark Kit
22.1. Building the Test Database
22.2. Using the Test Program
22.3. Tuning Parameters and Number of Users
22.4. Omissions, Exceptions from the Definition
22.5. Sample Configuration
22.6. Other Factors
22.7. TPC C Procedures
22.7.1. Introduction
22.7.2. New Order
22.7.3. Payment
22.7.4. Delivery
22.7.5. Order Status
22.7.6. Stock Level
22.8. DDL Statements
22.9. Stored Procedures
23. Using Virtuoso with Tuxedo
23.1. Building the Transaction Manager Server
23.2. Configuration
23.3. Services
23.3.1. Introduction
23.3.2. VQL functions
23.3.3. Services concept
23.3.4. OPENINFO
23.4. Clients
23.5. Service example
24. Appendix
24.1. YACC SQL Grammar Reference
24.2. Error Codes Reference
24.2.1. Virtuoso Error Codes
24.2.2. Data Type Errors
24.3. Release Notes
24.3.1. New Features
24.3.2. Bugs Fixed
24.4. Product Support
24.4.1. OpenLink Discussion Forums
24.5. Virtuoso System Tables
24.5.1. Core System Tables
24.5.2. System Tables
24.5.3. Row Level Security Table
24.5.4. SYS_CHARSETS
24.5.5. Collations System Table
24.5.6. UDDI Schema
24.5.7. Web Robot System Tables
24.5.8. Web Server & DAV System Tables
24.5.9. Mail Table Description
24.5.10. NNTP Server Tables
24.5.11. WS Reliable Messaging
24.5.12. WS Trust
24.5.13. SyncML Schema Objects
24.5.14. INFORMATION_SCHEMA views
24.6.
24.6.1. Migration of Virtuoso from Version 2.7 to Version 3.0
24.7. Basic Syntax of Regular Expressions
24.8. Server & client versions compatibility
25. Virtuoso Functions Guide