A Novel Storage Architecture of In-Memory Databases Supporting Real-time E-commerce Applications

With growing numbers of suppliers/buyers and the introduction of new additional applications, the simplified and centralized organization of data in the E-commerce systems becomes a focus in reducing operational and capital expenses. With the availability of faster server hardware, network connections and high performance databases, the realization of a common database hosting data for multiple applications becomes technically feasible. However, this kind of deployment will bring new challenges to database systems. One critical challenge is the database should be optimized for real-time accessing databases on large data size. In this report, a novel main memory database architecture based on solid state disks is suggested to meet the requirement. Experiment results shows following benefits can be obtained from the solid state disks: transaction throughput, average response time of write transactions, and database recovery time.