Design and implementation of a data warehouse using dynamic materialized views selection model : the Islamic University of Gaza as a case study

العناوين الأخرى

تصميم و بناء مستودع بيانات باستخدام نموذج ديناميكي لعملية اختيار التركيبات المجسمة للمستودع : الجامعة الإسلامية بغزة كدراسة حالة

مقدم أطروحة جامعية

Shubayr, Bilal Walid Shallash

مشرف أطروحة جامعية

Ashur, Wisam Mahmud

الجامعة

الجامعة الإسلامية

الكلية

كلية الهندسة

القسم الأكاديمي

قسم هندسة الحاسوب

دولة الجامعة

فلسطين (قطاع غزة)

الدرجة العلمية

ماجستير

تاريخ الدرجة العلمية

2017

الملخص الإنجليزي

Nowadays, business decision-making is moving towards advanced performance evaluation process using standard methods such as Key Performance Indicator (KPI). Performance evaluation process identifies a statistically significant connection between KPIs and related information set.

However, with the volume of transactional data stored in a database in an Operational Data Store (ODS), traditional reporting process depending on joining multiple tables and logical views cannot be efficiently used to extract related information set for KPI due to high complexity and query cost.

The major problem is how to generate the related information set with quality, which abstracts the huge volume of raw data. The scope of this thesis is to design an enterprise Data Warehouse (DW) for Islamic University of Gaza to extract a related information set for its KPIs as a base for Business Intelligence (BI) process.

Additionally, we propose a novel and smart materialize views selection model which handles data warehouse storage and performance issues.

Our model specifies, dynamically, which data marts and dimension tables should be materialized over time in peak intervals of usage of the data warehouse.

Finally, this model is tested over TPCH benchmark and that resulted high reduction of overall MVPP cost.

Also we studied the effect of using DW in IUG and the results show reduction in execution time over 90% for most of views in DW, and it show additional reduction in execution time over 80% for most of views while materializing them

التخصصات الرئيسية

تكنولوجيا المعلومات وعلم الحاسوب

عدد الصفحات

128

قائمة المحتويات

• APA
• MLA
• AMA

لغة النص

الإنجليزية

نوع البيانات

رسائل جامعية

رقم السجل

BIM-905018