{"product_id":"muhammad-saqib-improve-data-warehouse-performance-9783838373416","title":"Improve Data Warehouse Performance","description":"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.","brand":"LAP LAMBERT Academic Publishing","offers":[{"title":"Default Title","offer_id":54734921793878,"sku":null,"price":0.0,"currency_code":"EUR","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0925\/5829\/5382\/files\/product_image_9783838373416_1.jpg?v=1794834819","url":"https:\/\/www.momoxbooks.com\/products\/muhammad-saqib-improve-data-warehouse-performance-9783838373416","provider":"momox","version":"1.0","type":"link"}