Data warehouse applications in libraries - The development of library management reports

Yi Ting Yang, Jiann Cherng Shieh

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Data warehouse is a consolidate information repository that provides online analytical processing tools for the interactive data analysis and exploration. Decision-makers could explore the data warehouse with different dimensions and appropriate concept hierarchies to report results they require. However, for library actual practices, the current general ways to produce reports are to query related tables of library automation systems by appropriate designed SQL commands based on their own professional works. It is time-consuming and inflexible. Therefore, the purpose of this study attempts to develop data warehouse applicable to library applications. We analyzed the reports requirements of Taiwan public city and university libraries and then design the fact tables and dimension tables of corresponding data warehouse. We implemented such data warehouse from data of some public library automation system. The results show that applying data warehouse to generate reports of libraries is feasible and efficient.

Original languageEnglish
Title of host publicationProceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016
EditorsAyako Hiramatsu, Tokuro Matsuo, Akimitsu Kanzaki, Norihisa Komoda
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages88-91
Number of pages4
ISBN (Electronic)9781467389853
DOIs
Publication statusPublished - 2016 Aug 31
Event5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 - Kumamoto, Japan
Duration: 2016 Jul 102016 Jul 14

Publication series

NameProceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016

Other

Other5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016
CountryJapan
CityKumamoto
Period16/7/1016/7/14

Keywords

  • Data Warehouse
  • Dimensional Model
  • Library Reports
  • Public Library

ASJC Scopus subject areas

  • Information Systems
  • Computer Networks and Communications
  • Computer Science Applications
  • Computer Vision and Pattern Recognition

Fingerprint Dive into the research topics of 'Data warehouse applications in libraries - The development of library management reports'. Together they form a unique fingerprint.

  • Cite this

    Yang, Y. T., & Shieh, J. C. (2016). Data warehouse applications in libraries - The development of library management reports. In A. Hiramatsu, T. Matsuo, A. Kanzaki, & N. Komoda (Eds.), Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 (pp. 88-91). [7557581] (Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/IIAI-AAI.2016.129
https://scholar.lib.ntnu.edu.tw/en/publications/data-warehouse-applications-in-libraries-the-development-of-libra
scholar.lib.ntnu.edu.tw
crawl=CC-MAIN-2020-29
44323
application/http; msgtype=response
sha1:I2BYGTL76VR33CTEJSWA2577UF2ZL25U
<urn:uuid:e00c23f0-7ee8-406d-96e2-478fe792f636>
2020-07-08T02:34:56Z
52.220.215.79
text/html
sha1:4IAX5OY4CWPRVJMM43DH2HC6FZGMRQ6I
<urn:uuid:06365a1e-d336-46db-8c41-9781a16944f9>
https://scholar.lib.ntnu.edu.tw/en/publications/data-warehouse-applications-in-libraries-the-development-of-libra
response
<urn:uuid:8d84f6c3-bed1-43db-be65-821a838b3f96>
isPartOf: CC-MAIN-2020-29
publisher: Common Crawl
description: Wide crawl of the web for July 2020
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-124.ec2.internal
software: Apache Nutch 1.17 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.2-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/