is there a way I can benchmark Oracle, Elasticsearch, Kudu, Couchbase and Mongo in terms of performance? If I have an SQL query which is slow on an Oracle DB, how can I test same on the other platform?
What factors do I need to consider for the performance benchmark?
According to me, each one has its own purpose. In my opinion it is not comparable.
These are different technologies.
For instance, Oracle is a RDBMS but Mongodb is a document oriented NoSQL database.
So, in this kind of an environment, you can't compare apple to apple (in terms of query performance).
However; you can built solutions, built your design according to the standard of the related technology and then access your data using the technics that are provided by those techonologies and compare your access times.
SQL performance is important, but consistency is important too. Actually, the things that matter depend on your requirements and scenarios.
The type of the data, the access method, pattern, frequency and concurreny, the application that sits on top of the database are some of the things that you need to consider while comparing the databases and choosing the right one.
So keep these in mind and approach the subject accordingly.