JOURNAL BROWSE
Search
Advanced SearchSearch Tips
Design and Implementation of multi-dimensional BI System for Information Integration and Analysis in University Administration
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
Design and Implementation of multi-dimensional BI System for Information Integration and Analysis in University Administration
Ji, Keung-yeup; Yang, Hee Sung; Kwon, Youngmi;
  PDF(new window)
 Abstract
As the number of legacy database systems and the size of data to manipulate have been vastly increased, it has become more difficult and complex to analyze characteristics of data. To improve the efficiency of data analysis and help administrators to make decisions in business life, BI(Business Intelligence) system is used. To construct data warehouse and cube from legacy database systems makes it easy and fast to transform raw data into integrated and categorized meaningful information. In this paper, we built a BI system for an University administration. Several source system databases were integrated to data warehouse to build data cubes. The implemented BI system shows much faster data analysis and reporting ability than the manipulation in legacy systems. It is especially efficient in multi dimensional data analysis, nonetheless in single dimensional analysis.
 Keywords
BI(Business Intelligence);OLAP(On-Line Analytical Processing);ETL (Extract, Transform, Loading);Cube;
 Language
Korean
 Cited by
 References
1.
Glossary of Terms. http://www.oranz.co.uk/glossary_text.htm (Accessed Apr., 8, 2016)

2.
S. Y. Huh, "Overview of Business Intelligence Concept," Journal of Information Science Society, Vol. 21, No. 10, pp. 5-11, 2003.

3.
S. Chaudhuri and U. Dayal, “An Overview of Data Warehousing and OLAP Technology,” ACM Sigmod Record, 1997.

4.
J. H. Cho and S. J. Park, Data Warehousing and OLAP, Dae Chung, 1998.

5.
C. M. Choi, Design and implementation of Data WareHouse-based for the Efficient Analysis of Data, Master's Thesis of Hanyang University, 2007.

6.
E. Y. Kim, and H. S. Yong, “Design and Implementation of Multidimensional Data Model for OLAP Based on Object-Relational DBMS,” The journal of Korea Information and Communications Society, 2000.

7.
L. Hamel, “A Brief Tutorial on Database Queries, Data Mining and OLAP,” The Encyclopedia of Data Warehousing and Mining, Idea Group Publishers, 2005.