Overview | Benefits | Creation | Portability | Scalability
Omnidex Snapshots provide an easy, 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. These databases are usually lightly indexed to preserve performance, and this leaves the database ill-prepared for analytical queries. In fact, many production databases disallow these analytical queries to avoid impacting performance. Omnidex Snapshots solve this problem by creating a segregated, portable, heavily-indexed copy of the database that can be easily offloaded to another server.
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.