timeseries is the solution for this?
Posted in 2013
Hi, This question kicks my curiosity , timeseries is a good solution for this kind of situation? Able to "beat" the opensource solutions? Quoting part of the question: "Which database could handle storage of billions/trillions of records?" "We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records..." "We would like to be able to do fast searches (less than 10 seconds) on the data set..." "The idea is to keep approximately one month of data, which would be ~43.2 billion records. A rough estimate that each record would contain about 480 bytes of data, would equate to ~18.7 terabytes of data in a month, and maybe three times that with indexes. Eventually we would like to grow the capacity of this system to store trillions of records." The complete question and details, follow the link. http://dba.stackexchange.com/q/38793/16135 And now a question mine. Innovator-C + timeseries . Anyone have experience using them on real situation? able to saving million or billions of records? And I dare to ask :) able to return fast searchs? Just saying...I don't have experience with timeseries (waiting for a bootcamp on Brazil), and at this moment I don know how exemplify any real situation where apply this questions.... Regards Cesar