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:odbc:home [2011/04/06 23:56] doc |
integration:rdbms:odbc:home [2011/04/16 14:55] doc |
||
---|---|---|---|
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. |