I hope the Cassandra Community can help me finding a decision.

The project i am working on actually is located in industrial plant, machines are connected to a server an every 5 minutes i get data from the machines about its status. We are talking about a production with 100+ machines, so the data amount is very high:

Per Machine every 5th minute one row,
means 12 rows per hour, means roundabout 120 rows per day = 1200+ rows per day
multiplied by 20 its 240.000 rows per month and 2.880.000 rows per year. I have to hold
the last 3 years and i must be able to do analytics on this data. in the end i deal with roundabout 10 Mio Rows (12 columns holding text and numbers each row)
Okay, its kind of big data is not really  "big data" isn'it  but for me its a lot data to handle anyway.
Actually i am holding all these data in a oracle database but doing analytics on so many rows
 is not the good and modern way i think. as the company is successfull they will grew, means more machines, again more data to handle...

So i thought maybe Big Data technologies are a possible solution for me to store my data.

Meanwhile i know Apache Hadoop is not the right tool for this kind of thing because it scales not down.But maybe Cassandra ? This is my question to you, do you think cassandra is the right store for this kind of data?

I am thinking about 2 Nodes. Maybe virtual.

Let me know what you think. And if Cassandra is not the right tool please tell me and if you know any please tell me alternatives. Maybe i am already doing the right thing with storing that much data in oracle database and maybe one of you is doing the same - if so please let me also know.

Thank you very much.


Web: http://www.teufel.net