This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:mysql:home [2011/04/06 23:11] 127.0.0.1 external edit |
integration:rdbms:mysql:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 27: | Line 27: | ||
| {{:integration:rdbms:mysql:basic_architecture_mysql.png|}} | {{:integration:rdbms:mysql:basic_architecture_mysql.png|}} | ||
| - | Omnidex does not migrate the data out of MySQL, but instead directly references the data in the MySQL database. 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 MySQL, but instead directly references the data in the MySQL database. 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 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 MySQL 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 MySQL 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. | ||