www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Database
Virtual Database
Virtuoso User Model
VAD - Virtuoso Application Distribution
Data Backup & Recovery
Performance Tuning
Data Access Interfaces
SQL Reference
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

This chapter explains the use of the server executables, configuration files and general administration procedures. These include backup, server tuning and profiling, installing extension packages etc. See the Access Interfaces chapter for a discussion of the command line SQL interface.

Table of Contents

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