https://www.omnidex.com/docs/v54/ 2026-04-29T20:43:58+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:grid&rev=1467153531&do=diff Administration: Omnidex Fundamentals Omnidex Updates Overview | Offline Updates | Online Updates | Grid Updates | Triggered Updates ---------- Grid Updates Omnidex Grids distribute data across multiple nodes. Nodes can be evenly distributed, or they can be distributed based on criteria, such as company, geography or time. Omnidex Grids are ideal for very large databases as they distribute the data across multiple servers and allow scalability through parallel processing. At the same t… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:home&rev=1467153531&do=diff Administration: Omnidex Fundamentals Omnidex Updates Overview | Offline Updates | Online Updates | Grid Updates | Triggered Updates ---------- Overview Omnidex allows databases to be updated either in batch or online. The large majority of companies choose to update their databases in batch, and this is in keeping with the design of Omnidex and the nature of large databases. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:offline&rev=1467153531&do=diff Administration: Omnidex Fundamentals Omnidex Updates Overview | Offline Updates | Online Updates | Grid Updates | Triggered Updates ---------- Offline Updates The most common way to process a large volume of updates is to use offline updates. Offline updates simply mean that the data is updated offline and then the indexes are regenerated. While the data is being updated, the indexes are not updated, allowing the indexes to become out of sync with the data. During this time, the Omnid… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:online&rev=1467153531&do=diff Administration: Omnidex Fundamentals Omnidex Updates Overview | Offline Updates | Online Updates | Grid Updates | Triggered Updates ---------- Online Updates Some applications require that databases are updated online. Omnidex supports online updates using the INSERT, DELETE and UPDATE statement, though there are restrictions that should be considered by the administrator and the application designer. When Omnidex processes an INSERT, DELETE or UPDATE statement, it updates the indexes … text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:restrictions_insert&rev=1467153531&do=diff * Omnidex does not support database transactions. * Omnidex does not support the relational ACID requirements (Atomicity, Consistency, Isolation and Durability). * Most Omnidex applications will place tens or hundreds of indexes on a table, and this makes online updates impractical. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:basics:updates:triggers&rev=1467153531&do=diff Administration: Omnidex Fundamentals Omnidex Updates Overview | Offline Updates | Online Updates | Grid Updates | Triggered Updates ---------- Triggered Updates Omnidex allows some relational databases to use triggers to send INSERT, DELETE and UPDATE requests to Omnidex. A database trigger is a set of instructions that are executed every time the database experiences an insert, delete or update operation. For Oracle and Microsoft SQL Server, Omnidex allows triggers to be installed on …