期刊名称：International Journal of Advanced Research In Computer Science and Software Engineering
印刷版ISSN：2277-6451
电子版ISSN：2277-128X
出版年度：2013
卷号：3
期号：6
出版社：S.S. Mishra
摘要：Data Warehouse (DW) is a collection of subject-oriented data, integrated, nonvolatile and historize d. It following different schema (star, snowflake, constellation). It is supplied from different data sources via des analytical data to assist in decision making in Business Intelligence.should be able to handle the diversity of data, query complexity and workload in order to meet the complex decisionsupport queries whose processing time can take several hours. To improve the performance of DWs, the administrator uses different optimization techniques: indexing, materialized views, fragmentation and parallelism.ch suggested in this paper is a query optimization technique in DWs using a Woptimization is based on the horizontal fragmentation (primary and derived) of DW star schema. In order to facilitate roach will be accessible via a Web service that automatically both generates gmentation schema and scripts needed to implement it
