MOT Local and Global Memory
SILO manages both a local memory and a global memory, as shown in.
Global memory is long-term shared memory is shared by all cores and is used primarily to store all the table data and indexes
Local memory is short-term memory that is used primarily by sessions for handling transactions and store data changes in a primate to transaction memory until the commit phase.
When a transaction change is required, SILO handles the copying of all that transaction's data from the global memory into the local memory. Minimal locks are placed on the global memory according to the OCC approach, so that the contention time in the global shared memory is extremely minimal. After the transaction' change has been completed, this data is pushed back from the local memory to the global memory.
The basic interactive transactional flow with our SILO-enhanced concurrency control is shown in the figure below –
Figure 1 Private (Local) Memory (for each transaction) and a Global Memory (for all the transactions of all the cores)
-memory-(for-each-transaction)-and-a-global-memory.png){kind=spacer}
For more details, refer to the Industrial-Strength OLTP Using Main Memory and Many-cores document[Comparison – Disk vs. MOT].