摘要
数据粒度决定着数据仓库的数据量和回答查询的能力。多重粒度在一定程度上既可以满足数据量的要求,又可以满足回答查询能力的要求,所以在设计数据仓库时,多重粒度成为首选。而当数据仓库采用多重粒度时,就面临着如何管理数据粒度的问题。本文研究粒度级别和多重粒度,在此基础上提出用粒度表进行数据粒度的管理,阐述粒度表的定义过程,分析粒度表的优点,并提出基于粒度表的数据仓库多维模型的构建过程。
Data granularity decides the amount of data in data warehouse and the ability to answer queries. Multiple-granularity can not only satisfy the requirements of the amount of data to a certain extent, but also meet the requirements of the ability to an- swer queries. So in the design of data warehouse, multiple-granularity becomes the preferred. When the data warehouse using multiple-granularity, we will face with how to manage data-granularity problem. This paper firstly studies granularity level and multiple-granularity, puts forward granularity table in order to manage data granularity, expounds the definition process of granu- larity table, analyzes the advantages of granularity table ; and puts forward the process of data warehouse multi-dimensional model based on granularity table.
出处
《计算机与现代化》
2013年第10期91-93,共3页
Computer and Modernization
关键词
数据仓库多维模型
数据粒度
粒度级别
多重粒度
粒度表
data warehouse multi-dimensional model
data granularity
granularity level
multiple-granularity
granularity table
