This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
integration:rdbms:environments [2011/03/14 19:33] els |
integration:rdbms:environments [2011/03/16 20:47] doc |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| [[integration:rdbms:queries|Queries]] | | [[integration:rdbms:queries|Queries]] | | ||
| [[integration:rdbms:updates|Updates]] | | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:creation|Generating Data Files]] | | ||
| [[integration:rdbms:implementation|Implementation Guides]] | [[integration:rdbms:implementation|Implementation Guides]] | ||
| ---- | ---- | ||
| - | ==== Environments and Raw Data Files ==== | + | ==== Environments and Relational Databases ==== |
| - | Omnidex provides access to raw data files by creating a database around them. The Omnidex administrator creates an Omnidex Environment File that declares a complete database with table and column definitions, table constraints and Omnidex indexes. The tables simply point to the raw data files as their source of data. Omnidex applications can then query the database without any concern whether the underlying data came from a relational database or raw data files. | + | Omnidex provides access to relational database by creating an Omnidex Environment File that points to the relational database and the tables. Within the Omnidex Environment File, the administrator declares a database with connection information for the underlying relational database, and then declares tables that point to the underlying relational tables or views. Note that the Omnidex Environment File contains only metadata, and does not make a copy of the data in the relational database. |
| {{:integration:rdbms:basic_architecture_relational_databases.png|}} | {{:integration:rdbms:basic_architecture_relational_databases.png|}} | ||
| - | The instructions for referencing the raw data files in CREATE TABLE statements vary based on the file type. Consult the [[integration:rdbms:implementation|Implementation Guides]] for each type of raw data file for instructions on adding them to Omnidex Environment Files. | + | ==== Declaring Relational Objects ==== |
| + | |||
| + | Omnidex only has access to the tables and columns that are declared in the Omnidex Environment File. Any database objects that exist in the underlying relational database, but are not declared in the Omnidex Environment File, are unknown to Omnidex. This allows administrators to control the visibility of the relational database as needed. The Omnidex Environment File can also be use to alter the metadata. Objects can have different names within Omnidex, and some datatypes can be changed as well. | ||
| + | |||
| + | The Omnidex Environment File should not only declare the tables and columns, but it should declare the table constraints and native indexes as well. Primary and foreign key constraints should be declared with each table so that Omnidex can understand the parent-child table relationships in the database. Relational database indexes should be declared as NATIVE indexes so that Omnidex can understand what optimization is possible at the relational database level. These constraints and native index declarations are important for Omnidex query optimization. | ||
| ==== Combining Raw Data Files and Relational Databases ==== | ==== Combining Raw Data Files and Relational Databases ==== | ||