Computer Science – Databases
Scientific paper
2010-06-08
TELKOMNIKA Vol. 8, No. 1, April 2010, pp. 25 - 34
Computer Science
Databases
10 pages, 12 figures and 4 tables
Scientific paper
The emergence of new higher education institutions has created the competition in higher education market, and data warehouse can be used as an effective technology tools for increasing competitiveness in the higher education market. Data warehouse produce reliable reports for the institution's high-level management in short time for faster and better decision making, not only on increasing the admission number of students, but also on the possibility to find extraordinary, unconventional funds for the institution. Efficiency comparison was based on length and amount of processed records, total processed byte, amount of processed tables, time to run query and produced record on OLTP database and data warehouse. Efficiency percentages was measured by the formula for percentage increasing and the average efficiency percentage of 461.801,04% shows that using data warehouse is more powerful and efficient rather than using OLTP database. Data warehouse was modeled based on hypercube which is created by limited high demand reports which usually used by high level management. In every table of fact and dimension fields will be inserted which represent the loading constructive merge where the ETL (Extraction, Transformation and Loading) process is run based on the old and new files.
No associations
LandOfFree
Tata Kelola Database Perguruan Tinggi Yang Optimal Dengan Data Warehouse does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Tata Kelola Database Perguruan Tinggi Yang Optimal Dengan Data Warehouse, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Tata Kelola Database Perguruan Tinggi Yang Optimal Dengan Data Warehouse will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-39117