Hi, Request your advice and suggestions on deciding what database can we consider other than oracle to store huge volume of transactional data. It is expected to get around 100 millions of data in a day and we need to keep this in the database for any updates not less than 3 months. There is a portal which shows details which these data.
So here the volume is too large which oracle cannot handle. Pls suggest what is the next data that we should consider. Will be helpful if you could state a rough write & read speeds. Note : after 'n' months the data will be moved to Hadoop (any other options?) for analytics with tableau as BI tool. Regards, Rams
