News for hackers. Stuff that matters.
Re:Tell HN: My Web App has 13 Users by aaronblohowiak on Sunday March 17, 2013 @03:53AM (#5388532)
You should not be doing analysis (OLAP) on your main transactional database (OLTP). Moving from transaction-processing system (TPS) to analysis is done through a process call ETL (Extract, Transform, Load.) You will want to transform your data into facts and dimensions -- this is going from a relational model to a multidemensional model (using a star schema.)
Re:Tell HN: My Web App has 13 Users by lubos on Monday March 18, 2013 @03:27PM (#5396559)
but that would be another system to maintain. I'm happy to outsource this to MixPanel or some other company. My needs are pretty generic. I appreciate your response though.
Re:Tell HN: My Web App has 13 Users by aaronblohowiak on Tuesday March 19, 2013 @09:49PM (#5405060)
Yes, I 100% believe in focusing on your core competencies. If the OLAP is self-hosted or external, the key takeaway is to not do analysis against production (once your data set is larger than RAM ;) before that, who cares?)