Memory Database And Its External Interface

Database (Database) is a data warehouse which is organized,stored and managed by the structure of data.Along with the development of information technology and the market, the development of the theory and technology of Database are also extremely rapidly, and in today's world of the information, Database is more and more widely application. However, the traditional disk database whose main job version is preserved in the nonvolatile storage devices on disk, therefore when the data is operated or managed by database system,and the system often need to visit data from disk accesses which is inside the thick, then the memory will be on data processing, when processing is finished and then the data which is in memory will write back to disk. Since disk database needs many operations with disk I/O, and disk due to its characteristics of mechanical equipment, disk I/O operation at a slower speed.The influence of the I/O speed will also great, so disk database of I/O is its performance bottleneck. When real-time access to large amounts of data, the limit of I/O can cause the contradiction between disk database systems CPU and the I/O.At the same time, because of the development of mobile end, mobile communications need to provide more and more types of data services, in the coming of age as the 3G, telecom industry has become the data intensive industries, user data update ceaselessly, for switch system in real-time more and more high, it will need to greatly improve the speed of data exchange. The traditional hard disk database will wait for a variety of bottleneck because its I/O, and it cannot satisfy the demand on speed. In order to achieve data can be quickly a lot of memory requirements, memory database (MMDB) caused.Memory database will work in memory. Because of the version in the database is read and taked operation in memory, and the data of reading and writing operation is realized in the memory which is faster than disk several orders of magnitude higher, the data stored in memory access data from disk while access large real-time data, not only solved the main contradiction between database CPU and disk I/O,but also it can improve application performance.Based on mobile communication network management system, analyzed the exterior in-memory databases of internal data acquisition and data storage and management, studied the realization of the communication interface in-memory databases, and memory database interior theory knowledge and technology, including the in-memory databases storage management, memory database index, transactional, memory database of debris processing and data cache, etc.According to the requirement of design, this system provides the following functions:memory database external communication interface, thread management function, the message queue management, data definition (table, indexing, queue, etc), data operation (data insert, and delete, modify, inquires the);This paper designed and implemented memory database management system meets the management system of telecommunication networks need "real-time, stable, flexible" actual requirements.