OLAP在地下工程监测中的初步应用

Basic application of OLAP to safety monitoring in underground engineering

数据仓库以及针对数据仓库的多维数据分析工具OLAP(即联机分析处理)已开始大量运用于金融业和商业管理中并取得了良好的效果,但在地下工程中的应用很少。介绍了数据仓库和OLAP的基本概念、功能、特点,并针对小湾引水发电系统施工期监测数据库建立了一个简单的OLAP分析,可为管理人员提供快捷、简单、直观的查询,能从时间、测点类型、测点所属建筑物3种维(角度)及其不同层次上分析数据,OLAP与数据仓库技术相结合将是岩土工程安全风险管理的利器,并提出了OLAP技术在地下工程监测中进一步应用的方向。

As a type of multi-dimensional data analytical tool, OLAP （on-line analytical processing） and data warehouse have got a lot of uses in finance and business but had few uses in underground engineering. Some of these applications made a good profit for enterprises. The conception, function, features of data warehouse and OLAP are introduced briefly. A basic OLAP application was built for Xiaowan hydropower plant underground powerhouse. The example shows that OLAP can provide quick, easy and visualized queries from multi-viewpoint, such as observed time, measure point types and construction types, and different stages for top managers. Combining with data warehouse, OLAP will be very useful in safety management for geotechnical engineering. And the future direction of OLAP application to underground engineering is discussed.