Embedded Database Based Enterprise-level Financial System Client Side Optimization

With the quick development of information technology, traditional financial trading is replaced with electronic trading systems. Some financial trading systems have the requirement of handling a large amount of data on their client side, and an effective local data management and cache mechanism is needed. Embedded database is an ideal choice as they are small, flexible and convenient.This paper does a research on embedded database based financial system client side optimization. In this paper, we firstly give a brief introduction to the research background and the current development of embedded database technology. Then we give a case study of foreign exchange trading system and analyze the necessity of integrating embedded database on its client side. After that, we analyze current embedded database products and chose db4o as our target embedded database. Then we does a research, analysis and test on db4o. Based on the result, we propose a configurable, reusable and easy-to-integrate framework DB Cache to integrate and encapsulate the embedded database. Then we take the foreign exchange trading system as an example to illustrate how to integrate the framework with the client side system. Finally, we did a test on the embedded database integrated client side system and analyze the optimization of data storage and performance.