(第 23 期)   第十二卷第一期   2017 年 12 月 31 日出刊

圖書館資料倉儲應用模式之研究:以客製化報表為例

The Study of Data Warehouse Application Model in Libraries: A Case Study of Customized Reports

本文關鍵字:資料倉儲圖書館自動化客製化報表Data WarehouseLibrary automation systemCustomized reports

本文摘要

圖書館客製化報表是圖書館管理者亟欲解決的問題之一,圖書館自動化系統廠商對此至今依舊難有具成本效益之解決方案。近幾年,ExLibris 公司針對其自動化系統 Aleph 開發報表系統ARC,提供客戶超過 100 種事先定義的報表。然此報表系統僅支援 Aleph 系統,對國內多數非 Aleph系統圖書館報表需求毫無助益,且無法滿足各館即時性多元報表需求。在基於成本效益及客製化需求,本研究提出以 SQL Server 之資料倉儲應用模式解決以上困境。本研究以實際案例驗證模式之可行性。

The development of library customized reports has always been one of the intractable problems that library managers urgently seek to solve. Similarly, library automation system manufacturers are bruised on this issue, not only the high cost of development services, but also the frequent changes in demand. The problem is still difficult to have by a cost-effective solution. In recent years, ExLibris has developed an add-on system Aleph Reporting Center (ARC) for its library automation system Aleph to provide Aleph customers more than 100 pre-defined statistical reports. However, such reporting systems only support specific automation systems, and cannot fully meet the customized needs of libraries'. Data warehouse technology has been quite mature since the 1970s. Most database management systems such as SQL Server also provide tools to support the establishment of data warehouses. Considering the cost-effectiveness and the demand elasticity of customization, this study proposes the data warehouse application model of libraries to solve the above dilemma. The application model proposed in this research, the system environment is constructed by Microsoft SQL Server, EXCEL; design and development are mainly accomplished by the librarian and system librarian. This study concludes with a practical case to verify the feasibility of the proposed model.
本文附件:

本期同分類其他文章


本刊著作權屬於「中華民國圖書館學會」所有。
Powered By Vanilla Journal - 香草期刊系統 0.256 / 2006 - 2007 © Weizhong Yang