Authors:

I Made Adi Bhaskara, Luh Gede Putri Suardani, Made Sudarma

Abstract:

“Batik product has spread in various regions in Indonesia. Batik companies usually have data that accumulates and accumulates without any follow-up to the data. It is also not supported by well-executed final reports. Therefore it is necessary to build a data warehouse that can be used as a source of information for Batik management related to the trend of the type of batik motif based on the category of goods and marketing area from time to time. One important process that must be done in the operation of data warehouse is the process of copying data from the operational database. Before the operational data goes into the data warehouse, ETL process (extract, transform, load) to the data is done. The process is intended to standardize the data used in the data warehouse. Meanwhile, the scheme designed for the development of data warehouse using Snowflake Schema model. The results showed that batik warehouse data has four dimension tables (Product dimension, Region dimension, Time dimension, and Customer dimension), four sub dimension tables (Category dimension, Sub_Category dimension, Pattern dimension and Gender dimension) and one Fact table, Fact Sales. The extraction process produces dimension tables (Product dimension, Region dimension, Time dimension and Customer dimension) and sub-dimensional tables (Category dimensions, Sub_Category dimensions, Pattern dimensions and Gender dimensions). All monitoring of sales data of batik products is done using cube browser. The information displayed by each dimension can be viewed in more detail with the drill down or roll up process in accordance with the hierarchy rules of each dimension field.”

Keywords

Keyword Not Available

Downloads:

Download data is not yet available.

References

References Not Available

PDF:

https://jurnal.harianregional.com/ijeet/full-39844

Published

2018-07-31

How To Cite

BHASKARA, I Made Adi; SUARDANI, Luh Gede Putri; SUDARMA, Made. Data Warehouse Implemantation To Support Batik Sales Information Using MOLAP.International Journal of Engineering and Emerging Technology, [S.l.], v. 3, n. 1, p. 45-51, july 2018. ISSN 2579-5988. Available at: https://jurnal.harianregional.com/ijeet/id-39844. Date accessed: 28 Aug. 2025.

Citation Format

ABNT, APA, BibTeX, CBE, EndNote - EndNote format (Macintosh & Windows), MLA, ProCite - RIS format (Macintosh & Windows), RefWorks, Reference Manager - RIS format (Windows only), Turabian

Issue

Vol 3 No 1 (2018): January - June

Section

Articles

Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 International License