A Data Distribution Strategy for Scalable Main-Memory Database

Main-Memory Database (MMDB) System is more superior in less response times and higher transaction throughputs than traditional Disk-Resident Database (DRDB) System. But the high performance of MMDB depends on the single server's main memory capacity, which is restricted by hardware technologies and operating system. In order to resolve the contradiction between requirements of high performance and limited memory resource, we propose a scalable Main-Memory database system ScaMMDB which distributes data and operations to several nodes and makes good use of every node's resource. In this paper we'll present the architecture of ScaMMDB and discuss a data distribution strategy based on statistics and clustering. We evaluate our system and data distribution strategy by comparing with others. The results show that our strategy performs effectively and can improve the performance of ScaMMDB.