The Research And Application Of Online Billing System Memory Database

In order to improve the existing online billing products in the international marketadvantage, we decided to develop a high degree of self-independent, fast, safe, easy touse in-memory database instead of TimesTen, while seamlessly with existing dockingsystem, and CustCache, RuleCache be replaced, to simplify the complexity of existingsystems, reduce system coupling. Through this system, you can release to promote thevarious billing, online billing system to provide a complete, manageable solution. Thebilling system for health-memory database is Quick Memory DataBase, this articlereferred to QMDB.Introduction QMDB memory database system, for our billing system brings someobvious advantages. First, QMDB as an independent system, similar to the ODBCinterface can form, called by the application, using dynamic link library loaded into theapplication system, QMDB any changes and upgrades, will not affect the application, sothe system can not affect the case of upgrading the application, amendment; Second, itcan solve a variety of data exist in the system, because the current system of datastorage mechanism is very complex, Oracle data, TimesTen data, CustCache data andRuleCache data each table to change table structure or increase the information needs tochange in the corresponding application code, this application brings to us a certaindegree of complexity and instability, the developer had to taking some time to develop,verify, test have assigned personnel-related test validation, so no doubt will bedistributed development, testing, personnel effort. By QMDB memory database, datastorage mechanism and the Oracle database data into a data memory two, greatlysimplifying system complexity, and when the application of a change in table structure,without having to modify the code, just change what the script can handle, sodevelopers have more energy to handle the business logic; Third, the existing TimesTenin-memory database is very expensive, the use of QMDB can reduce the cost ofprocurement of products and create market opportunities, and improve profitability.R&D QMDB, mainly for billing the field of data processing. Therefore, taking into account the characteristics of accounting data and technical difficulties, abandonedthe TimesTen features, in addition to the TT several functions: First, multi-table searchand update the association; Second, the data transaction control; third, the dynamicsheet restructuring; fourth, many to many data backup.