Data Warehouse Schemas using Multidimensional Data Model for Retail

Shobirin, Kheri Arionadi; Iskandar, Adi Panca Saputra; Swamardika, Ida Bagus Alit

doi:10.24843/ijeet.2017.v02.i01.p17

Cited by 3 publications

(3 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Langkah berikutnya adalah mengidentifikasi dimensi yang berhubungan dengan tabel fakta. Tabel dimensi biasanya memiliki record data yang relatif lebih kecil dibandingkan dengan Tabel Fakta, tetapi setiap record mungkin memiliki sejumlah besar atribut untuk mendeskripsikan data [18]. Dari hasil identifikasi maka kemudian dapat ditentukan dimensi yang terlibat adalah dimensi waktu, dimensi server, dimensi malware, dimensi intrusion dan dimensi attack seperti yang terlihat pada Tabel 4.…”

Section: Identifikasi Dan Penyesuaian Dimensiunclassified

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Asmita,

Henny,

Samidi

2023

J. Tek. Inform. (JUTIF)

View full text Add to dashboard Cite

Central Government, is a government agency that manages important and confidential state data and information. The data that is managed needs to be maintained for reliability and security in order to avoid the risk of loss, leakage and misuse of information. To maintain this data, an optimal information security device is needed. Information security tools used today have a variety of functions resulting in many important logs that must be managed, analyzed and evaluated. The log data from each of these information security devices is still separate and must be processed manually to obtain simpler and more efficient data so that it can be monitored and presented to management. The purpose of this research is to make the right data warehouse modeling in order to assist in the process of presenting information quickly and accurately related to the processing of data logs of information security devices as a report that will be given to management in support of the Zero Tollerance data security policy. The method used in designing this data warehouse is using the Kimball 9 step method. The results obtained are in the form of a starflake schema and a data warehouse log of information security devices consisting of a malware fact table, intrusion facts and attack facts that can be used as centralized data monitoring that will be implemented at the Security Operation Center. Testing is done using Pentaho software tools. This data warehouse is expected to provide a quick, accurate, and continuous summary of information so that it can assist management in the decision-making process and policy making for the future.

show abstract

Section: Identifikasi Dan Penyesuaian Dimensiunclassified

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Asmita,

Henny,

Samidi

2023

J. Tek. Inform. (JUTIF)

View full text Add to dashboard Cite

show abstract

“…Several advantages are obtained when implementing a starschema in data warehouse development, including simplifying query, simplifying reporting logic, improving query, performance, and accelerating data aggregation [17].…”

Section: Multidimensional Data Modelingmentioning

confidence: 99%

Development of Star-Schema Model for Lecturer Performance in Research Activities

Amin¹,

Sutrisman²,

Dwitayanti³

2021

IJACSA

View full text Add to dashboard Cite

In this study, the researchers developed a multidimensional data model to investigate the activities of lecturers in universities in carrying out research activities as part of the Three Pillars of Higher Education. Information about lecturers' research activities has been managed using spreadsheet (excel) documents. Thus, access and analysis of the information were limited. Data warehouse development was carried out through several stages, namely requirement analysis, data source analysis, multidimensional modeling, ETL process, and reporting. The information generated in this data warehouse (DW) can be used as one of the business intelligence (BI) models in universities. In this study, the star-schema model was used in designing dimension tables and fact tables to facilitate and speed up the query process. The information generated in this study can be used by management in universities to make decisions and strategic planning. The results of this study can also be used as one of the important information in the preparation of institutional accreditation data and study program accreditation. Keywords-Data warehouse (DW); star-schema; multidimensional data; business intelligence (BI) I. INTRODUCTIONLecturers as one of the intellectual assets in higher education have one of the activities that are part of the Three Pillars of Higher Education, namely carrying out research and community service. Every year there is a lot of funding to carry out research and community service activities. This funding source comes from the ministries of education, culture, research, and technology, as well as from local governments, and internal universities.This research and community service information is used as one of the assessment criteria in the preparation of study program accreditation instruments and university accreditation. Currently, at Politeknik Negeri Sriwijaya, research data and community service are documented at the Research and Community Service Center (Pusat Penelitian dan Pengabdian kepada Masyarakat abbreviated as P3M) Politeknik Negeri Sriwijaya, in the form of spreadsheet (excel) file data, without being further managed into useful information for upper management in the decision-making process.

show abstract

“…Every IT retail store certainly has a data warehouse that stores sales transactions every day even as a whole since the beginning of the sale [10] [11]. Armed with this transaction data, the seller can process the data with data mining [12].…”

Section: Introductionmentioning

confidence: 99%

Implementation of Association Rules to Manage Cross-Selling and Up-Selling for IT Shop

Indrawan

Saputra²,

Linawati³

2020

IJEET

View full text Add to dashboard Cite

Nowadays sales marketing strategies in showrooms are increasingly innovative. Utilizing information technology, especially data mining to obtain customer habits in shopping. Customer's shopping habits are recorded in each transaction and stored in a data warehouse. This transaction data is actually very valuable and can be elaborated to be used to manage cross selling and up selling in sales stores, including IT showroom stores. IT Showroom stores usually have unusual or unexpected customers shopping for IT needs. Therefore this potential can be exploited for analysis to get behavior from customers by analyzing transactions in a certain period of time using the Rapidminer application. Rapidminer is a fit application to solve this problem because it is equipped with various algorithms, one of which is association rules. Association rules are algorithms that can be used to analyze data and produce recommendations for cross selling and up selling.

show abstract

Data Warehouse Schemas using Multidimensional Data Model for Retail

Cited by 3 publications

References 0 publications

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Data Warehouse Modelling Information Security Log Management in Building a Security Operation Center in Central Government Agencies With Kimball Method

Development of Star-Schema Model for Lecturer Performance in Research Activities

Implementation of Association Rules to Manage Cross-Selling and Up-Selling for IT Shop

Contact Info

Product

Resources

About