Apparatus and method for on-demand in-memory database management platform

A memory-based on-demand database system having a plurality of blocks of memory for data operation and storage, comprising:

• means for loading a database partially or in whole from a secondary system into said memory blocks for data operation;
• and
• means for unloading a said database from said memory blocks to said secondary system;
• wherein said means for loading comprises:
• means for providing a block ID lookup table, wherein each said block has a block entry in said block ID lookup table containing a block ID, and said block entry contains direct or indirect information of a physical location of said block in said block storage system;
• means for providing a block address in said block ID lookup table to access to each said block, wherein said block address includes said block ID;
• means for dynamically duplicating data stored in a first block in said block storage system into a second block in said block storage system, wherein said first block has a first block ID in said block ID lookup table and said second block has a second block address in said block ID lookup table and wherein a first block entry in said block ID lookup table corresponding to said first block contains different direct or indirect information of a physical location of said first block than a second block entry in said block ID lookup table corresponding to said second block;
• and
• means for dynamically changing said second block address in said block ID lookup table to duplicate said first block address to re-direct said first block ID to the physical location of said second block in said block storage system, wherein after said dynamic change a plurality of entries in said block ID lookup table comprise said first block ID.