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 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]. >> 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. >> >> >> -- 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.
