Would it be preferable to use the Vectorwise based system for efficient data analysis as contrast to OLAP cubes. I have the idea that vector-wise single instruction, multiple data (SIMD) could be good but don't have much good material and resources to design the system.
How can I create a data warehouse in PostgreSQL and then use the vectorwise technology to enhance the fetching, drilling and slicing, dicing operation.
I tried to study the redshift, zoho and they are utilizing/relying on http://www.actian.com/ for their services. What are the good ways to incorporate the cost effective vectorwise technologies.
Looking into different solution and database management techniques, i found that multidimensional arrays are much suitable structure for computing large volumes of data. Vectorwise , HP vertica all are good commercially viable solutions and have the ability of MPP (Massively parallel processing) and SIMD that make them of great use.
I found some open source and multidimensional arrays based DBMS and its comparison can be found here. http://www.slideshare.net/jdegoes/rise-of-the-scientific-database