Hi All,

I've used Hibernate before in a number of small projects, but this one has come up and has me a little stumped as to how I might implement it.

I'm building a system to receive, process and store SNMP traps for a period of up to 1 year. Due to the number being received (> 1,000,000 per day), we need to split the data up between multiple daily tables. The problem, of course, is that most querying is likely to be over a 7, 30 or 90 day block, with some queries as much as a year, so I ideally want some kind of data model which can transparently determine what tables to query, and fetch them.

Has anyone built something which operates similar to this? I'm basically looking for a starting point, as this is uncharted territory for me.

Thanks

Have you considered some kind of Business Intelligence approach? Rolling up the data necessary into other tables too?