Design And Implementation Of Stock Warehouse System Based On HBase

In finance,securities and other traditional industries,database and warehouse usually use centralized physical hardware architecture,in order to ensure system stability and reliability,combine minicomputers and mainframe with high-end mass storage became most commonly adopted solution.The advantages of this architecture are obvious,simple management,excellent performance,and highly security.But both capital costs and maintenance costs are high,so usually scale database and warehouse vertically.In order to prevent data loss,creating backup site in another data center for disaster recovery will increase costs further more.Due to the amount of data will continue to increase,when the longitudinal extension arriving at the hardware is limited,the system will be poor extensibility,long-distance backup is difficult,even increase a lot of money into the system,it is difficult to solve system bottleneck.In this paper,I analyzed the problems of the stock exchange system.And I have offered new proposals for the warehouse which use the Hbase to saving data.B/S architecture was used in the system.HBase was used to store user data,and Servlet and JSP provide the display of the front interface,it use Apache to provide HTTP services,and the JEE7 batch model was used in this system to control the batch process for payroll.By using the HBase warehouse stock system,has realized the production database to HBase database real-time transmission.It has a good user experience in the user query stock orders subsystem,user cash flow query subsystem,and other functions.At the same time,it provides the summary of the users of capital,to help users to analyze its own profit.It Provide data for user behavior analysis.This system reduce the load of the stock's OLTP database system,and decrease the cost of the system,and it easy to expand the data warehouse system,when the user continues to grow,you just need to horizontal extending Hadoop and Hbase.