This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:odbc:home [2011/04/06 23:56] doc |
integration:rdbms:odbc:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 27: | Line 27: | ||
| {{:integration:rdbms:odbc:basic_architecture_odbc.png|}} | {{:integration:rdbms:odbc:basic_architecture_odbc.png|}} | ||
| - | Omnidex does not migrate the data out of the underlying database, but instead directly references the data through the underlying database's ODBC driver. This is not a requirement, though. Migration of the data into raw data files is an option if that is preferable; in fact, many companies use [[admin:features:snapshots:home|Omnidex Snapshots]] for this very purpose. Omnidex Snapshots are high-performing, highly-portable, heavily-indexed copies of data that can be easily accessed using standard ODBC and JDBC interfaces. | + | Omnidex does not migrate the data out of the underlying database, but instead directly references the data through the underlying database's ODBC driver. This is not a requirement, however. Migration of the data into raw data files is an option if that is preferable. In fact, many companies use [[admin:features:snapshots:home|Omnidex Snapshots]] for this very purpose. Omnidex Snapshots are high-performing, highly-portable, heavily-indexed copies of data that can be easily accessed using standard ODBC and JDBC interfaces. |
| Omnidex is usually deployed on read-only tables. Most applications require tens to hundreds of Omnidex indexes on a table, making real-time updates impractical. Applications usually set aside certain tables that are refreshed on a regular basis and Omnidex indexes are completely refreshed. Omnidex does support real-time updates for those situations where there are fewer indexes and lower volume. | Omnidex is usually deployed on read-only tables. Most applications require tens to hundreds of Omnidex indexes on a table, making real-time updates impractical. Applications usually set aside certain tables that are refreshed on a regular basis and Omnidex indexes are completely refreshed. Omnidex does support real-time updates for those situations where there are fewer indexes and lower volume. | ||
| Line 40: | Line 40: | ||
| In this scenario, Omnidex winds up being a middle layer between two ODBC drivers that processes and optimizes queries. | In this scenario, Omnidex winds up being a middle layer between two ODBC drivers that processes and optimizes queries. | ||
| - | This Integration Guide discusses how Omnidex can access any database that has an ODBC Driver. Omnidex's ODBC Driver is discussed in the [[integration:odbc:home|Omnidex ODBC Driver]] documentation. | + | This Integration Guide discusses how Omnidex can access any database that has an ODBC Driver. |
| ===== ===== | ===== ===== | ||