| 基于动态交叉表的Web多维分析系统设计与实现 |
| |
| 引用本文： | 马帅,刘利军,黄青松.基于动态交叉表的Web多维分析系统设计与实现[J].计算机技术与发展,2007,17(9):113-115,119. |
| |
| 作者姓名： | 马帅 刘利军 黄青松 |
| |
| 作者单位： | 昆明理工大学,信息与自动化学院,计算机系,云南,昆明,650051 |
| |
| 摘 要： | 在业务复杂的B／S系统中，当需要以多维方式组织数据并在web上显示时，为了解决使用传统的OLAP方式会遇到的诸多难题，提出了一种基于动态交叉表的web多维分析方法。该方法通过使用多维分析建立交叉表视图，应用Oracle数据库的PL／SQL对视图实现动态刷新，以及应用Struts构架和优秀的开源工具JFreeChart等技术，实现了多维分析数据在web上的动态更新，有效地解决了系统开销大、难于在web上表现等问题。该方法在云南省大型仪器协作共用网系统中得到了良好的应用。
|
| 关 键 词： | 多维分析 动态交叉表 |
| 文章编号： | 1673-629X（2007）09-0113-03 |
| 收稿时间： | 2006-11-11 |
| 修稿时间： | 2006-11-11 |
Design and Implementation of Multidimensional Analysis System of Web Based on Dynamic Crosstab |
| |
| MA Shuai,LIU Li-jun,HUANG Qing-song.Design and Implementation of Multidimensional Analysis System of Web Based on Dynamic Crosstab[J].Computer Technology and Development,2007,17(9):113-115,119. |
| |
| Authors: | MA Shuai LIU Li-jun HUANG Qing-song |
| |
| Affiliation: | Dept. of Computer, College of Information and Automatization, Kunming University of Science and Technology, Kunming 650051, China |
| |
| Abstract: | 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. |
| |
| Keywords: | OLAP Struts |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
