i have discovered monetdb , evaluating internal project, questions newbie point of view. maybe point me site and/or document find more info (i haven't found googling)
regarding scalability, correct me please if wrong, understand if need scale, launch more server instances , discover them control node, right? there limit on number of servers?
the other point storage, possible use amazon s3 monetdb readonly instances?
update need store massive amount of call detail records different sources, on read-only basis. aggregate/reduce data day-to-day operation, accessing bigger tables when full detail required. store historical data perform longer-term analysis. concern memory, disk storage wouldn't issue think; if hot dataset involved in report/analysis eats whole memory space (fast response times needed, not sure how memory swapping impact), know if can scale somehow instead of reingeneering report/analysis process (maybe biased horizontal scaling thing :-) )
thanks!
you find advantages of monetdb on net let me highlight disadvantages
1. in monetdb deleting rows not free space
solution: copy data in other table,drop existing table, , rename other table
2. joins little slower
3. can can not give table name dynamic variable
eg: if have table name stored in 1 main table can't make query "for each (select tablename mytable) select data tablename)" sql can't make functions tablename variable argument.
but still damn fast , can store large amount of data.
Comments
Post a Comment