Some cool features of MongoDB

Some cool features of MongoDB : Geospatial, Full Text Search, Aggregation Framework.
Presentation delivered May 2014 at the ESPRIT JUG Day 2014, Tunis

Transcript

1. Technical Evangelist, MongoDB
 @tgrall Tugdual Grall @EspritJUG Some cool features of MongoDB
2. @tgrall tug@mongodb.com Agenda • Analytics • Full Text Search • Geospatial
3. Real Time Analytics
4. @tgrall tug@mongodb.com State • We're storing our data in MongoDB • We need to do ad-hoc reporting, grouping, common aggregations, etc. • What are we using for this?
5. @tgrall tug@mongodb.com Data Warehousing
6. @tgrall tug@mongodb.com Data Warehousing • SQL for reporting and analytics • Infrastructure complications • Additional maintenance • Data duplication • ETL processes • Real time?
7. @tgrall tug@mongodb.com Aggregation Framework
8. @tgrall tug@mongodb.com Aggregation Framework • Declared in JSON, executes in C++ • Flexible, functional, and simple • Operation pipeline • Computational expressions • Plays nice with sharding
9. @tgrall tug@mongodb.com Pipeline • Process a stream of documents • Original input is a collection • Final output is a result document • Series of operators • Filter or transform data • Input/output chain
10. @tgrall tug@mongodb.com
11. @tgrall tug@mongodb.com
12. Search…
13. @tgrall tug@mongodb.com I want all the “tweets” about “xxx”
14. @tgrall tug@mongodb.com
15. @tgrall tug@mongodb.com MongoDB Full Text Search • Turnkey search for apps • Lowest cost • Simplest ops • Multi Language Support
16. GeoSpatial
17. @tgrall tug@mongodb.com • Store Geographical Informations • … and query them! GeoSpatial
18. @tgrall tug@mongodb.com How do you store information? http://geojson.org/
19. @tgrall tug@mongodb.com Point {! ! "loc" : ! ! ! {! ! ! ! "type" : "Point",! ! ! ! "coordinates" : [1.4528388, 43.5956005] ! ! ! }! }
20. @tgrall tug@mongodb.com LineString {! ! "loc" : ! ! ! {! ! ! ! "type" : "LineString",! ! ! ! "coordinates" : [ [1.4528388, 43.5956005], 
 ! ! ! ! ! ! ! [1.3996881, 43.5976828] ] ! ! ! }! }
21. @tgrall tug@mongodb.com Polygon {"loc" : ! ! ! { "type" : "Polygon",! ! ! ! "coordinates" : [! [1.4528388, 43.5956005],! ! ! ! ! ! ! ! ! [1.3996881, 43.5976828],! ! ! ! ! ! ! ! ! [1.4001065, 43.6364262],! ! ! ! ! ! ! ! ! [1.4518624, 43.6324835],
 ! ! ! ! ! ! ! ![1.4528388, 43.5956005] ] ! ! ! }! }
22. @tgrall tug@mongodb.com Query the data?
23. @tgrall tug@mongodb.com
24. @tgrall tug@mongodb.com Near a point db.points.find( { "loc" :{$near : {$geometry : { type : "Point", coordinates : [1.4528388, 43.5956005] }, $maxDistance : 500
25. @tgrall tug@mongodb.com Query : “in” the polygon db.points.find(! ! { "loc" :{!! ! ! ! $geoIntersects : {! ! ! ! ! $geometry : ! ! ! ! ! {type : "Point", ! ! ! ! ! coordinates:[1.443934, 43.604446]}! ! ! ! }! ! ! }! ! });
26. @tgrall tug@mongodb.com Query : all points in a Polygon db.points.find(! { "loc" :{ $geoWithin : ! ! ! {$geometry :! ! ! ! { "type" : "Polygon",! ! ! ! ! "coordinates" : [[! ! ! ! ! [1.4528388, 43.5956005],[1.3996881, 43.5976828],! ! ! ! ! [1.4001065, 43.6364262],[1.4518624, 43.6324835],! ! ! ! ! [1.4528388, 43.5956005]]] ! ! ! ! }}}});
27. Questions?
28. #ConferenceHashtag Thank You