Show pagesource

Old revisions

This is an old revision of the document!

Home	TOC	Quick Items	Doc Map	Quick Links

Omnidex Version 5.0 Table of Contents

Overview

What is Omnidex? <tab>(TODO)
Omnidex Architecture <tab>(TODO)
Quick Start Guide <tab>(TODO)
Using Omnidex: Customer Lists <tab>(TODO)
Using Omnidex: Business Analytics <tab>(TODO)
Using Omnidex: Transaction Logs <tab>(TODO)
Using Omnidex: Flat File Databases <tab>(TODO)
Using Omnidex: Text Databases <tab>(TODO)
Using Omnidex: Knowledgebases <tab>(TODO)

Topics

Fast Counts <tab>(TODO)
Fast Aggregations <tab>(TODO)
Textual Searches <tab>(TODO)
Portable Snapshots <tab>(TODO)
Scalable Grids <tab>(PROOF)
Environment Files <tab>(TODO)

Administrators

Omnidex Administration <tab>(TODO)
The Omnnidex Development and Deployment Lifecycle <tab>(TODO)
- Design <tab>(TODO)
- Development <tab>(TODO)
- Testing <tab>(TODO)
- Staging <tab>(TODO)
- Deployment <tab>(TODO)
- Optimization <tab>(TODO)
Environment Files
- Overview <tab>(TODO)
- Using Omnidex Administrator to create an Environment File <tab>(TODO)
  - Using SQL Statements to create an Environment File <tab>(TODO)
  - Creating an Environment File from an existing RDBMS <tab>(TODO)
  - Creating an Environment File from existing flat files <tab>(TODO)
  - Creating an Environment File using OACOMP <tab>(TODO)
    - Environment File Syntax <tab>(TODO)
  - Creating an Environment File using OAHELPER <tab>(TODO)
- Datatypes <tab>(TODO)
- Constraints <tab>(TODO)
- Naming Conventions <tab>(TODO)
Omnidex Criteria <tab>(TODO)
- Wildcards and Pattern Matching <tab>(TODO)
- Case Sensitivity <tab>(TODO)
- Boolean Operators <tab>(TODO)
- Range Operators <tab>(TODO)
- Files Containing Criteria Values <tab>(TODO)
- Synonym Searches <tab>(TODO)
- Thesaurus Searches <tab>(TODO)
- Word Form Searches <tab>(TODO)
- Spellchecked and Misspelling Searches <tab>(TODO)
- Number Transposition Searches <tab>(TODO)
- Phonetic Searches <tab>(TODO)
- Saved Searches <tab>(TODO)
- Multi-Column Index Searches <tab>(TODO)
- Unicode Datatypes <tab>(TODO)
Textual Searches <tab>(TODO)
- QuickText Indexes and Options <tab>(TODO)
  - Effect of Boolean Operators <tab>(TODO)
  - Effect of Wildcards and Pattern Matching <tab>(TODO)
- FullText Indexes and Options <tab>(TODO)
  - Proximity Operators <tab>(TODO)
  - Effect of Boolean Operators <tab>(TODO)
  - Effect of Wildcards and Pattern Matching <tab>(TODO)
  - Relevancy Scoring <tab>(TODO)
  - Retrieval Excerpts <tab>(TODO)
  - Indexing External Text Files <tab>(TODO)
Omnidex Indexing Strategies <tab>(TODO)
- Basic Indexing Strategies <tab>(TODO)
  - Optimizing Criteria <tab>(TODO)
  - Optimizing Aggregations <tab>(TODO)
  - Optimizing Nested Queries <tab>(TODO)
  - Optimizing Table Joins <tab>(TODO)
- Advanced Indexing Strategies <tab>(TODO)
  - Optimizing Complex Criteria <tab>(TODO)
  - Optimizing Complex Table Relationships <tab>(TODO)
  - Optimizing Distinct Counts <tab>(TODO)
  - Optimizing Latitude/Longitude Searches <tab>(TODO)
  - Indexing Multiple Columns as a Single Column <tab>(TODO)
- Analyzing the Query Plan <tab>(TODO)
Database Update Strategies <tab>(TODO)
- Batch Indexing <tab>(TODO)
- Incremental Indexing <tab>(TODO)
- Online Updates <tab>(TODO)
- Triggered Updates <tab>(TODO)
- Scalability Strategies <tab>(TODO)
RDBMS Topics <tab>(TODO)
- Oracle <tab>(TODO)
- SQL Server <tab>(TODO)
- MySQL <tab>(TODO)
- Generic ODBC <tab>(TODO)
- Stored Procedures <tab>(TODO)
- Triggered Updates <tab>(TODO)
Administrator FAQ <tab>(TODO)

Development

Omnidex SQL Reference

Overview

Omnidex SQL Reference <tab>(TODO)

Commands

ASSIGNVALUES <tab>(TODO)
ATTACH <tab>(TODO)
CLOSE CURSOR <tab>(TODO)
command <tab>(TODO)
connect <tab>(TODO)
CREATE DATABASE <tab>(TODO)
CREATE DIRECTORY <tab>(TODO)
CREATE ENVIRONMENT <tab>(TODO)
CREATE FILE <tab>(TODO)
CREATE INDEX <tab>(TODO)
CREATE INDEXES <tab>(TODO)
CREATE TABLE <tab>(TODO)
DELETE <tab>(TODO)
DELETEINDEX <tab>(TODO)
DETACH <tab>(TODO)
DISCONNECT <tab>(TODO)
DROP DATABASE <tab>(TODO)
DROP ENVIRONMENT <tab>(TODO)
DROP INDEX <tab>(TODO)
DROP INDEXES <tab>(TODO)
DROP TABLE <tab>(TODO)
EXPORT <tab>(TODO)
HELPER <tab>(TODO)
INSERT <tab>(TODO)
INSERTINDEX <tab>(TODO)
JOIN <tab>(TODO)
LOAD OFX <tab>(TODO)
OPEN CURSOR <tab>(TODO)
PARTITION <tab>(TODO)
QUALIFY <tab>(TODO)
SELECT <tab>(TODO)
SET <tab>(TODO)
UPDATE <tab>(TODO)
UPDATE INDEXES <tab>(TODO)
UPDATE ROLLUP <tab>(TODO)
UPDATE ROLLUPS <tab>(TODO)
UPDATE STATISTICS <tab>(TODO)
UPDATE TEXT <tab>(TODO)
UPDATEINDEX <tab>(TODO)
VERSION <tab>(TODO)

ODBC Interface

ODBC Interface <tab>(TODO)
- Setting up the ODBC Interface <tab>(TODO)
- Using the ODBC Interface <tab>(TODO)
- Examples <tab>(TODO)

JDBC Interface

JDBC Interface <tab>(TODO)
- Setting up the JDBC Interface <tab>(TODO)
- Using the JDBC Interface <tab>(TODO)
- Examples <tab>(TODO)
  - Simple Select <tab>(TODO)
- The JDBC Intelligent Router <tab>(TODO)

Stored Procedures

Stored Procedures <tab>(TODO)
- Oracle <tab>(TODO)
- SQL Server <tab>(TODO)
API's <tab>(TODO)
- OmniAccess <tab>(TODO)
- Client OmniAccess <tab>(TODO)
Developer FAQ <tab>(TODO)

Programs

Omnidex Administrator

Omnidex Administrator <tab>(TODO)

OdxSQL Interactive Omnidex SQL

OdxSQL <tab>(TODO)

Command Line Options

Command-line options <tab>(TODO)

Commands

Commands <tab>(TODO)
- ! <tab>(TODO)
- . <tab>(TODO)
- ; <tab>(TODO)
- ABORT <tab>(TODO)
- ASSIGNVALUES <tab>(TODO)
- ATTACH <tab>(TODO)
- BENCHMARK <tab>(TODO)
- BIND <tab>(TODO)
- CALC <tab>(TODO)
- CD <tab>(TODO)
- CLOSE CURSOR <tab>(TODO)
- COMMAND <tab>(TODO)
- CONNECT <tab>(TODO)
- CONVERT <tab>(TODO)
- COPY <tab>(TODO)
- CREATE DATABASE <tab>(TODO)
- CREATE DIRECTORY <tab>(TODO)
- CREATE ENVIRONMENT <tab>(TODO)
- CREATE FILE <tab>(TODO)
- CREATE INDEX <tab>(TODO)
- CREATE INDEXES <tab>(TODO)
- CREATE TABLE <tab>(TODO)
- DATE <tab>(TODO)
- DELETE <tab>(TODO)
- DELETEINDEX <tab>(TODO)
- DESCRIBE <tab>(TODO)
- DETACH <tab>(TODO)
- DIR <tab>(TODO)
- DISCONNECT <tab>(TODO)
- DROP DATABASE <tab>(TODO)
- DROP ENVIRONMENT <tab>(TODO)
- DROP INDEX <tab>(TODO)
- DROP INDEXES <tab>(TODO)
- DROP TABLE <tab>(TODO)
- DUMP <tab>(TODO)
- EDIT <tab>(TODO)
- ERROR <tab>(TODO)
- EVAL <tab>(TODO)
- EXECSQL <tab>(TODO)
- EXIT <tab>(TODO)
- EXPLAIN <tab>(TODO)
- EXPORT <tab>(TODO)
- EXTRACT <tab>(TODO)
- FETCH <tab>(TODO)
- FETCHKEYS <tab>(TODO)
- FLIP <tab>(TODO)
- FOR <tab>(TODO)
- FORMAT <tab>(TODO)
- GETENV <tab>(TODO)
- HELP <tab>(TODO)
- HELPER <tab>(TODO)
- HISTORY <tab>(TODO)
- IF <tab>(TODO)
- INSERT <tab>(TODO)
- INSERTINDEX <tab>(TODO)
- IS <tab>(TODO)
- JOIN <tab>(TODO)
- LOAD OFX <tab>(TODO)
- LOOKUP <tab>(TODO)
- MESSAGE <tab>(TODO)
- NETWORKACCESS <tab>(TODO)
- OPEN CURSOR <tab>(TODO)
- OXKERNEL <tab>(TODO)
- PARSE <tab>(TODO)
- PARTITION <tab>(TODO)
- PWD <tab>(TODO)
- QUALIFY <tab>(TODO)
- QUIT <tab>(TODO)
- REMOVE <tab>(TODO)
- RENAME <tab>(TODO)
- RESET HISTORY <tab>(TODO)
- RESET TIMER <tab>(TODO)
- RESTORE SETTINGS <tab>(TODO)
- SAVE HISTORY <tab>(TODO)
- SAVE SETTINGS <tab>(TODO)
- SELECT <tab>(TODO)
- SET <tab>(TODO)
- SETENV <tab>(TODO)
- SHOW <tab>(TODO)
- SIGNAL <tab>(TODO)
- SLEEP <tab>(TODO)
- SORTMERGE <tab>(TODO)
- UPDATE <tab>(TODO)
- UPDATE INDEXES <tab>(TODO)
- UPDATE ROLLUP <tab>(TODO)
- UPDATE ROLLUPS <tab>(TODO)
- UPDATE STATISTICS <tab>(TODO)
- UPDATE TEXT <tab>(TODO)
- UPDATEINDEX <tab>(TODO)
- USE <tab>(TODO)
- VALIDATE <tab>(TODO)
- VERSION <tab>(TODO)
- VIEW <tab>(TODO)
- n <tab>(TODO)
- n: <tab>(TODO)

OdxNet - Network Services

Omnidex Network Services <tab>(TODO)
- Command-line options <tab>(TODO)
- Configuration file <tab>(TODO)

Utilities

Utilities (later renamed to Legacy Tools) <tab>(TODO)
- OACOMP <tab>(TODO)
- OADECOMP <tab>(TODO)
- DBINSTAL <tab>(TODO)
- OAHELPER <tab>(TODO)
- DSEdit <tab>(TODO)
- OdxQuery <tab>(TODO)
- NSAdmin <tab>(TODO)
- VERSIONS <tab>(TODO)
- SYSINFO <tab>(TODO)
- REGMAINT <tab>(TODO)

Application Integration

Appendixes

Software Installation <tab>(TODO)
Platform Support <tab>(TODO)
Release Notes <tab>(TODO)
Migration From Earlier Versions <tab>(TODO)
Glossary <tab>(TODO)
Documentation Map <tab>(TODO)
Installation FAQ <tab>(TODO)

Quick Links

Quick Links
Overview	Topics	Administation	Development	General
What is Omnidex?	Fast Counts	Omnidex Administrator	Omnidex SQL Reference	Software Installation
Omnidex Architecture	Fast Aggregations	OdxSQL	ODBC	Platform Support
Omnidex on Customer Lists	Textual Searches	Optimizing Query Performance	JDBC	Release Notes
Omnidex on Business Analytics	Fuzzy Searches	RDBMS Topics	Stored Procedures	Glossary
Omnidex on Transaction Logs	Portable Snapshots	Legacy Tools/APIs	Debugging	Documentation Map
Omnidex on Flat File Databases	Scalable Grids	Administrator FAQ	Developer FAQ	Installation FAQ

(c)Copyright Dynamic Information Systems - This document was last updated November 11, 2009.

Back to top

appendix/docmap.1258605775.txt.gz · Last modified: 2012/10/26 14:20 (external edit)

Sitemap Recent Changes