Omnidex allows entire databases to be attached to the current Omnidex Environment, incorporating all of their tables and Omnidex indexes. This can greatly expand the data available to query, and enhance the ability to optimize queries across multiple databases within the enterprise. Any type of database from any Omnidex Environment can be attached. This allows great flexibility in linking multiple applications together, such as linking a SQL Server customer database with a Raw Data File data warehouse.
Attaching databases can also be useful for applications that reference the results from previous queries in future queries. If the result set consists of a single column, such as a primary key, this can be done simply using Omnidex Segments; however, some applications identify the results of a previous query using multiple columns, or even multiple tables. Omnidex allows these results to be rendered into a miniature Omnidex database, complete with Omnidex indexing. Future queries can attach as many result set databases as needed to perform order suppression or other tasks, all taking advantage of the Omnidex indexes.
Attaching a database is simple, and uses the ATTACH DATABASE statement, as shown below:
> connect to simple Connected to D:\class\labs\attach\simple.xml > attach database GEO >> from geo.xml; Database GEO attached
The newly attached database can be see using the SHOW TABLES command in OdxSQL:
> show tables
Tables
------
Environment
Database
Table Length Cols Rows Type
----------------------------------------------------------------------------
USER_ENVIRONMENT
SIMPLE
COUNTRIES 98 7 239 FIXED
STATES 44 6 76 FIXED
GENDERS 33 2 2 FIXED
HOUSEHOLDS 99 6 1,909 FIXED
INDIVIDUALS 159 7 5,000 FIXED
$TEMPDB
GEO
COUNTRIES 98 7 239 FIXED
REGIONS 36 4 12 FIXED
STATES 44 6 76 FIXED
COUNTIES 50 9 3,241 FIXED
ZIPCODES 76 11 42,474 FIXED
See also: