以军队院校图书馆信息网络系统(Milins)为研究对象,以第二炮兵工程学院图书馆为实例,采用多维数据模型,运用Microsoft的SQL Server 2000设计实现一个数据仓库。通过“维度的渐变性处理”解决数据仓库“历史数据缓慢变化”的一致性存储问题,同时基于数据仓库得出的“在库复本率”和“借出复本率”是评价图书馆图书利用率的一种新方法。
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.
1(加)韩嘉炜,(加)坎伯(Kamber,M.)著,范明等译数据挖掘:概念与技术北京:机械工业出版社,2001
2W. H. Inmon. Building the Data Warehouse. New York: John Wiley&Sons,1996
3Ralph Kimball, Margy Ross 著, 谭明金 译数据仓库工具箱:维度建模的完全指南北京:电子工业出版社,2003