Font Size: a A A

Study And Application Of Main Memory Database In Color Ring Back Tone Service

Posted on:2012-01-27Degree:MasterType:Thesis
Country:ChinaCandidate:Y X CaoFull Text:PDF
GTID:2178330335460846Subject:Computer Science and Technology
Abstract/Summary:PDF Full Text Request
In a conventional disk resident database (DRDB) system, data is disk resident, thus transaction processing often requires disk I/O operations. Its architecture is optimized for reducing the amount of disk read and write and increasing disk space usage. Therefore, DRDB support real-time application poorly.In a main memory database (MMDB) system, the primary copy lives permanently in memory. Based on all data is managed in memory, MMDB has new architecture design and new database management technology, as a result, it provide higher access speed, faster response time and greater transaction throughput than DRDB and is widely used in telecommunication, finance, government area and so on.On the other side, color ring back tone (CRBT) service is one of the most important voice value-added services now. Since its inception, it is developed very rapidly, and its number of users is rising. With the continued growth of CRBT service, the amount of data stored in the DRDB is increasing, and the performance bottleneck of database access is gradually exposed, which restricts the efficiency of the whole CRBT system.As a result of disk I/O limit, performance improvement is very limited by optimizing DRDB, therefore new database solutions are needed to find. The high real-time, low latency and large concurrent provided by MMDB just fit the requirements of CRBT service, thus MMDB can be used to solve the performance bottleneck of CRBT system.Accordingly, in this paper, after the research of MMDB technology, it is innovatively applied to the CRBT system and is used to reconstruct the CRBT call database, in order to solve the bottleneck of database access and improve the performance of the CRBT system. Test results show that, after using MMDB, the throughput of database has been raised by 100%, the average latency of call processing has been reduced by 50% and the CPU utilization has been significantly decreased, namely the performance of CRBT system has been efficiently improved.This paper gives a brief introduction to MMDB technology and the background knowledge of the CRBT service firstly. By analyze the performance bottleneck of database access in CRBT system, it brings forward the necessity of rebuild the CRBT call database.Then the paper elaborates the implementations of using MMDB in CRBT system, including the whole schema and the specific design of each module. It explains the method of modify the original system and the solution of technical problem encountered.The next part discusses the design and implement of the performance test program for MMDB in the CRBT service and test the MMDB's performance by using the program. Then the paper analyzes and discusses the test results.At last, in combination with practical experience, the paper gives some advices about application of MMDB, points out the next step and views the future of MMDB technology.
Keywords/Search Tags:Main Memory Database, Color Ring Back Tone, Database Performance, Performance Test
PDF Full Text Request
Related items