Ryan, thanks. As I read about data warehouse proper way do it is a star scheme, question is H2 (RDBMS) are designed for that and can handle it? I have experience with graph DB, but load, like for a one day is very slow.
Here is my thinking about H2 tables. Have a couple of tables for (30 min, day, week, month, year) for quick load, and detailed information will be retrieved from 30 min table, I just wary about number of rows there... Maybe better use column oriented DB. Regards, Valentin. среда, 20 апреля 2016 г., 19:06:09 UTC+3 пользователь Kartweel написал: > > Hi, > > You could make it work with that, but it would depend massively on how you > architect your system. You won't just be able to put the records in a > database and then query it with any kind of scalability and performance > expectations. > > Ryan > > > > On 20/04/2016 10:12 PM, Valentin Popov wrote: > > Hello everyone. > > I need write analytics of mail flow in a company for domains and users. > Analytics should contains traffic size/count, attachments size/count, > attachments type, with directions (in/out/internal) with granularity > threshold of 30 minutes. Company with 50 000 employers 50 messages day each > ~ 2 500 000 records day minus some granularity of 30 minutes. Each of 50 > 000 employers has average 100 external contacts, so it will be 5 000 000 > users table. Analytics for such thing should be years... Like zabbix or > nagios. > > Is H2 can handle this? > > Thanks for help. > > Regards, > Valentin. > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
