MongoDB for Analytics

MongoDB for Analytics
Tips and Tricks

Vídeo da Apresentação no 7masters (2016/08/31): http://setemasters.imasters.com.br/conversas/mongodb-for-analytics-por-zizaco/

Luiz Fernando / Zizaco

- Software Developer

- Product Owner

- Leroy Merlin (Laravel)

- Keep learning

http://zizaco.net

Devo usar NoSQL e/ou MongoDB?

Quais os pontos que podem levar a decisão de utilizar uma tecnologia NoSQL em uma aplicação para web?

http://tech.leroymerlin.com.br/devemos-usar-nosql-e-mongodb

Analytics is the discovery, interpretation, and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Analytics often favors data visualization to communicate insight.
- Wikipedia

MongoDB for Analytics

- Issues with common bad practices.
-

Outstanding performance from good practices

1.Captura de eventos básica

2.Write concern

3.Time bucketing

4.Aggregate and store (histograms)

4.Aggregate and store (contexts)

5.Pré-aggregation (histograms)

6.TTL ou Capped collection

7. Scaling

Fontes:

MongoDB For Analytics (at Github) - John Nunemaker
https://www.mongodb.com/presentations/mongosv-2012/mongodb-analytics-github

First Steps of an Analytics Platform With MongoDB - Chris Winslett
https://www.compose.com/articles/first-steps-of-an-analytics-platform-with-mongodb/

How Buffer Uses MongoDB to Power Our Growth Platform - Sunil Sadasivan

https://overflow.buffer.com/2014/07/09/how-buffer-uses-mongodb-to-power-its-growth-platform/

Pre-Aggregated Reports - docs.mongodb.com
https://docs.mongodb.com/ecosystem/use-cases/pre-aggregated-reports/

TTL Indexes - docs.mongodb.com
https://docs.mongodb.com/manual/core/index-ttl/

MongoDB Real-time Data Collection and Stats Generation - Damon Cortesi

http://www.slideshare.net/dacort/mongodb-realtime-data-collection-and-stats-generation

Transcript

1. MongoDB for Analytics Tips and Tricks
2. Who am I? • Software Developer • Product Owner • Leroy Merlin (Laravel) • Keep learning http://zizaco.net Luiz Fernando / Zizaco
3. Devo usar NoSQL e/ou MongoDB? Quais os pontos que podem levar a decisão de utilizar uma tecnologia NoSQL em uma aplicação para web? tech.leroymerlin.com.br/devemos-usar-nosql-e-mongodb
4. Analytics Analytics is the discovery, interpretation, and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Analytics often favors data visualization to communicate insight. - Wikipedia
5. MongoDB for Analytics Issues with common bad practices. Outstanding performance from good practices
6. 1.Captura de eventos básica
7. 2.Write concern
8. 2.Write concern ?
9. 3.Time bucketing
10. 4.Aggregate and store (histograms)
11. 4.Aggregate and store (histograms)
12. 4.Aggregate and store (contexts) db.events.aggregate(...) db.users.update(...) db.eventsHistogram.insert(...) db.fooBar.insert(...)
13. 5.Pré-aggregation (histograms)
14. 5.Pré-aggregation (histograms)
15. 6.TTL ou Capped collection
18. 6. Scaling
19. 7. Scaling more
20. Fontes MongoDB For Analytics (at Github) - John Nunemaker https://www.mongodb.com/presentations/mongosv-2012/mongodb-analytics-github First Steps of an Analytics Platform With MongoDB - Chris Winslett https://www.compose.com/articles/first-steps-of-an-analytics-platform-with-mongodb/ How Buffer Uses MongoDB to Power Our Growth Platform - Sunil Sadasivan https://overflow.buffer.com/2014/07/09/how-buffer-uses-mongodb-to-power-its-growth-platform/ Pre-Aggregated Reports - docs.mongodb.com https://docs.mongodb.com/ecosystem/use-cases/pre-aggregated-reports/ TTL Indexes - docs.mongodb.com https://docs.mongodb.com/manual/core/index-ttl/ MongoDB Real-time Data Collection and Stats Generation - Damon Cortesi http://www.slideshare.net/dacort/mongodb-realtime-data-collection-and-stats-generation