This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:snapshots:home [2012/03/30 19:21] doc |
admin:features:snapshots:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| Once an Omnidex Snapshot is created, it no longer requires access to the relational database. Whether residing on the same server or a different server, Omnidex will simply use a combination of the raw data files and the Omnidex indexes to satisfy all queries. This reduces the load on the relational database, and it also allows distribution of the data without requiring additional relational database licenses for other servers. If needed, Omnidex Snapshots are also easily replicated for expanded scalability. | Once an Omnidex Snapshot is created, it no longer requires access to the relational database. Whether residing on the same server or a different server, Omnidex will simply use a combination of the raw data files and the Omnidex indexes to satisfy all queries. This reduces the load on the relational database, and it also allows distribution of the data without requiring additional relational database licenses for other servers. If needed, Omnidex Snapshots are also easily replicated for expanded scalability. | ||
| - | |||
| - | === Enhancing the Database Layout === | ||
| - | |||
| - | Omnidex Snapshots provide an excellent opportunity to enhance the database layout without altering the underlying database. When creating the Omnidex Snapshot, tables can be denormalized, data can be aggregated, and new columns can be created based on any SQL expression. This provides the flexibility to achieve higher performance and develop custom applications without requiring the review and planning that is needed when changing the underlying, production database. | ||
| - | |||
| - | === Creating Small Data Marts === | ||
| - | |||
| - | Omnidex Snapshots can be created for a subset of data, such as a particular year or a particular division of a company. This allows analysis on a smaller subset of the data without having to impact the underlying database. | ||
| - | |||
| - | === Portable Snapshots === | ||
| - | |||
| - | Omnidex Snapshots can be easily moved to other servers by simply copying a directory of files. | ||
| - | |||
| - | |||