Rancang Bangun Data Warehouse Berbasis Star Scheme StudiKasus : SMK Negeri 4 Garut

Agus Mulyana, Bobby Holili Abadi, A Arief Rachman, Septian Rheno Widianto

Abstract


SMK Negeri 4 Garut has Academic Information System which is used to support the academic service for academicians. Currently, the data on that information system has not become a data source as a support to make a decision. This paper shows the system of Data Warehouse which can give the historical data which is subject oriented that can be anaylized to be various information needed by top-level management. Star Schema Model to build the database modelcases. Some cases of information-requests are also conveyed equipped by solutions in the form of relational algebra and Structured Query Language (SQL).


Full Text:

PDF

References


Amborowati, A. (2010). Perancangan Data Warehouse pada Perpustakaan STMIK AMIKOM Yogyakarta. Jurnal Dasi Vol.11 No.1 Maret 2010 ISSN: 1411-3201.

Breslin, M. (2004). Data warehousing battle of the giants. Business Intelligence Journal, 6-20.

Chandra, A. (2010). Perancangan Data Warehouse Pada Software Laboratory Center. ComTech: Computer, Mathematics and Engineering Applications 1(2), 585-597

Connolly, T. M., & Begg, C. E. (2010). Database Systems: A Practical Approach to Design, Implementation, And Management. Boston: Pearson Education

E., W., A., S., N. H., A., & Hamid, N. A. (2016). Users’ Satisfaction and Return on Investment (ROI) for Online Database Library Databases: A Malaysian Technical University Perspective. Procedia-Social and Behavioral Science, 777-783.

Foster, E. (2016). Database systems: a pragmatic approach. New York: Apress.

Goonetillake J.S., Wikramanayake G.N. (2010) Managing Very Large Databases and Data Warehousing.Sri Langkan Journal of Librarianship and Information Management. Vol. 2, No. 1, Hal. 22-29.

Inmon W. H. (2005). Building the Data Warehouse 4th Edition, Indianapolis: Wiley Publishing, Inc.

Inmon, W. H., & Hackathorn, R. D. (1994). Using the Data Warehouse. New York: John Wiley & Sons.

Kimball, R., & Margy, R. (2002). The Data Warehouse toolkit: the complete guide to dimensional modelling. New York: John Wiley & Sons. Kimball, R., & Margy, R. (2010). The Kimball Group Reader: Relentlessly Practical Tools For Data Warehousing and Business Intelligence. First Edition. Indianapolis: John Wiley & Sons.

Poniah, P. (2001). Data Warehouse Fundamentals: a Comprehensive Guide for IT Professional. New York: John Wiley & Sons.

Widianto, Septian Rheno. (2018). Desain dan Analisa Algoritma Steganografi dengan Metode Spread Spectrum Berbasis PCMK (Permutasi Chaotic Multiputaran Mengecil dan Membesar) Menggunakan Matlab. Jurnal Elekra. Vol 3 No 1. Purwakarta. ISSN: 2503-0221.

Widianto, Septian Rheno. (2018). Desain Algoritma Steganografi dengan Metode Spread Spectrum Berbasis PCMK (Permutasi Chaotic Multiptaran Mengecil dan Membesar) Yang Tahan Terhadap Gangguan. Prodi Teknologi Rekayasa Perangkat Lunak Politeknik Enjinering Indorama Kembang Kuning Ubrug Jatiluhur, Purwakarta. p- ISSN : 2407 – 184 e ISSN : 2460 –8416, 2018.


Refbacks

  • There are currently no refbacks.


Copyright (c) 2020 Seminar Nasional Teknologi Komputer & Sains (SAINTEKS)