Selecting and materializing horizontally partitioned warehouse views

C.I. Ezeife
2001 Data & Knowledge Engineering  
Data warehouse views typically store large aggregate tables based on a subset of dimension attributes of the main data warehouse fact table. Aggregate views can be stored as 2 n subviews of a data cube with n attributes. Methods have been proposed for selecting only some of the data cube views to materialize in order to speed up query response time, accommodate storage space constraint and reduce warehouse maintenance cost. This paper proposes a method for selecting and materializing views,
more » ... h selects and horizontally fragments a view, recomputes the size of the stored partitioned view while deciding further views to select.
doi:10.1016/s0169-023x(00)00044-6 fatcat:gj4blndzhvdohlxw5xbzgp3uvq