采用雪花模型的电子图书馆数据仓库的分析和设计

Made Dwi Mulyawan, Ida Swamardika, Komang Oka Saputra
乌达雅纳大学电气和计算机工程系

摘要

信息系统已经成为帮助人类工作的一个重要需求，电子图书馆就是其中之一。被图书馆员使用这个系统来
执行图书馆的日常业务流程，如借书和还书，管理藏书，采购最新的藏书，以更新图书馆书籍。随着时间的推移，
存储在数据库中的数据会大量增加，所以分析需要一定周期数据的信息时，会花费相当长的时间。在这种情况下，
需要使用数据仓库来帮助图书馆员提供所需的信息。本研究将按照四步维度建模中的设计阶段，利用雪花模型提出
一个数据仓库设计，作为在电子图书馆中提供所需的数据仓库设计的解决方案之一。

关键词

数据仓库；雪花模型；四步维度建模；OLTP；信息系统

参考

[1]Connolly, T. M., & Begg, C. E. (2010). Database

Systems: A Practical Approach to Design, Implementation,

And Management. Boston: Pearson Education.

[2]Foster, E. (2016). Database systems: a pragmatic

approach. New York: Apress.

[3]Poniah, P. (2001). Data Warehouse Fundamentals:

A Comprehensive Guide for IT Professional. New York: John

Wiley & Sons

[4]Narendra, A. N., Murpratiwi, S. I. and Sudarma, M.

(2017) ‘Design of E-Grant Application Data Warehouse’,

IJEET (International Journal of Engineering and Emerging

Technology), 2(1), p. 11.

[5]Budiarta, K., Ananta Wijaya, P. A. and Partha, C. G. I.

(2017) ‘Analysis and Design of Data Warehouse on Academic

STMIK STIKOM Bali’, IJEET (International Journal of

Engineering and Emerging Technology), 2(1), p. 35.

[6]Gede, L., Suardani, P. and Sudarma, M. (2018) ‘Data

Warehouse Implementation to Support Batik Sales Information

Using MOLAP’, IJEET (International Journal of Engineering

and Emerging Technology), 3(1), pp. 45–51.

[7]Putra Wijaya, I. P. A., Wahyudin, W. and Mataram,

M. (2017) ‘Data warehouse Implementation on Denpasar City

Online Community Complaints System’, IJEET (International

Journal of Engineering and Emerging Technology), 2(1), p. 67.

[8]Prabawa, I. N. A. et al. (2019) ‘Analysis and Design

Data Warehouse For E-Travel Business Optimization’,

IJEET (International Journal of Engineering and Emerging

Technology), 4(1).

[9]Inmon, W. H., & Hackathorn, R. D. (1994). Using the

Data Warehouse. New York: John Wiley & Sons.

[10]Lane, Paul. (2002). Oracle91 Data Warehousing

Guide. Oracle Corporation.

[11]Kimball, R., & Margy, R. (2002). The Data

Warehouse toolkit: the complete guide to dimensional

modelling. New York: John Wiley & Sons.

[12]Kimball, R., & Margy, R. (2010). The Kimball Group

Reader: Relentlessly Practical Tools for Data Warehousing and

Business Intelligence. First Edition. Indianapolis: John Wiley

& Sons

[13]K. A. B. Permana, G. B. Subiksa, and M. Sudarma

(2017), “Design Data Warehouse for Centralized Medical

Record,” IJEET (International Journal of Engineering and

Emerging Technology), vol. 2, no. 2, pp. 47–51

[14]Ambara, M. P., Sudarma, M. and Kumara, I. N. S.

(2016) ‘Desain Sistem Semantic Data Warehouse dengan

Metode Ontology dan Rule Based untuk Mengolah Data

Akademik Universitas XYZ di Bali’, MITE (Majalah Ilmiah

Teknologi Elektro), 15(1), p. 8. doi: 10.24843/mite.2016.

v15i01p02.

[15]Iswardani, P. R., Pramana, I. W. S. and Saputra, K. O.

(no date) ‘Design of Data Warehouse for Monitoring Hotel’s

Food and Beverage Cost’, IJEET (International Journal of

Engineering and Emerging Technology), vol. 4, no. 1, pp. 1–4.

[16]Shobirin, K. A., Iskandar, A. P. S. and Swamardika,

I. B. A. (2017) ‘Data Warehouse Schemas using

Multidimensional Data Model for Retail’, IJEET (International

Journal of Engineering and Emerging Technology), 2(1), p. 84.

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

[17]Sudarmojo, Y. P. (2018) ‘Design of Library Data

Warehouse Using OLTP Result of Services Analysis’,

IJEET (International Journal of Engineering and Emerging

Technology) 3(1), pp. 62–65.

[18]Pradhana, I. G. N. A., Giriantari, I. A. and Sudarma,

M. (2018) ‘Analisis dan Perancangan Sistem Pengelola Data

Menuju Implementasi Data Warehouse Untuk Mendukung

Administrasi E-Procurement’, MITE (Majalah Ilmiah

Teknologi Elektro), 17(2), p. 245. doi: 10.24843/mite.2018.

v17i02.p12.

[19]Sulastra, I. M. D. J., Sudarma, M. and Kumara, I.

N. S. (2015) ‘Pemodelan Integrasi Nearly Real Time Data

Warehouse Dengan Service Oriented Architecture Untuk

Menunjang Sistem Informasi Retail’, MITE (Majalah Ilmiah

Teknologi Elektro), 14(2), p. 11. doi: 10.24843/mite.2015.

v14i02p03.

[20]Anshari, M., Suryadharma, I. P. and Rinas, I.

W. (2017) ‘Implementation of Data Warehouse in Human

Resource Information System Using SEM-GeSCA’,

IJEET (International Journal of Engineering and Emerging

Technology), 2(1), p. 16.