Technical Evangelist, MongoDB
 @tgrall Tugdual Grall @EspritJUG Some cool features of MongoDB 

@tgrall [email protected] Agenda • Analytics • Full Text Search • Geospatial 

Real Time Analytics 

@tgrall [email protected] 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? 

@tgrall [email protected] Data Warehousing 

@tgrall [email protected] Data Warehousing • SQL for reporting and analytics • Infrastructure complications • Additional maintenance • Data duplication • ETL processes • Real time? 

@tgrall [email protected] Aggregation Framework 

@tgrall [email protected] Aggregation Framework • Declared in JSON, executes in C++ • Flexible, functional, and simple • Operation pipeline • Computational expressions • Plays nice with sharding 

@tgrall [email protected] 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 

@tgrall [email protected] 

@tgrall [email protected] 

Search… 

@tgrall [email protected] I want all the “tweets” about “xxx” 

@tgrall [email protected] 

@tgrall [email protected] MongoDB Full Text Search • Turnkey search for apps • Lowest cost • Simplest ops • Multi Language Support 

GeoSpatial 

@tgrall [email protected] • Store Geographical Informations • … and query them! GeoSpatial 

@tgrall [email protected] How do you store information? http://geojson.org/ 

@tgrall [email protected] Point {! ! "loc" : ! ! ! {! ! ! ! "type" : "Point",! ! ! ! "coordinates" : [1.4528388, 43.5956005] ! ! ! }! } 

@tgrall [email protected] LineString {! ! "loc" : ! ! ! {! ! ! ! "type" : "LineString",! ! ! ! "coordinates" : [ [1.4528388, 43.5956005], 
 ! ! ! ! ! ! ! [1.3996881, 43.5976828] ] ! ! ! }! } 

@tgrall [email protected] 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] ] ! ! ! }! } 

@tgrall [email protected] Query the data? 

@tgrall [email protected] 

@tgrall [email protected] Near a point db.points.find( { "loc" :{$near : {$geometry : { type : "Point", coordinates : [1.4528388, 43.5956005] }, $maxDistance : 500 

@tgrall [email protected] Query : “in” the polygon db.points.find(! ! { "loc" :{!! ! ! ! $geoIntersects : {! ! ! ! ! $geometry : ! ! ! ! ! {type : "Point", ! ! ! ! ! coordinates:[1.443934, 43.604446]}! ! ! ! }! ! ! }! ! }); 

@tgrall [email protected] 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]]] ! ! ! ! }}}}); 

Questions? 

#ConferenceHashtag Thank You