Design of Data Warehouse in Library Circulation using Pentaho

Totok Suprawoto

2019

Abstract

Library is a source of knowledge that can be accessed by students, lecturers and employees both from inside and outside campus. Library as a tool that can be used for the development and improvement of knowledge for its members, plays an important role in disseminating information and providing references for the academic community. Current and previous circulation of lending and returning data books can be stored in a data warehouse. Data warehouse is a database that is designed to work on the query process, create reports and further analysis for the decision making process. In this research, 5 dimensions have been designed, namely: the time dimension, the member dimension, the publisher dimension, and the author dimension. Furthermore, it is implemented using 2 fact tables, namely: borrowing tables and book returns tables. Data Warehouse that has been built can be used by management to use certain software to produce information that can be used for decision making.

Download


Paper Citation


in Harvard Style

Suprawoto T. (2019). Design of Data Warehouse in Library Circulation using Pentaho.In Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST, ISBN 978-989-758-453-4, pages 59-63. DOI: 10.5220/0009431200590063


in Bibtex Style

@conference{conrist19,
author={Totok Suprawoto},
title={Design of Data Warehouse in Library Circulation using Pentaho},
booktitle={Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST,},
year={2019},
pages={59-63},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0009431200590063},
isbn={978-989-758-453-4},
}


in EndNote Style

TY - CONF

JO - Proceedings of the International Conferences on Information System and Technology - Volume 1: CONRIST,
TI - Design of Data Warehouse in Library Circulation using Pentaho
SN - 978-989-758-453-4
AU - Suprawoto T.
PY - 2019
SP - 59
EP - 63
DO - 10.5220/0009431200590063