Analysis and Design of Data Warehouse for E-Library Using Snowflake Schema

  • Made Dwi Mulyawan Universitas Udayana
  • Ida Bagus Alit Swamardika Universitas Udayana
  • Komang Oka Saputra Universitas Udayana
DOI: https://doi.org/10.24843/IJEET.2020.v05.i02.p26

Abstract

Information systems have become an important requirement in helping human work, one of which is e-library. This
system is used by librarians in carrying out daily business processes in the library, such as borrowing and returning books,
managing book collections, and procuring the latest book collections so that the library has updated books. Over time, the data
stored in the database will increase a lot, so when analyzing information that requires data with a certain period will take quite a
long time. So, in this case, the use of a data warehouse is needed to help the librarian in providing the information needed. This
research will present a data warehouse design using snowflake schema by following the design stages in Fourth Steps Dimensional
Modeling, as one of the solutions in providing the required data warehouse design in the e-library.