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.
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?
Sorry for my long winded question. But I have a case in my company where we r trying to choose between HANA and Aerospike. 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.
I like Aerospike a lot because it provides automatic failover, clustering, redundancy and it can handle very high requests per second. Can HANA handle that kind of loads and provide automatic clustering, automatic addition of nodes on need basis etc.
Thanks a lot for your answers.