利用Oracle构建图书馆数字资源仓储系统

Building Digital Resources Warehouse of Library with Oracle

通过构建数据仓库实现图书馆数字资源整合,通过整合图书馆数字资源构建数据仓库,探讨图书馆数据仓库与数字资源整合无缝集成。采用星型结构的维度模式,创建一系列维度表和事实表,搭建馆藏书目、电子图书和电子期刊三个数据集市;利用Oralce 10g提供的数据仓库工具和数据库平台,设计并实现图书馆数字资源仓库概念模型、逻辑模型和物理模型,完成数据抽取、转换和加载,在Oracle数据库平台上建设数据仓库,实现图书馆纸质文献和电子文献的整合。

A data warehouse is built to integrate digital resources of library and vice versa, and to explore the possibility of the seamless integration of data warehouse and digital resources. A set of dimension tables and fact tables, bibliography, electronic books and electronic journals in three data mart are ereated within the hub-and-spoke dimension model. The concept model, logical model and physical model of digital resources warehouse of library are designed and implemented, data extracting, transforming and loading are achieved by using Oracle log data warehouse tools and database platform. Data warehouse is constructed in the Oracle database platform to integrate the paper-based documents and electronic papers of library.