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

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

Fingerprint

Data warehouses
Automation
Processing

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

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

Data warehouse applications in libraries - The development of library management reports. / Yang, Yi Ting; Shieh, Jiann-Cherng.

Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016. ed. / Ayako Hiramatsu; Tokuro Matsuo; Akimitsu Kanzaki; Norihisa Komoda. Institute of Electrical and Electronics Engineers Inc., 2016. p. 88-91 7557581 (Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016).

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

Yang, YT & 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., 7557581, Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016, Institute of Electrical and Electronics Engineers Inc., pp. 88-91, 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016, Kumamoto, Japan, 16/7/10. https://doi.org/10.1109/IIAI-AAI.2016.129
Yang YT, Shieh J-C. Data warehouse applications in libraries - The development of library management reports. In Hiramatsu A, Matsuo T, Kanzaki A, Komoda N, editors, Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016. Institute of Electrical and Electronics Engineers Inc. 2016. p. 88-91. 7557581. (Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016). https://doi.org/10.1109/IIAI-AAI.2016.129
Yang, Yi Ting ; Shieh, Jiann-Cherng. / Data warehouse applications in libraries - The development of library management reports. Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016. editor / Ayako Hiramatsu ; Tokuro Matsuo ; Akimitsu Kanzaki ; Norihisa Komoda. Institute of Electrical and Electronics Engineers Inc., 2016. pp. 88-91 (Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016).
@inproceedings{07d778a844f949989fb9bf2818bbc554,
title = "Data warehouse applications in libraries - The development of library management reports",
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.",
keywords = "Data Warehouse, Dimensional Model, Library Reports, Public Library",
author = "Yang, {Yi Ting} and Jiann-Cherng Shieh",
year = "2016",
month = "8",
day = "31",
doi = "10.1109/IIAI-AAI.2016.129",
language = "English",
series = "Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
pages = "88--91",
editor = "Ayako Hiramatsu and Tokuro Matsuo and Akimitsu Kanzaki and Norihisa Komoda",
booktitle = "Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016",

}

TY - GEN

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

AU - Yang, Yi Ting

AU - Shieh, Jiann-Cherng

PY - 2016/8/31

Y1 - 2016/8/31

N2 - 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.

AB - 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.

KW - Data Warehouse

KW - Dimensional Model

KW - Library Reports

KW - Public Library

UR - http://www.scopus.com/inward/record.url?scp=84988888019&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84988888019&partnerID=8YFLogxK

U2 - 10.1109/IIAI-AAI.2016.129

DO - 10.1109/IIAI-AAI.2016.129

M3 - Conference contribution

AN - SCOPUS:84988888019

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

SP - 88

EP - 91

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

A2 - Hiramatsu, Ayako

A2 - Matsuo, Tokuro

A2 - Kanzaki, Akimitsu

A2 - Komoda, Norihisa

PB - Institute of Electrical and Electronics Engineers Inc.

ER -