Submission + - Ask Slashdot: Choosing a database
bis22111978 writes: "I am looking at storing data from all the energy measuring meters in the surrounding. I am assuming that the maximum number of energy measuring meters will be 100,000.
I believe that the data will be streaming from all the meters concurrently.I would like to come out with a low cost storage solution. Should I use a normal RDBMS (Postgres,MySql etc) or a NoSQL database? Which database use will be leveraged in a better way? Can I use R easily to run analytic s from the chosen dataset in a reliable and fast manner? Please share your thoughts and experience in the scenario I have described. All your thoughts and reviews will be very helpful."
I believe that the data will be streaming from all the meters concurrently.I would like to come out with a low cost storage solution. Should I use a normal RDBMS (Postgres,MySql etc) or a NoSQL database? Which database use will be leveraged in a better way? Can I use R easily to run analytic s from the chosen dataset in a reliable and fast manner? Please share your thoughts and experience in the scenario I have described. All your thoughts and reviews will be very helpful."