基于OLAP的秦皇岛港口煤炭生产数据分析及可视化应用

OLAP-based Analysis and Visual Application of Coal Production Data at Qinhuangdao Port

从秦皇岛港的基础数据出发,运用OLAP数据分析技术,通过维度建模的方式构建了港口船舶、堆场、设备、费收、客户等煤炭生产主题数据仓库模型,使用时间序列指数平滑预测对数据进行预处理,基于OLAP体系结构,对模型中的数据抽取、转换和加载给出了详细分析与设计,针对所选主题设计和实现了OLAP多维分析功能,实现对煤炭生产数据的多角度、多侧面、多层次综合分析,完成港口煤炭生产数据可视化应用体系建设,为港口管理者提供可靠、直观的有效数据支撑。

In this paper, starting with the fundamental data of the Qinhuangdao port, we used the OLAP process to build the data library model for such involved subjects of the port as vessels, storage yards, equipment, charges and customers, etc., used the time series exponential smoothing forecasting to pre-treat the data in advance, and then based on the OLAP architecture, analyzed and designed in detail the extraction, conversion and loading of the data in the model. In this way, we designed and realized the OLAP multi-dimensional analytic function for the subjects chosen, rendered the coal production data available for multi-perspective, multi-faeeted and multi-layered analysis and accomplished the construction of the port coal production data visualized application system.