The MEMORY storage engine stores all data in memory (RAM), and is used for fast lookup of data. InnoDB supports a buffer pool ...
Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis.