The Design And Implementation Of Visualization Platform For Securities’ Business Data Based On OLAP

With the information construction of major security companies has be en carried out for a long period of time, almost every company owns m any information systems such as the Centralized Trading, Risk Control, Customer Relationship Management, and many other information systems. These systems have been built in improving the quality of management, or in the efficiency of the office staff at all levels as well as the compa ny’s benefit and so on, have achieved remarkable achievements. The co mpany where I practice has implemented information construction for ma ny years, it currently owns dozens of systems, our team have collected dozens of external sources to build data center. As the result, data volu me grows very fast, and the reports used for analysis also grows rapidly. Factly, the team where I practise haven’t developed a set of reporting and analysis system.In this paper, we design and implement a data visualization platform for secuties’ business data based on olap modeling technology based o n above reason, which presents part of the data center, letting the intern al staff complete their report development and business analysis work eff ectively, finally resulting in a more efficient management. The system ad opts olap itech include ETL and modeling, and uses spingMVC to develo p.This paper addresses these following questions: Optimize data warehouse ETL process, briefly presented optimization; How to design a data model suitable for our situation; How to design a springMVC model right according our situation.In this paper, according to the structure of our department as well a s personnel and hardware situation, we proposed a project different from other data warehouse technology, and utilize a different development pro cess with the traditional MVC design, in order to speed up development, at the same time to reconcile design specifications.