Memory Resident Tables

PBXT memory resident tables (MRT) have no files on disk, and are not durable. The table is held entirely in memory. Since PBXT already caches index, handle data and row pointer files, in cache, the implementation only requires a solution for the data log file data.

It would be possible to limit the amount of RAM use by an MRT. When the RAM threshold is exceeded, the MRT is written to standard PBXT table files.

The implementation would require a new table attribute, for example: CREATE TABLE t1 ( ... ) TABLE_TYPE=IN_MEMORY;