| OLAP在地下工程监测中的初步应用 |
| |
| 引用本文： | 王浩,葛修润.OLAP在地下工程监测中的初步应用[J].岩土力学,2010,31(2):565-570. |
| |
| 作者姓名： | 王浩 葛修润 |
| |
| 作者单位： | 中国科学院武汉岩土力学研究所,岩土力学与工程国家重点实验室,武汉,430071 |
| |
| 摘 要： | 数据仓库以及针对数据仓库的多维数据分析工具OLAP（即联机分析处理）已开始大量运用于金融业和商业管理中并取得了良好的效果，但在地下工程中的应用很少。介绍了数据仓库和OLAP的基本概念、功能、特点，并针对小湾引水发电系统施工期监测数据库建立了一个简单的OLAP分析，可为管理人员提供快捷、简单、直观的查询，能从时间、测点类型、测点所属建筑物3种维（角度）及其不同层次上分析数据，OLAP与数据仓库技术相结合将是岩土工程安全风险管理的利器，并提出了OLAP技术在地下工程监测中进一步应用的方向。
|
| 关 键 词： | 地下工程 监测 数据仓库 OLAP 多维数据分析 |
| 收稿时间： | 2009-02-02 |
Basic application of OLAP to safety monitoring in underground engineering |
| |
| WANG Hao,GE Xiu-run.Basic application of OLAP to safety monitoring in underground engineering[J].Rock and Soil Mechanics,2010,31(2):565-570. |
| |
| Authors: | WANG Hao GE Xiu-run |
| |
| Institution: | State Key Laboratory of Geomechanics and Geotechnical Engineering, Institute of Rock and Soil Mechanics, Chinese Academy of Sciences, Wuhan 430071, China |
| |
| Abstract: | 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. |
| |
| Keywords: | OLAP underground engineering monitoring data warehouse OLAP multi-dimensional data analyses |
| 本文献已被 万方数据 等数据库收录！ |
| 点击此处可从《岩土力学》浏览原始摘要信息 |
| 点击此处可从《岩土力学》下载免费的PDF全文 |
|
