Donia Ali Elbastawissy <br/><br/>
Optimized data warehouse for banking systems /  
 مستودع بيانات مثالى للنظم البنكية 
Donia Ali Elbastawissy ; Supervised Ehab Hassanein , Neveen Elgamal 
 - Cairo :   Donia Ali Elbastawissy ,   2020 
 - 110 Leaves :   charts ;   30cm  
<br/><br/>Thesis (M.Sc.) - Cairo University - Faculty of Computers and Artificial Intelligence - Department of Information Systems 
<br/><br/> Data Quality, Database Testing, and ETL Testing are all different ways and techniques for testing Data Warehouse Environment. Testing the data became very important as we should guarantee that the data is accurate for further manipulation and decision making. A lot of tools came up supporting the automation of testing data warehouse, some of them support only the automation of running the scripts, some support the automation of creating the scripts, and others are just organizing and managing the cycle of testing. However, banking environment still faces a lot of challenges that are not yet solved by the different approaches and tools.This thesis presents an elaborative testing strategy that includes specifications for test cases especially for banking environment challenges and how to automate these test cases scripts. The proposed strategy outperformed the traditional technique used by the case study bank for nearly more than 10 years and reduced the cost of working hours of the quality Assurance (QA) team up to 89 percent 
<br/><br/>
<br/><br/><label>Subjects--Index Terms: </label>Banking systems  Data warehouse  Quality Assurance (QA)