The Research Of Memory Database Query Optional In Multi-core System

At present, with the increase popularity of information technology, handling the real-time data collected on-site and the demand for query processing of the real-time data growing highly, result in the birth of supporting high-performance real-time database. The increasing of memory capacity and reduction cost as well as the emergence of multi-core CPU make high-performance memory-based real-time database possibly. In the memory database, a large number of real-time data need to be dealt with every day, the disk-base database is unable to complete the task. Relying on the advantage of processing real-time data in memory, memory database becomes the mainstream of real-time data processing system. But the memory database also needs to face the same problem as the disk database has being up against with: data querying. In the processing of MMDB, the system may receive thousands of query objects at the same time, this is a great challenge to the memory database.Up to in-depth analysis of SQL statement query in multi-core environment, and combined with the independent development memory database, giving the optimization strategies of SQL statement in the form of figure. Finally, using the search algorithm brought up by this paper to give the optimal execution plan. to test the practicability of the optimal execution plan, The final of this paper makes a simulation test program to compare the optimization execution plan time and general execution plan time, the result of test program has showed that using the optimal execution plan can make the query optimization significantly improved.