This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
overview:intro [2009/07/17 03:26] admin |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Omnidex Overview ====== | ||
| - | Omnidex is a supplemental indexing system that can be used to enhance data retrieval from flat files and relational databases such as SQL Server. Oracle, and MySQL as well as any ODBC compliant database via the generic ODBC Database interface. | ||
| - | |||
| - | Omnidex provides retrieval capabilities beyond traditional retrieval. | ||
| - | Lots of complex criteria very quickly | ||
| - | Text searches – words/values within a column | ||
| - | Active Counts/Count Engine – the best/fast count engine | ||
| - | Powersearch – fuzzy search | ||
| - | |||
| - | |||
| - | Omnidex is a lightweight but powerful indexing system. | ||
| - | |||
| - | ===== How Omnidex works ===== | ||
| - | |||
| - | Omnidex works by specifying indexes on database columns or fields in files using the OdxAdmin Windows based program and storing the specification in an XML file. The indexes can then be syncronized with the underlying data using the OdxAdmin program. | ||
| - | |||
| - | Applications can then utilize the Omnidex indexes for very fast and flexible retrieval using either an [[development:interfaces:odbc:intro|ODBC]], [[development:interfaces:jdbc:intro|JDBC]], or a stored procedureal interface. | ||
| - | |||
| - | ===== Nine Steps to a Successful Omnidex Installation ===== | ||
| - | |||
| - | ^ Steps ^ Operation ^ | ||
| - | |1) Software Installation & Setup | This section describes the software installation and setup procedures for the Omnidex server software, client software, and Omnidex Network Services. A server setup guide for each supported platform is included in this section. | | ||
| - | |2) Account Verification | This section describes some additional steps that should be performed in order to make Omnidex fully operational. These steps should also be performed if Omnidex should cease to function properly. | | ||
| - | |3) Index Design | To properly design an Omnidex database index installation, a thorough understanding of the Omnidex index types and options is necessary. This section describes all of the indexing options available, how they affect an application and when each should be used. | | ||
| - | |4) Environment Catalog | This section describes the Omnidex Environment Catalog in detail, including syntax, some special design options to add more functionality to an installation, and variations based on the underlying database. Also in this section are descriptions of the Omnidex utilities OAHELPER, OACOMP, and OADECOMP, which can be used to automatically generate, compile, and decompile an Omnidex Environment Catalog. | | ||
| - | | 5) Index Installation | DBINSTAL is the Omnidex utility that installs the Omnidex indexes on an Environment. This section describes DBINSTAL in detail as well as two additional Omnidex utilities, VIEWGEN and SNOWGEN, that can assist with the index installation. | | ||
| - | | 6) Index Maintenance | This section describes populating the Omnidex indexes using the DBINSTAL utility, as well as various methods for maintaining them. | ||
| - | | 7) Test the Installation | This section describes various methods for testing an index installation and query performance. Omnidex provides several utilities specifically for this purpose, which are discussed in detail. | | ||
| - | | 8) Application Development | Omnidex provides easy to use interfaces to several different development tools and third party applications. This section describes these development options in detail and provides detailed examples. | | ||
| - | | 9) Debugging | This section describes the methods and tools available in Omnidex to debug an application. | | ||
| - | |||
| - | |||
| - | |||
| - | ==== For Existing Customers ==== | ||
| - | |||
| - | This section outlines the differences between version 5.x and previous Omnidex versions. | ||
| - | |||
| - | |||
| - | ====== Quick Links ====== | ||
| - | ^ [[:start|Quick Links]] ^^^^^ | ||
| - | ^ General ^ Programs ^ Interfaces ^ Topics ^ Miscellaneous ^ | ||
| - | | [[overview:intro|Omnidex Introduction]] | [[programs:odxsql:intro|OdxSQL]] |[[development:interfaces:odbc:intro|ODBC]] | [[design:grids:intro|Grids]] | [[releasenotes:intro|Release Notes]] | | ||
| - | | [[odxadmin:intro|Administrating Omnidex (OdxAdmin)]] | [[programs:odxnet:intro|OdxNet]] |[[development:interfaces:jdbc:intro|JDBC]] | [[design:unionview:intro|Union Views]]| [[osinstall:intro|Server Installs]] | | ||
| - | | [[design:intro|Data and Index Design]] | [[programs:odxaim:intro|OdxAim]] |[[development:interfaces:storedproc:intro|Stored Procedures]] | [[design:rolluptable:intro|Rollup Tables]] | [[osinstall:licensing:intro|Licensing]] | | ||
| - | | [[sql:intro|Omnidex Queries & SQL]] | [[programs:dbinstal:intro|DBInstal]] |[[development:interfaces:omniaccess:intro|OmniAccess]] | [[design:partitioning:intro|Partitioning]] | [[osinstall:settings:intro|Settings]] | | ||
| - | | [[activecounts:intro|Active Counts]] | [[programs:oaenv:intro|OaComp/decomp/helper]] |[[development:interfaces:clientoa:intro|Client OA]] | [[development:explainplan:intro|Explain Plans]]| [[glossary:intro|Glossary]] | | ||
| - | | [[powersearch:intro|PowerSearch]] | [[programs:client:intro|DSEdit/OdxQuery]] | [[rdbms:intro|RDBMS Indexing]] | [[development:debugging:intro|Debugging]] | [[appendix:intro|Appendix]] | | ||
| - | (c) Copyright Dynamic Information Systems - This document was last updated July 15, 2009. | ||
| - | |||
| - | ---- | ||