Overview | Types | Creating | Maintaining | Deploying
There are several types of Omnidex Environments, as described below.
The most common environment encompasses a single database with indexes. This can be either a relational database, such as Oracle, SQL Server or MySQL, or it can be a series of data files arranged as a database. Omnidex indexes are usually added to the database. Connections to this type of environment allow complete, indexed access to the database.
Omnidex Environments can be comprised of multiple databases. These databases can be of different types as well. For example, an environment can contain a database pointing to Oracle tables, and also contain a database pointing to raw data files or delimited files. All databases can have Omnidex indexes, and queries against this environment can reference tables from both databases. This capability is of great benefit to those who have transient log files or transaction files that they want to query in conjunction with a primary relational database.
For applications that require accessing multiple sources of data, it is also possible to temporarily attach a database or table to the current environment. This is useful for incorporating tables with search criteria from customers, or incorporating the results of previous orders.
Omnidex is frequently used on very large databases, often with billions of rows. These databases are appropriate for Omnidex Grids. Omnidex Grids distribute the data and indexing across multiple nodes, allowing indexing and queries to be processed on each node in parallel, or even limited to individual nodes. A Omnidex Grid Environment contains the standard database and indexing information, but also contains the configuration of the Omnidex Grids.
Omnidex provide powerful features for performing textual searches, including searches on external textual files. An Omnidex database acts as a catalog of the textual documents and allows the indexing of both the catalog and the documents themselves.
Omnidex provides a special environment that gives access to features within the product itself, such as connection and statement logs, synonym tables, error messages and configuration information. This reserved environment is simply called “omnidex”, and is universally available in the product.
See also: