Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
admin:features:snapshots:home [2012/03/29 21:59]
doc
admin:features:snapshots:home [2016/06/28 22:38] (current)
Line 15: Line 15:
 ==== Overview ==== ==== Overview ====
  
-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 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.  ​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. ​+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 createdit 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 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. 
  
 ====  ==== ====  ====
 
Back to top
admin/features/snapshots/home.1333058361.txt.gz · Last modified: 2016/06/28 22:38 (external edit)