摘要
介绍数据集市的构建思想,并探讨在油矿勘探中运用包含一个事实表和几个纬度表的星型模型和多种微软软件构建数据集市的方法和过程,实现了多维数据立方体和各种OLAP操作。在油矿勘探中基于多维模型的数据集市比数据仓库更容易开发和实现,而且方便使用。
The paper introduces the construction of thinking of data mart, and discusses the method and process of applying the star model, which contains one fact table and several latitude tables, and some Microsoft software to build the data mart in exploration survey of oil field. To achieve multidimensional data cube and various OLAP operation. It indicates that in the ex- ploration survey of oil field,the data mart based on multidimensional model is easier to develop and to be put into use come true, and convenient than data warehouse.
出处
《现代电子技术》
2007年第24期104-105,111,共3页
Modern Electronics Technique
关键词
多维模型
数据集市
OLAP
油矿勘探
multidimensional model
data mart
OLAP
oil field exploration
