基于动态交叉表的Web多维分析系统设计与实现

Design and Implementation of Multidimensional Analysis System of Web Based on Dynamic Crosstab

在业务复杂的B/S系统中,当需要以多维方式组织数据并在web上显示时,为了解决使用传统的OLAP方式会遇到的诸多难题,提出了一种基于动态交叉表的web多维分析方法。该方法通过使用多维分析建立交叉表视图,应用Oracle数据库的PL/SQL对视图实现动态刷新,以及应用Struts构架和优秀的开源工具JFreeChart等技术,实现了多维分析数据在web上的动态更新,有效地解决了系统开销大、难于在web上表现等问题。该方法在云南省大型仪器协作共用网系统中得到了良好的应用。

Presents a new method of implement multidimensional analysis on the web based on dynamic crosstab to solve the problems which may occur in the complex B/S system if using traditional OLAP way to statistic and display lots of data in the multidimensional form on the web. This method applies many technologies such as establishing crosstab view using multidimensional analysis, updating view dynamically using Oracle database PL/SQL,applying Struts framework and excellent open source tool JFreeChart and so on. It realized the multidimensional analysis data dynamic update on the web. This system solved many problems effectively such as big system expenses and difficult to display. This method has received good effect in the Yunnan Super Instrument Network Shared System.