Design Amazon/grocerkart that supports the core feature -

1. User should be able to search for an item and buy it

Question : Where should Amazon store the products info to enable low-latency search ? Search should be allowed on multiple parameters such as price range, delivery time, category name, ratings, no. of reviews etc.
My answer : I suggested to use Oracle (with multiple tables) and was rejected.