MongoDB for Analytics

799efab30a6db8436e6941dfd372c66f?s=47 Zizaco
August 31, 2016

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

799efab30a6db8436e6941dfd372c66f?s=128

Zizaco

August 31, 2016
Tweet

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

  16. None
  17. None
  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