Patent ID: 8386734

Claim:
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.