Добро пожаловать в клуб

Показать / Спрятать  Домой  Новости Статьи Файлы Форум Web ссылки F.A.Q. Логобург    Показать / Спрятать

       
Поиск   
Главное меню
ДомойНовостиСтатьиПостановка звуковФайлыКнижный мирФорумСловарьРассылкаКаталог ссылокРейтинг пользователейЧаВо(FAQ)КонкурсWeb магазинКарта сайта

Поздравляем!
Поздравляем нового Логобуржца Алсуша со вступлением в клуб!

Реклама

КНИЖНЫЙ МИР

Improve Data Warehouse Performance   Muhammad Saqib

Improve Data Warehouse Performance

60 страниц. 2010 год.
LAP Lambert Academic Publishing
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.
 
- Генерация страницы: 0.06 секунд -