SAS SPDS: Efficient and high performance way of data storage
What do you like best?
SAS Scalable Performance Data Server, aka SAS SPDS, is one of the perfect way of storing (huge volume) data. It is one of the most efficient and scalable way in which SAS stores the data by creating multiple indexs. It stores the data by partitioning it into multiple physical files. SPDS has multiple processors, and each processor spawns multiple parallel threads, thus working on each partition in parallel. SPDS further manages each of the multiple partitions giving end user an illusion as if they are working on one single table.
What do you dislike?
The thing I dislike about SAS SPDS is that it is a bit tricky to manage, especially when it comes to managing the metadata, granting permissions etc. I personally have struggled a lot in granting access to data created by one one in one department, to other user in other department. But, once the settings are done, it is easy for all, including administrator like me.
Recommendations to others considering the product:
It gives a lot better performance when compared to using SAS without SPDS, especially when the data is extremely huge. So yes, I would recommend using the product.
What problems are you solving with the product? What benefits have you realized?
We have multiple departments who have huge volumes of data. The data is so huge that without SPDS performance was meager, but once SPDS was implemented, the performance has improved drastically.