Overview | Benefits | Creation | Portability | Scalability

Omnidex Snapshots provide an easy,k portable, high performing copy of a database or a data warehouse. The data from an underlying data source is stored in raw data files, and is usually heavily indexed. This snapshot database can then be moved to other servers for analysis, or even replicated and deployed in production.

Omnidex Snapshots are an important tool for databases that are heavily updated. Databases that are heavily updated usually cannot be heavily indexed due to performance concerns, and this leaves the underlying database ill-prepared for analytical queries. In fact, many production databases are not even made available for analytical queries for this very reason. Omnidex Snapshots create a segregated, portable, heavily-indexed copy of the database that can be easily offloaded to another server, thereby supporting the analytical queries.

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 the queries. This reduces the load on the relational database, and it also allows distribution of the data without requiring additional relational database licenses. If needed, Omnidex Snapshots can also be easily replicated to add further scalability.

Next