Improve Data Warehouse Performance
% SALE
Improve Data Warehouse Performance
% SALE
% SALE
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.
Product details
- Type:
- Book
- Binding:
- Paperback
- Languages:
-
Original:
English
- Number of Pages:
-
60
- Publisher:
-
LAP LAMBERT Academic Publishing
- Publication Date:
-
2010-06-23
- ISBN / EAN:
-
9783838373416
- Weight:
-
107 g
- Dimensions:
-
15/22/0 cm
- GPSR Manufacturer Reference:
-
[email protected]
Die gelieferte Auflage kann ggf. abweichen.
Currently sold out
Back in stock email
Add to Wishlist