Contents

• Contents
• List of Figures
• List of Tables
• 1. Introduction
  • 1.1 Documentation Conventions
  • 1.2 Salient Features
  • 1.3 New Features
  • 1.4 Coming Soon ...
  • 1.5 Types of users
  • 1.6 Related Reading
  • 1.7 Ovrimos Welcomes your Comments
• 2. Installation
  • 2.1 Unix Installation
    • 2.1.1 FreeBSD Installation
  • 2.2 Windows NT / Windows 2000 Installation
  • 2.3 Post-installation tasks
    • 2.3.1 Populating testbase (optional)
    • 2.3.2 Familiarizing yourself with the basics of working with Ovrimos
    • 2.3.3 Accessing Database Manager
    • 2.3.4 Ovrimos registration and licensing
  • 2.4 Upgrade Installation
  • 2.5 Uninstalling Ovrimos
    • 2.5.1 Unix
    • 2.5.2 Windows NT / Windows 2000
• 3. Ovrimos Components
  • 3.1 Ovrimos at a glance
  • 3.2 The Ovrimos Server
    • 3.2.1 The SQL Server
    • 3.2.2 The HTTP Server
    • 3.2.3 Database Manager
    • 3.2.4 SQL Terminal
    • 3.2.5 Roadmap
    • 3.2.6 Administrator Console
  • 3.3 The SQL Query Tool
  • 3.4 The ODBC Interface
  • 3.5 The JDBC Interface
  • 3.6 Users favorite languages
    • 3.6.1 C, C++
    • 3.6.2 Perl
    • 3.6.3 Scheme
  • 3.7 Database Connections
    • 3.7.1 What is a connection
• 4. Database Manager
  • 4.1 Overview
  • 4.2 Starting and Stopping Database Manager
  • 4.3 Accessing Database Manager
  • 4.4 Database Manager and SSL
  • 4.5 Certificate Manager
    • 4.5.1 New Ovrimos CA Certificate Request
    • 4.5.2 New Ovrimos Server Certificate Request
    • 4.5.3 New Netscape/Explorer Certificate Request
    • 4.5.4 Certificate Requests
    • 4.5.5 Local Certification Authorities
    • 4.5.6 Importing a Certificate
  • 4.6 Database Manager Configuration
  • 4.7 Starting up and Shutting down a Database
  • 4.8 Database Creation
    • 4.8.1 How to create a database
  • 4.9 Database Configuration
    • 4.9.1 SQL Server Parameters
    • 4.9.2 HTTP Server Parameters
    • 4.9.3 Password Parameters
    • 4.9.4 Fine Tuning Parameters
    • 4.9.5 Miscellaneous Parameters
    • 4.9.6 SSL Parameters
  • 4.10 Database Deletion
  • 4.11 Changing the dbman password
  • 4.12 Editing the serial number and license
  • 4.13 Database Manager Error Log
• 5. SQL Terminal
  • 5.1 Overview
  • 5.2 Operating SQL Terminal
    • 5.2.1 SQL transactions
    • 5.2.2 Uploading SQL Scripts
    • 5.2.3 Internet queries in MS Excel
  • 5.3 Disconnecting and Reconnecting to the database
• 6. Roadmap
  • 6.1 Overview
  • 6.2 Viewing information on the Roadmap
  • 6.3 Logging in as another user
• 7. Administrator's Console
  • 7.1 Overview
  • 7.2 Operation
    • 7.2.1 Error Log
    • 7.2.2 Connections
    • 7.2.3 HTTP Sessions
    • 7.2.4 Fibers
• 8. The HTTP server
  • 8.1 Overview
  • 8.2 Ovrimos URL-space
  • 8.3 Static Web Content
  • 8.4 Dynamic Internal Resources
  • 8.5 Dynamic External Resources
    • 8.5.1 SQL Scripts
    • 8.5.2 Scheme Scripts
    • 8.5.3 HTTP Server and Persistent Sessions
    • 8.5.4 CGI 1.2
    • 8.5.5 Using CGI 1.2 for persistent HTTP sessions
    • 8.5.6 CGI 1.2 environment
    • 8.5.7 Gateway Program Output
  • 8.6 Appendix: Scheme
  • 8.7 HTTP Log
  • 8.8 Demo bookstore: An example of a Scheme script
• 9. SQL Query Tool
  • 9.1 Overview
  • 9.2 Operating SQL Query Tool
  • 9.3 Executing SQL statements interactively
  • 9.4 Executing SQL scripts
  • 9.5 Cursors and Navigation
  • 9.6 HTML output from SQL Query Tool
    • 9.6.1 How to produce HTML output from SQL Query Tool
• 10. Connectivity
  • 10.1 ODBC
    • 10.1.1 ODBC driver installation
  • 10.2 JDBC
    • 10.2.1 A JDBC example
  • 10.3 DBI
    • 10.3.1 A Perl example
  • 10.4 Ovrimos PHP DRIVER
    • 10.4.1 API functions
  • 10.5 Stored Procedures
    • 10.5.1 Perl Stored Procedures
    • 10.5.2 Java Stored Procedures
• 11. Replication
  • 11.1 Overview
  • 11.2 Introducing Replicator
  • 11.3 What you can do with Replicator
  • 11.4 Replicator commands
• 12. Database Maintenance
  • 12.1 Database Backup
  • 12.2 Database Recovery
  • 12.3 Periodic Maintenance
• 13. Database Security
  • 13.1 Data Integrity
    • 13.1.1 Semantic Integrity
    • 13.1.2 Transaction Atomicity
  • 13.2 Data Recovery
  • 13.3 Data Encryption
  • 13.4 Authentication
    • 13.4.1 Login Authentication
    • 13.4.2 Passwords and Password Policy
    • 13.4.3 Unauthorized Logins
    • 13.4.4 User Privileges
    • 13.4.5 Privilege Inheritance
  • 13.5 Secure Socket Layer
    • 13.5.1 Local Certification Authorities
• 14. Ovrimos Files and Configuration Parameters
  • 14.1 Files that Ovrimos uses
  • 14.2 Configuration Parameters
    • 14.2.1 Global Parameters
    • 14.2.2 Database Parameters
• 15. Ovrimos SQL
  • 15.1 Supported Data Types
    • 15.1.1 Expressions
    • 15.1.2 SQL parameters
  • 15.2 Keywords
  • 15.3 Sample Data
  • 15.4 Supported SQL Statements
    • 15.4.1 Definition Grammar
    • 15.4.2 Statement Description
    • 15.4.3 Aggregate Functions
  • 15.5 Standard SQL Functions
  • 15.6 Supplemental SQL Functions
    • 15.6.1 Mathematical functions
    • 15.6.2 Date and Time functions
    • 15.6.3 String manipulation functions
  • 15.7 System functions
  • 15.8 Regular Expression functions
• 16. Ovrimos SQL
  • 16.1 Supported Data Types
    • 16.1.1 Expressions
    • 16.1.2 SQL parameters
  • 16.2 Keywords
  • 16.3 Sample Data
  • 16.4 Supported SQL Statements
    • 16.4.1 Definition Grammar
    • 16.4.2 Statement Description
    • 16.4.3 Aggregate Functions
  • 16.5 Standard SQL Functions
  • 16.6 Supplemental SQL Functions
    • 16.6.1 Mathematical functions
    • 16.6.2 Date and Time functions
    • 16.6.3 String manipulation functions
  • 16.7 System functions
  • 16.8 Regular Expression functions
• 17. Ovrimos SQL
  • 17.1 Supported Data Types
    • 17.1.1 Expressions
    • 17.1.2 SQL parameters
  • 17.2 Keywords
  • 17.3 Sample Data
  • 17.4 Supported SQL Statements
    • 17.4.1 Definition Grammar
    • 17.4.2 Statement Description
    • 17.4.3 Aggregate Functions
  • 17.5 Standard SQL Functions
  • 17.6 Supplemental SQL Functions
    • 17.6.1 Mathematical functions
    • 17.6.2 Date and Time functions
    • 17.6.3 String manipulation functions
  • 17.7 System functions
  • 17.8 Regular Expression functions
  • 17.9 BLOBs and the URI function
    • 17.9.1 BLOB Reference Manipulation Functions
  • 17.10 Storage and Retrieval of Unicode Data
    • 17.10.1 Inserting Unicode data
    • 17.10.2 Displaying Unicode data
  • 17.11 Ovrimos databases
    • 17.11.1 Database schemas
    • 17.11.2 System tables
    • 17.11.3 Initial Users
  • 17.12 Bulk Updates
• 18. Persistent Stored Modules
  • 18.1 Overview
  • 18.2 Routines and Modules
    • 18.2.1 Routine Definition and Examples
    • 18.2.2 Module Definition and Examples
    • 18.2.3 Routine and Module Destruction
    • 18.2.4 The EXECUTE Privilege
  • 18.3 SQL Control Statements
    • 18.3.1 Flow Control Statements
    • 18.3.2 Compound Statements
    • 18.3.3 Programming Constructs
  • 18.4 Miscellaneous Topics
    • 18.4.1 Default SPECIFIC names
• 19. Triggers
  • 19.1 Overview
  • 19.2 Introducing Triggers
• 20. Examples and Utilities
  • 20.1 User-provided ciphers
    • 20.1.1 Cipher example
  • 20.2 C and C++ Examples
    • 20.2.1 C, C++ Stored Procedures
• 21. Events
• 22. Ovrimos Error Messages
• Index