|
|
Data Warehouse Design of Military Institute Library |
Qi Wei Wang Xiufang Wang Xiangyu |
(Shanxi Xi’an Second Artillery College, Xi’an 710025, China) |
|
|
Abstract This paper takes the Second Artillery College’s library as an example and explains the design of military institute library data warehouse in detail. The warehouse is based on the multidimensional data model and realized by Microsoft SQL Server 2000. It solves the problem of consistent storage of slowly changing historical data in warehouse by a slowly changing disposal on dimension table. This paper also proposes a new method to assess the use ratio of books in library.
|
Received: 15 May 2006
Published: 25 August 2006
|
|
Corresponding Authors:
Qi Wei
E-mail: xinqiwei@126.com
|
About author:: Qi Wei,Wang Xiufang,Wang Xiangyu |
1(加)韩嘉炜,(加)坎伯(Kamber,M.)著,范明等译数据挖掘:概念与技术北京:机械工业出版社,2001
2W. H. Inmon. Building the Data Warehouse. New York: John Wiley&Sons,1996
3Ralph Kimball, Margy Ross 著, 谭明金 译数据仓库工具箱:维度建模的完全指南北京:电子工业出版社,2003 |
|
Viewed |
|
|
|
Full text
|
|
|
|
|
Abstract
|
|
|
|
|
Cited |
|
|
|
|
|
Shared |
|
|
|
|
|
Discussed |
|
|
|
|