Improve Data Warehouse Performance

Materialized views can be used in a number of ways. It can be used in distributed databases for replication and can also be used for efficient provision of data to a query through query re- writing. The process of data provision to queries can further be expedited if dependent child views are created on an already existing materialized view. Furthermore, these child-views are automatically created upon the creation of the base materialized view with some restrictions. This results in less-user dependent activity of creation of materialized views based on some parameters. These parameters are the number of child- materialized views and the type of the data a view contain. In this thesis, a balanced approach is suggested to create sub-materialized views to answer user queries without consulting the fact table or parent materialized view that results in avoidance of resource intensive calculations and joining of multiple tables.

Autorentext

Muhammad Saqib, diplômé en botanique de l'Université d'éducation de Lahore, est spécialisé dans la diversité de la flore, l'écologie et la phytogéographie. Il a contribué à la recherche sous la supervision du Dr Zaheer Abbas et a fait partie d'équipes universitaires primées. Saqib est titulaire d'un diplôme d'informatique TEVTA et travaille actuellement chez Multan Chemical Limited.