In memory DB on top of IDS 12.10
Ronald Olavidez asked whether any in-memory database exists on top of Informix. Spokey Wheeler asked why. Art Kagel said SolidDB is dead, in his opinion, and pointed to the Informix Warehouse Accelerator, an in-memory columnar warehouse engine included in the Advanced Workgroup and Advanced Enterprise Editions, claiming 50X to 1200X faster queries. Ronald thanked him.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Gurus, Just a question if there's any "in memory" DB on top of Informix available. It should be able to support IDS. As i know, SolidDB, an IBM product is one. Is there any other DBs? Thanks,
Why? > On 17 May 2016, at 07:16, RONALD OLAVIDEZ <ronald.olavidez@gmail.com> wrote: > > Hi Gurus, > > Just a question if there's any "in memory" DB on top of Informix available. It > should be able to support IDS. > > As i know, SolidDB, an IBM product is one. Is there any other DBs? > > Thanks, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Solid is dead (in my opinion it never worked properly). Solid was an in-memory OLTP expansion over IDS. If you want an in-memory Data Warehouse engine, that you can get with the Informix Warehouse Accelerator (IWA) which is included in the Advanced Workgroup and Advanced Enterprise Editions of Informix. IWA is an in-memory, highly compressed, columnar data warehouse engine that is fully integrated in to Informix. You load the tables you want to accelerate into a data mart in IWA, set an environment variable (or SQL setting) and whoosh! queries against those tables will be accelerated 50X, 100X, 400X, even 1200X faster than the base engine can process them. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 17, 2016 at 2:16 AM, RONALD OLAVIDEZ <ronald.olavidez@gmail.com> wrote: > Hi Gurus, > > Just a question if there's any "in memory" DB on top of Informix > available. It > should be able to support IDS. > > As i know, SolidDB, an IBM product is one. Is there any other DBs? > > Thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93b57d64733ae05330a33f4
Thank you Art as always.