The Design Of Main Memory Database System Based On The Dynamic Monitoring System

The dynamic monitoring system of key transportation vehicle realizes the road transport industry data acquisition,and completes all kinds of road transport data exchange,push and sharing between Ministry and province or province and provinc.This system has realized the data exchange and sharing as a turnkey system of key transportation vehicle,so efficiency of data exchange is important for the system.The dynamic data of vehicles of the system has some features of large data flow,database operation frequently,high coincidence of database read and write.The current database management subsystem manages all the data on the disk,which is disk database management.Because of huge data traffic,disk database need to frequently access the disk for the operation of the data, frequent operation is complex and can’t meet the needs of high complicated with huge amounts of data real-time response.At a faster rate of reading and writing than the disk database,Main Memory Database System has designed a new architecture,all data are managed in memory,and it also made the corresponding improvement In the data cache, the fast algorithm,parallel operation,which made data processing speed relative to the traditional database data processing have the great leap forward.Memory technology continues to mature and it’s price is more and more low in recent years,which provides support and economic feasibility for us to transform the system disk database to in-memory database.In this paper, according to the orientation and goal of the key transportation vehicle dynamic monitoring system,follow enterprise integration oriented methodology of the Oracle,use the Memcached TimesTen database memory products of the Oracle and open source NOSQL database to design the architecture of memory subsystem of the key transportation vehicle dynamic monitoring system. This paper mainly completed the following several works:master database related theory,study the theory of Oracle and TimesTen database; install the deployment of Oracle database and TimesTen database,and establish list structure which is required for corresponding business-critical data in the Oracle database as well as the memory database;put forward the corresponding data access method,the relevant configuration, interface service as well as the way and the method introduced in the application for implementing different associations between relevant list structure;establish a release method of Webservice,and install the deployment Webservice mechanism based on database access, and business through the WSDL interface;combine the data in the memory database and disk database to practice in a specific system for application implementation;the purpose of the application and practice is compare data access performance of disk database with memory database.Through a year of research,design,and development to the final deployment,the project realized introduce memory database TimesTen as the second level cache in the database which real-time synchronized with the database;introduce the Memcached as the third level cache database stored query results and establish a release method of Webservice.After deployment,the system enters the application state and achieve the desired effect;through testing access efficiency is greatly increased compared with the original disk database systems.