ODXAIM, Omnidex Automatic Index Maintenance, automatically maintains index synchronization for applications that do not use OmniAccess to update the data, using database triggers to signal when an update has occurred. This allows you to develop applications using the RDBMS' most powerful features, like stored procedures and transaction management, while taking advantage of the speed and flexibility of the OMNIDEX indexes.
ODXAIM generates a SQL script file with triggers and transaction tables that are installed directly into the database. As data updates occurs, the database trigger adds a record to the transaction table detailing the update. An ODXAIM process monitors these transaction tables, updating the indexes when appropriate, and then deleting the record in the transaction table.
It is important to note that index updates are not immediate and, depending on the frequency of database updates, there could be a slight delay in index synchronization.
If the ODXAIM monitoring process is not running for some reason, but the triggers have been installed in the database, the triggers will continue to work as defined. When the ODXAIM process is restarted, it will update the indexes with the information stored as a result of the triggers. If, on the other hand, the data stored in the aim tables is somehow deleted before the ODXAIM process can update the indexes, the indexes will be out of sync with the data and will have to be rebuilt using DBINSTAL.
ODXAIM has two modes of operation: Setup and Monitoring. Setup, which is the process of generating the AIM tables and triggers used to monitor data changes, is performed once per index installation. Monitoring is the background process that performs the index maintenance as the application updates the data.
Setting up ODXAIM involves the following steps for an existing OMNIDEX installation:
The ODXAIM monitoring process is the mode of operation that runs in the background performing the index updates. All of the setup steps must be complete before starting this process.
The ODXAIM configuration file is used to configure ODXAIM functionality. All the settings defined in the configuration file, except for Logging and LogFile settings, can also be defined from the command line with options.
This configuration file is only required if using logging or when installing ODXAIM as a Windows service.
; Required entries have default settings applied. Other settings