Muhammad Saqib

Improve Data Warehouse Performance

"Data Warehouse Performance Improvement Technique exploiting Materialized and Sub-Materialize Views"

• Broschiertes Buch

Produktbeschreibung

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.

Produktdetails

• Verlag: LAP Lambert Academic Publishing
• Seitenzahl: 60
• Erscheinungstermin: 23. Juni 2010
• Englisch
• Abmessung: 220mm x 150mm x 4mm
• Gewicht: 107g
• ISBN-13: 9783838373416
• ISBN-10: 3838373413
• Artikelnr.: 30561269

Autorenporträt

Muhammad Saqib Awan have done Masters in Computer Sciences, IQRa University, Peshawar Campus with specialization in Communications & Networks and Masters in Information Technology(M.Phil) from IM Sciences, Peshawar, Pakistan with specilization in Enterprise Resource Planning. Currently working as Member Faculty, IM Sciences, Peshawar.