Design and implementation of a data warehouse using dynamic materialized views selection model : the Islamic University of Gaza as a case study
Other Title(s)
تصميم و بناء مستودع بيانات باستخدام نموذج ديناميكي لعملية اختيار التركيبات المجسمة للمستودع : الجامعة الإسلامية بغزة كدراسة حالة
Dissertant
Thesis advisor
University
Islamic University
Faculty
Faculty of Engineering
Department
Department of Computer Engineering
University Country
Palestine (Gaza Strip)
Degree
Master
Degree Date
2017
English Abstract
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
Main Subjects
Information Technology and Computer Science
No. of Pages
128
Table of Contents
Table of contents.
Abstract.
Abstract in Arabic.
Chapter One : Introduction.
Chapter Two : Literature review.
Chapter Three : Design and implementation.
Chapter Four : Proposed materialized view selection model.
Chapter Five : Results and discussion.
Chapter Six : Conclusion and future works.
References.
American Psychological Association (APA)
Shubayr, Bilal Walid Shallash. (2017). Design and implementation of a data warehouse using dynamic materialized views selection model : the Islamic University of Gaza as a case study. (Master's theses Theses and Dissertations Master). Islamic University, Palestine (Gaza Strip)
https://search.emarefa.net/detail/BIM-905018
Modern Language Association (MLA)
Shubayr, Bilal Walid Shallash. Design and implementation of a data warehouse using dynamic materialized views selection model : the Islamic University of Gaza as a case study. (Master's theses Theses and Dissertations Master). Islamic University. (2017).
https://search.emarefa.net/detail/BIM-905018
American Medical Association (AMA)
Shubayr, Bilal Walid Shallash. (2017). Design and implementation of a data warehouse using dynamic materialized views selection model : the Islamic University of Gaza as a case study. (Master's theses Theses and Dissertations Master). Islamic University, Palestine (Gaza Strip)
https://search.emarefa.net/detail/BIM-905018
Language
English
Data Type
Arab Theses
Record ID
BIM-905018
