which Nosql Database is suited for a table with static schema and too much number of rows -

there table 5 columns , no more. size of each row less 200 bytes number of table rows may increased several tens of billions during time.

the application storing data @ rate of 100 per second or more. once these data stored, never updated removed after 1 year. not read many times though, may queried selecting within time range, e.g. selecting rows given hour in given day.

questions

1. which type of nosql database suited this?

2. which of these databases best suited? (doesn't have listed)

if oracle license includes partitioning option, partition month or year, , if most/all of queries include date column partitioned on, dramatically. makes dropping year's worth of data take few seconds.

as others noted in comments, depends on how data being returned query. if query returning millions of rows, yes, may take 15 minutes. oracle can handle queries against billion row tables in few seconds if criteria restricting enough , appropriate indexes present, , statistics gathered appropriately.

so how many rows returned 15 minute query?