Open AccessDesain Dan Implementasi Data Warehouse Pada Perpustakaan Daerah Provinsi Sumatera Selatan
Author(s) -
Nia Adila,
Andri Andri
Publication year - 2021
Publication title -
jurnal nasional ilmu komputer
Language(s) - English
Resource type - Journals
ISSN - 2746-1343
DOI - 10.47747/jurnalnik.v2i1.520
Subject(s) - data warehouse , computer science , database , table (database) , dimension (graph theory) , process (computing) , visitor pattern , dimensional modeling , selection (genetic algorithm) , data collection , data file , operating system , mathematics , artificial intelligence , pure mathematics , programming language , statistics
This research will focus on processing visitor data, member data, book borrowing data and book return data at the Regional Library of South Sumatra Province. The data is stored in the form of an excel file with a large amount of data, causing problems in the storage system such as data accumulation, data loss, no data analysis and delays in the reporting process. The process of data storage and data retrieval will be well integrated by building a data Warehouse at the Regional Library of South Sumatra Province. Data Warehouse is a system that contains several years of history and facilitates decision making. At the data Warehouse design stage using the Nine-Step method (Kimball, 2002), in this method there are nine steps in designing a data Warehouse, namely Process Selection, Grain Selection, Identification of dimensional adjustments, Fact Selection, Storage of initial calculations in the fact table, Reviewing the dimension table, selecting the database duration, tracking dimension changes, and prioritizing, querying the model and selecting the physical design. And the design and data processing process will use the Pentaho kettle and public Tableau applications, with the design and implementation of the data Warehouse, it is expected to help facilitate the reporting and analysis process for the Regional Library of South Sumatra Province.