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.
齐玮,王秀芳,王翔宇 . 军队院校图书馆数据仓库设计[J]. 现代图书情报技术, 2006, 1(8): 77-79.
Qi Wei,Wang Xiufang,Wang Xiangyu . Data Warehouse Design of Military Institute Library. New Technology of Library and Information Service, 2006, 1(8): 77-79.
2W. H. Inmon. Building the Data Warehouse. New York: John Wiley&Sons,1996
3Ralph Kimball, Margy Ross 著， 谭明金 译数据仓库工具箱：维度建模的完全指南北京：电子工业出版社，2003