z-logo
open-access-imgOpen Access
Data warehouse Implementation on Denpasar City Online Community Complaints System
Author(s) -
I Putu Ari Putra Wijaya,
Wahyudin Wahyudin,
Made Mataram
Publication year - 2017
Publication title -
international journal of engineering and emerging technology
Language(s) - English
Resource type - Journals
eISSN - 2579-5988
pISSN - 2579-597X
DOI - 10.24843/ijeet.2017.v02.i01.p14
Subject(s) - data warehouse , schema (genetic algorithms) , computer science , executor , star schema , table (database) , dimension (graph theory) , database , world wide web , information retrieval , database design , business , mathematics , finance , database schema , pure mathematics
Department of Communications and Informatics, appointed as Executor of Handling Complaint Society in Denpasar City. Over time and more complex data complaints that come in so complicate the data analysis, to overcome the data it is necessary implementation of data warehouse. The method used is Snowflake Schema, this method is chosen because this method is the development of star schema where each dimension table can have sub-table dimension. It aims to minimize data overload. From the results of the implementation in get the conclusion that by implementing data warehouse can facilitate the user in view report in accordance with the desired from summary to detail.. Keywords—Data Warehouse, Snowflake Schema, ETL.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.
Having issues? You can contact us here
Accelerating Research

Address

John Eccles House
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom