Perancangan Data Warehouse Pada Bagian Akademik Universitas di Bandung

Abstract

Data Warehouse is a centralized database, the source of data warehouse is a history of operational database and any other source data. Data Warehouse generates reports and analyses related to organizational or user needs, and it's used as a decision making tool. University in Bandung have an Academic Directorate which records and processes information about new students, active students, accreditation of study programs, and student graduation. The Academic Directorate has three external data sources for Online Transaction Processing (OLTP), namely the New Student Admissions System (PMB), Integrated Academic Information System (SAT), and Graduate System. Academic Directorate doesn't have an Online Analytical Processing (OLAP), The data processing in the Academic Directorate still uses the manual way of query the OLTP databases and imported to Microsoft Excel format. Academic Directorate takes about 1 (one) to 3 (three) days to process the data into information because the required data is scattered in some storage media that has not integrated well as a data storage. This research have a purpose to build data warehouse as an OLAP system for Academic Directorate of University in Bandung.

Keywords: Academic, Database, Data Warehouse.