Memory Database Application-oriented Research

Main memory database(MDB) loads data entirely into main physical memory and manages data in memory, which effectively resolves the disk resident database (DRDB) system's contradiction between CPU and disk I/O. With the emergence of 64 bits CPU and operating system, the restriction of only max supporting 2GB memory for 32 bits system has been relieved and provides a very beneficial opportunity for the development of MDB. MDB is mainly used in embedded systems, online-billing systems, stock trades systems etc. The data reading and writing speed of memory is higher orders of magnitude than disk. Traditional DRDB may not satisfiy the requirement of real-time performance, and the price of software itself, database, service and technology support are all factors people choose a database product. Designing and developing a MDB system which can meet real-time performance needs and can replace RDBMS in software development is of great applied value and practical significance.This thesis puts forward client/server supported application-oriented MDB architecture by mainly studying MDB theories and related key technologies, optimizes data structures in memory, designs and implements the MDB finally.Because the data in the memory is volatile, how to make the MDB system completely recover from failure quickly by valid measures, and ensure data integrality and high availability is a main work of the thesis. For application-oriented MDB, backup and restore schemes on the basis of redo log and checkpoint file etc are the key for MDB's recovery. MDB's high availability is enabled by researching database replication technology and replication architecture.Finally, the correction and performance of MDBS'data processing are verified by system testing.