The Analysis And Design Of Main Memory Database Storage Structure

Disk resident database management system has met the traditional business and management applications well. With the development of mobile communication techniques and the diversification of people's needs, more types of data services are provided, especially 3G is coming, the telecom field has become a data-intensive industry. One of the key challenges which current information systems deal with is how to efficiently handle the information explosion brought about by the huge amounts of data, more high performance database system is needed as the underlying support. Disk database systems can not meet the real time and near real time data access requirements, with the improvements of computer hardware and software technology, as the core data can resident in memory, designing high-performance main memory database management system has become possible.This paper firstly studies the main memory database management systems theories, including main memory database definition, the difference between main memory database and disk database management systems, data storage management, indexing, and other technologies. Secondly, introduce of the concepts and methods of designing the system, focusing on the storage management design of the main memory database management system; the index design, including the B-tree index and the T-tree index to be achieved; the design and implementation of the main memory database management system indexing technology, is theoretical analysis and research to meet the actual demand "real time, stable, flexible", but also through specific practice tests, compare the insert, query, delete efficiency.In summary, in response to the realities of today's data explosion, the main memory database will still exist a broad application space and great potential, which is worth further analysis and mining.