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:54] 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. |
===== ===== | ===== ===== | ||