{"product_id":"improve-data-warehouse-performance-von-muhammad-saqib","title":"Improve Data Warehouse Performance","description":"\u003cp\u003eMaterialized 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.\u003c\/p\u003e\u003cdiv class=\"aw-variant-hidden-subtitle-div\" id=\"aw-variant-subtitle-9783838373416\"\u003e\u003ch3\u003e\"Data Warehouse Performance Improvement Technique exploiting Materialized and Sub-Materialize Views\"\u003c\/h3\u003e\u003c\/div\u003e","brand":"Autorenwelt Shop","offers":[{"title":"Softcover - 9783838373416","offer_id":39499093278813,"sku":"9783838373416","price":49.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0940\/0622\/files\/c04cec52-7274-4a99-9e05-d7ed0e8457f9.jpg?v=1758257962","url":"https:\/\/shop.autorenwelt.de\/products\/improve-data-warehouse-performance-von-muhammad-saqib","provider":"Autorenwelt Shop","version":"1.0","type":"link"}