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 language | English |
|---|---|
| Title of host publication | Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 |
| Editors | Ayako Hiramatsu, Tokuro Matsuo, Akimitsu Kanzaki, Norihisa Komoda |
| Publisher | Institute of Electrical and Electronics Engineers Inc. |
| Pages | 88-91 |
| Number of pages | 4 |
| ISBN (Electronic) | 9781467389853 |
| DOIs | |
| Publication status | Published - 2016 Aug 31 |
| Event | 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 - Kumamoto, Japan Duration: 2016 Jul 10 → 2016 Jul 14 |
Publication series
| Name | Proceedings - 2016 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 |
|---|
Other
| Other | 5th IIAI International Congress on Advanced Applied Informatics, IIAI-AAI 2016 |
|---|---|
| Country | Japan |
| City | Kumamoto |
| Period | 16/7/10 → 16/7/14 |
Fingerprint
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
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 proceeding › Conference contribution
}
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 -