The question asked is very generic by any firm. There are so many tools out there in market, each tool satisfies these requirements in one way or other. If you want In-Memory capabilities for faster retrieval QlikView/Sense or Oracle Exalytics is an option; if you want…