Design Of Customer Profit And Loss Analysis System Based On HANA Database

With the development of finance environment, a strong competitionoccurred among security companies. XiaHai Securities Co. Ltdneeds to setup a customer profit and loss analysis system to provide personalizedservices. However, a great delayin data update and calculation is caused by a huge quantity of customer data in this company. HANA database contains both line and row storage tables also include Object-based storage technology. Those technologies letmodern multi-core CPU architecture design and parallel processing canbe fully usedinHANA database. HANA database is applied on customerprofit and loss analysis systemwhich could provide chart and analysisin real-time.Firstly, thedemands of customerprofit and loss analysis systemare analyzed. Then, the deep influencein business which caused by low executeefficiency in existing applicationare explicated in thesis, to clear up the necessity of use HANA database to solvethe problems. After introduce main functions of the system, layered architecture system based on HANA database is analyzed. The subsystem such as customer breakeven ratiocalculation and customer classificationare designed in detail. This thesis mainly shows how the data incustomer breakeven ratiocalculation subsystem are modeled and how the breakeven calculation is realized in HANA database. Finally, thecharacteristics and applied effects in real time analyze and calculateof thecustomer profit and loss analysis system based on HANA database are evaluated.