Thanks for your detailed response.
I have a case in my company where we r trying to choose between HANA and Aerospike. Aside from being in memory RDBMA, HANA has another advantage that it provides an organic Predictive Analytics Library built in with tight integration with R. You could write stored procedures intermingled with R code and run predictive analytics and do statistical stuff which will be useful for intelligent ad targeting.
How do you or other ad targeting companies achieve Predictive capabilities through Aerospike?
From whatever limited knowledge I have gathered about Aerospike, I know that it provides secondary indexes and it also provides LDT’s which kind of serve the purpose of denormalizing the table structures in traditional RDBMS systems. Both of these features and the tabular, bin/record based functionality makes me feel that Aerospike can actually replace RDBMS systems like HANA which markets itself as an in memory relational database. What are your thoughts on this?
Am I right in my assumption that Aerospike could potentially totally replace RDBMS systems. Yes, aerospike does NOT provide features like joins across many tables which are sometimes useful for reporting purposes. But there could be a way around that too by using UDFs?
I like Aerospike a lot because it provides automatic failover, clustering, redundancy and it can handle very high requests per second. I am not sure yet whether HANA can handle that many TPS and how seamlessly it handles failover, rebalacing. It seems that it does require a significantly higher manual configuration and tuning.
Thanks a lot for your reply