计算机与现代化 ›› 2013, Vol. 218 ›› Issue (10): 91-93.doi: 10.3969/j.issn.1006-2475.2013.10.023

• 数据库 • 上一篇    下一篇

数据仓库中数据粒度在电子商务网站中的应用

齐丽娜   

  1. 上海商业会计学校计算机教学部,上海200011
  • 收稿日期:2013-05-17 修回日期:1900-01-01 出版日期:2013-10-26 发布日期:2013-10-26

Application of Data Granularity in Warehouse for E-commerce Website

QI Li-na   

  1. Department of Computer Teaching, Shanghai Commercial Accounting School, Shanghai 200011, China
  • Received:2013-05-17 Revised:1900-01-01 Online:2013-10-26 Published:2013-10-26

摘要: 数据粒度决定着数据仓库的数据量和回答查询的能力。多重粒度在一定程度上既可以满足数据量的要求,又可以满足回答查询能力的要求,所以在设计数据仓库时,多重粒度成为首选。而当数据仓库采用多重粒度时,就面临着如何管理数据粒度的问题。本文研究粒度级别和多重粒度,在此基础上提出用粒度表进行数据粒度的管理,阐述粒度表的定义过程,分析粒度表的优点,并提出基于粒度表的数据仓库多维模型的构建过程。

关键词: 数据仓库多维模型, 数据粒度, 粒度级别, 多重粒度, 粒度表

Abstract: 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 answer 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 granularity table, analyzes the advantages of granularity table; and puts forward the process of data warehouse multi-dimensional model based on granularity table.

Key words: data warehouse multi-dimensional model, data granularity, granularity level, multiple-granularity, granularity table

中图分类号: