This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rdbms:environments [2011/03/14 19:20] 127.0.0.1 external edit |
integration:rdbms:environments [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| 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:integration|Integration 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 a 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_raw_data_files.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 used 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 ==== | ||
| - | Raw data files often supplement a relational database. For example, a transaction log or a supplemental data file may contain information that is ideal to correlate with a relational database. Companies that have been importing that data into the relational database can avoid that extra work, and use Omnidex to join those two data sources together instead. | + | Raw data files often supplement a relational database. For example, a transaction log or a supplemental data file may contain information that is ideal to correlate with a relational database. Companies importing that data into the relational database can avoid the extra work, and use Omnidex to join those two data sources together instead. |
| An Omnidex Environment File can include more than one database, and each database can be of a different type. An Omnidex Environment File can have one database that points to the underlying relational database, and a second database that points to a series of raw data files. When connected to this Omnidex Environment File, applications can issue SQL statements that join tables from both databases. | An Omnidex Environment File can include more than one database, and each database can be of a different type. An Omnidex Environment File can have one database that points to the underlying relational database, and a second database that points to a series of raw data files. When connected to this Omnidex Environment File, applications can issue SQL statements that join tables from both databases. | ||