This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
integration:rdbms:sqlserver:home [2011/04/07 17:56] doc |
integration:rdbms:sqlserver:home [2011/04/08 16:34] deb |
||
---|---|---|---|
Line 27: | Line 27: | ||
{{:integration:rdbms:sqlserver:basic_architecture_sqlserver.png|}} | {{:integration:rdbms:sqlserver:basic_architecture_sqlserver.png|}} | ||
- | Omnidex does not migrate the data out of SQL Server, but instead directly references the data in the SQL Server 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 SQL Server, but instead directly references the data in the SQL Server 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 SQL Server 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 SQL Server 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. |