We present a study of the following warehouse view-selection problem: Given a frequency distribution on parameterized aggregate queries on a data warehouse, return definitions of aggregate views that, when materialized in the warehouse, would minimize the evaluation costs of the frequent queries, subject to a storage limit constraint. Optimizing the layout of stored data using view selection ha...

Warehouse location selection is a multi-criteria decision problem including both quantitative and qualitative criteria and has a strategic importance for many companies. The conventional approaches to warehouse location selection problem tend to be less effective in dealing with the imprecise or vague nature of the linguistic assessment. Under many situations, the values of the qualitative crit...

a r t i c l e i n f o Keywords: Data warehousing Data warehouse architecture Archictecture selection Independent data marts Bus architecture Enterprise data warehouse Hub and spoke Federated Even though data warehousing has been in existence for over a decade, companies are still uncertain about a critical decision — which data warehouse architecture to implement? Based on the existing literatu...

Keywords: Facilities design and planning Warehouse design Warehouse performance evaluation model Case studies Computational tools a b s t r a c t This paper presents a detailed survey of the research on warehouse design, performance evaluation, practical case studies, and computational support tools. This and an earlier survey on warehouse operation provide a comprehensive review of existing ac...

The use of materialized views in a data warehouse installation is a common tool to speed up mostly aggregation queries. The problems coming along with materialized aggregate views have triggered a huge variety of proposals, such as picking the optimal set of aggregation combinations, transparently rewriting user queries to take advantage of the summary data, or synchronizing pre-computed summar...