Do you understand the differences and applications of "row stores" versus "column stores"? If SQL databases are optimized for the retrieval of entire rows or r

Do you understand the differences and applications of "row stores" versus "column stores"? If SQL databases are optimized for the retrieval of entire rows or records, column stores are optimized for the storage and analysis of entire columns in a database (similar data types allows for greater compression and bringing much more data into memory.) I don't know if anyone has implemented a database optimized for array processing, but the benefit for predictive modeling should be obvious. I'm sure optimization for GPU processing wouldn't hurt either.