Unlike in traditional row-oriented databases where the attributes of a record are placed contiguously in row-oriented order, a column-oriented database system stores data in column-oriented order. For applications such as data warehouse and decision support systems that access large volumes of data in a read-intensive manner, the column-based compressed database has become a proper model because of its superior read performance. Currently, flash memory SSD is largely recognized as the preferred storage media for the high-speed analysis systems. However, PRAM is better than flash memory in the respects of read and write performance. Even though the capacity of PRAM is still low, the appliance of mass capacity PRAM would be the important trend soon. In this paper, we introduce a compressed column-based storage model and various memory technologies. We also propose a new indexing scheme and its data management for a high-capacity data warehouse system. The proposed scheme achieves superior performance using a duplex index management and PRAM storage for large column databases. Our simulation results show that overall search and update performance can be enhanced by around 10% and 23%, respectively. Our scheme also outperforms the traditional scheme in terms of the response time.