Omnidex Version 5.0

Overview
1. What is Omnidex? <tab>(TODO)
2. Omnidex Architecture <tab>(TODO)
3. Quick Start Guide <tab>(TODO)
4. Using Omnidex: Customer Lists <tab>(TODO)
5. Using Omnidex: Business Analytics <tab>(TODO)
6. Using Omnidex: Transaction Logs <tab>(TODO)
7. Using Omnidex: Flat File Databases <tab>(TODO)
8. Using Omnidex: Text Databases <tab>(TODO)
9. Using Omnidex: Knowledgebases <tab>(TODO)
Topics
1. Fast Counts <tab>(TODO)
2. Fast Aggregations <tab>(TODO)
3. Textual Searches <tab>(TODO)
4. Portable Snapshots <tab>(TODO)
5. Scalable Grids <tab>(PROOF)
6. Environment Files <tab>(TODO)
Administrators
1. Omnidex Administration <tab>(TODO)
2. 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)
3. 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)
4. 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)
5. 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)
6. 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)
7. 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)
8. 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)
9. Administrator FAQ <tab>(TODO)
Developers
1. Omnidex SQL Reference <tab>(TODO)
  - 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)
2. ODBC Interface <tab>(TODO)
  - Setting up the ODBC Interface <tab>(TODO)
  - Using the ODBC Interface <tab>(TODO)
  - Examples <tab>(TODO)
3. JDBC Interface <tab>(TODO)
  - Setting up the JDBC Interface <tab>(TODO)
  - Using the JDBC Interface <tab>(TODO)
  - Examples <tab>(TODO)
  - The JDBC Intelligent Router <tab>(TODO)
4. Stored Procedures <tab>(TODO)
  - Oracle <tab>(TODO)
  - SQL Server <tab>(TODO)
5. API's <tab>(TODO)
  - OmniAccess <tab>(TODO)
  - Client OmniAccess <tab>(TODO)
6. Developer FAQ <tab>(TODO)
Programs
1. Omnidex Administrator <tab>(TODO)
2. OdxSQL <tab>(TODO)
  - Command-line options <tab>(TODO)
  - 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)
3. Omnidex Network Services <tab>(TODO)
  - Command-line options <tab>(TODO)
  - Configuration file <tab>(TODO)
4. 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 <tab>(TODO)
1. Business Objects <tab>(TODO)
2. Microstrategy DSS Agent <tab>(TODO)
Appendixes <tab>(TODO)
1. Software Installation <tab>(TODO)
2. Platform Support <tab>(TODO)
3. Release Notes <tab>(TODO)
4. Migration From Earlier Versions <tab>(TODO)
5. Glossary <tab>(TODO)
6. Documentation Map <tab>(TODO)
7. 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.1258155800.txt.gz · Last modified: 2012/10/26 14:20 (external edit)

Sitemap Recent Changes

Omnidex Version 5.0

Table of Contents

Quick Links