Analysis and Design of Data Warehouse for E-Library Using Snowflake Schema
Abstract
Information systems have become an important requirement in helping human work, one of which is e-library. This
system is used by librarians in carrying out daily business processes in the library, such as borrowing and returning books,
managing book collections, and procuring the latest book collections so that the library has updated books. Over time, the data
stored in the database will increase a lot, so when analyzing information that requires data with a certain period will take quite a
long time. So, in this case, the use of a data warehouse is needed to help the librarian in providing the information needed. This
research will present a data warehouse design using snowflake schema by following the design stages in Fourth Steps Dimensional
Modeling, as one of the solutions in providing the required data warehouse design in the e-library.
Downloads
Download data is not yet available.
References
[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 Implemantation 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.
[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 Implemantation 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.
Published
2020-12-14
How to Cite
MULYAWAN, Made Dwi; SWAMARDIKA, Ida Bagus Alit; SAPUTRA, Komang Oka.
Analysis and Design of Data Warehouse for E-Library Using Snowflake Schema.
International Journal of Engineering and Emerging Technology, [S.l.], v. 5, n. 2, p. 154-159, dec. 2020.
ISSN 2579-5988.
Available at: <https://ojs.unud.ac.id/index.php/ijeet/article/view/60075>. Date accessed: 25 apr. 2024.
doi: https://doi.org/10.24843/IJEET.2020.v05.i02.p26.
Section
Articles
Indexed By
