Omnisci is Hybrid Transaction/Analytical Processing (HTAP) Database ??

Hi guys,

If i am ask a question that omnisci is Hybrid Transaction / Analytical Processing ( HTAP) ?

Please let us know what would be your comment on it.


Hi Sumit - we are not strictly an HTAP store.

First, we arent really going after high-throughput updates/inserts/deletes at a row level that transactional DBs do, because that was/is not our goal. We set out to build the fastest analytical database engine possible, which really requires an architecture optimized for analytic operations - including a columnar storage engine (that modern analytical stores have) and a compiled query execution engine paired with it.

That said, we do support all CRUD operations, including INSERTS, UPDATEs and DELETEs. We’re also (weakly) ACID because the way we serialize update/delete/insert operation, and allow rollbacks.