I am trying to design a table structure in DB2/zOS to support real time update of business data.
The data are like <name1,value>, <name2, value>,.......<name100,value>. And they are updated frequently like once per second.
The query can be performed both on current value and past values depending on the timestamp, so the historic data should also be stored.
To my knowledge, the mainstream solution for this problem is in-memory database, such as the Oracle TimesTen In-Memory Database.
We use two tables to support our need:
1. TABLE-CURRENT, stores the current value, indexed on data name, provides query on current value.
2. TABLE_HISTORIC, stores the past values, indexed on data name and timestamp, provides query on historic values.
Usually, TABLE-CURRENT is kept in memory for realtime performance.
The question is that, is there something similar as in-memory database in DB2/zOS?
Or is it OK that we just keep TABLE-CURRENT as regular db2 table?
THANKS VERY MUCH!