Re: [h2] mail flow analytics for a company

2016-04-25 Thread Valentin Popov
I'll try to implement column store top of H2 database and use embedded-druid to make queries to time series data. Are anyone has column store on top of H2 to store time series? среда, 20 апреля 2016 г., 19:41:48 UTC+3 пользователь Valentin Popov написал: > > Ryan, thanks. > > As I read

Re: [h2] mail flow analytics for a company

2016-04-20 Thread Valentin Popov
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

Re: [h2] mail flow analytics for a company

2016-04-20 Thread Ryan How
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:

[h2] mail flow analytics for a company

2016-04-20 Thread Valentin Popov
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