Download as PDF, PPTX
![8 Document Model { first_name: ‘Paul’, surname: ‘Miller’, city: ‘London’, location: { type : ‘Point’, coordinates : [45.123,47.232] }, cars: [ { model: ‘Bentley’, year: 1973, value: 100000, … }, { model: ‘Rolls Royce’, year: 1965, value: 330000, … } ] } MongoDB RDBMS](https://image.slidesharecdn.com/devsharp2018-180925211803/75/Simplifying-accelerating-application-development-with-MongoDB-s-intelligent-operational-data-platform-8-2048.jpg)
![9 Developer Agility - Documents { first_name: ‘Paul’, surname: ‘Miller’, ID: 125678, city: ‘London’, location: { type : ‘Point’, coordinates : [45.123,47.232] }, Profession: [‘banking’, ‘finance’, ‘trader’], cars: [ { model: ‘Bentley’, year: 1973, value: 100000, … }, { model: ‘Rolls Royce’, year: 1965, value: 330000, … } ] } Fields can contain an array of sub-documents Typed field values Fields can contain arrays String Number Geo-Location Fields](https://image.slidesharecdn.com/devsharp2018-180925211803/75/Simplifying-accelerating-application-development-with-MongoDB-s-intelligent-operational-data-platform-9-2048.jpg)
![10 Developer Agility – Flexible Schema { product_name: ‘Acme Paint’, sku: "123-567-845", color: [‘Red’, ‘Green’], size_oz: [8, 32], finish: [‘satin’, ‘eggshell’] } { product_name: ‘T-shirt’, sku : "123-589-234", size: [‘S’, ‘M’, ‘L’, ‘XL’], color: [‘Heather Gray’ … ], material: ‘100% cotton’, wash: ‘cold’, dry: ‘tumble dry low’ } { product_name: ‘Mountain Bike’, sku : "143-534-678", brake_style: ‘mechanical disc’, color: ‘grey’, frame_material: ‘aluminum’, no_speeds: 21, package_height: ‘7.5x32.9x55’, weight_lbs: 44.05, suspension_type: ‘dual’, wheel_size_in: 26 }](https://image.slidesharecdn.com/devsharp2018-180925211803/75/Simplifying-accelerating-application-development-with-MongoDB-s-intelligent-operational-data-platform-10-2048.jpg)
![14 Aggregations Advanced data processing pipeline for transformations and analytics • Multiple stages • Similar to a unix pipe – Build complex pipeline by chaining commands together • Rich Expressions Collection db.orders.aggregate( [ $match stage { $match: { status: "A" } }, $group stage { $group: { _id: "$cust_id",total: { $sum: "$amount" } } } ] ) { cust_id: "A123", amount: 500, status: "A", } { cust_id: "A123", amount: 250, status: "A", } { cust_id: "B212", amount: 200, status: "A", } { cust_id: "A123", amount: 300, status: "D", } Orders { cust_id: "A123", amount: 500, status: "A", } { cust_id: "A123", amount: 250, status: "A", } { cust_id: "B212", amount: 200, status: "A", } { id: "A123", total: 750 } { id: "B212", total: 200 } $match $group](https://image.slidesharecdn.com/devsharp2018-180925211803/75/Simplifying-accelerating-application-development-with-MongoDB-s-intelligent-operational-data-platform-14-2048.jpg)
![17 db.customers.aggregate([ { $unwind: "$address", }, { $match: {"address.location": "home"} }, { $group: { _id: "$address.city", totalSpend: {$sum: "$annualSpend"}, averageSpend: {$avg: "$annualSpend"}, maximumSpend: {$max: "$annualSpend"}, customers: {$sum: 1} } } ]) Versatile: Complex queries fast to create, optimize, & maintain MongoDB’s aggregation framework has the flexibility you need to get value from your data, but without the complexity and fragility of SQL These “phases” are distinct and easy to understand They can be thought about in order… no nesting.](https://image.slidesharecdn.com/devsharp2018-180925211803/75/Simplifying-accelerating-application-development-with-MongoDB-s-intelligent-operational-data-platform-17-2048.jpg)
Simplifying & accelerating application development with MongoDB's intelligent operational data platform
- 2. Simplifying & Accelerating ApplicationDevelopment With MongoDB’s Intelligent Operational Data Platform
- 4. 4 MongoDB’s Intelligent Operational DataPlatform is the best way of making your data simple to Organize, Use, & Enrich in Real Time, Anywhere
- 5. You probably havethousands of tables
- 6. 6 Go from this…. CustomerOpportunity Contact Opportunity Team Phone Phone Objects Tables Lead NameNameOpen Activities ARR Address Contact Roles SummaryCustomer Detail Activity History Object Relational Mapping Layer
- 7. 7 To this: storeobjects directly… Customer Customer Opportunity Opportunity Contact Contact Lead Lead Objects Database
- 8. 8 Document Model { first_name: ‘Paul’, surname:‘Miller’, city: ‘London’, location: { type : ‘Point’, coordinates : [45.123,47.232] }, cars: [ { model: ‘Bentley’, year: 1973, value: 100000, … }, { model: ‘Rolls Royce’, year: 1965, value: 330000, … } ] } MongoDB RDBMS
- 9. 9 Developer Agility -Documents { first_name: ‘Paul’, surname: ‘Miller’, ID: 125678, city: ‘London’, location: { type : ‘Point’, coordinates : [45.123,47.232] }, Profession: [‘banking’, ‘finance’, ‘trader’], cars: [ { model: ‘Bentley’, year: 1973, value: 100000, … }, { model: ‘Rolls Royce’, year: 1965, value: 330000, … } ] } Fields can contain an array of sub-documents Typed field values Fields can contain arrays String Number Geo-Location Fields
- 10. 10 Developer Agility –Flexible Schema { product_name: ‘Acme Paint’, sku: "123-567-845", color: [‘Red’, ‘Green’], size_oz: [8, 32], finish: [‘satin’, ‘eggshell’] } { product_name: ‘T-shirt’, sku : "123-589-234", size: [‘S’, ‘M’, ‘L’, ‘XL’], color: [‘Heather Gray’ … ], material: ‘100% cotton’, wash: ‘cold’, dry: ‘tumble dry low’ } { product_name: ‘Mountain Bike’, sku : "143-534-678", brake_style: ‘mechanical disc’, color: ‘grey’, frame_material: ‘aluminum’, no_speeds: 21, package_height: ‘7.5x32.9x55’, weight_lbs: 44.05, suspension_type: ‘dual’, wheel_size_in: 26 }
- 11. 11 Developer Agility –Use Your Favourites Morphia MEAN Stack
- 12. 12 Easy: MongoDB Multi-DocumentACID Transactions Just like relational transactions • Multi-statement, familiar relational syntax • Easy to add to any application • Multiple documents in 1 or many collections and databases ACID guarantees • Snapshot isolation, all or nothing execution • No performance impact for non-transactional operations Planning • MongoDB 4.0: replica set • MongoDB 4.2: extended to sharded clusters
- 13. 13 Fully Indexable Fully featuredsecondary indexes • Primary Index – Every Collection has a primary key index • Compound Index – Index against multiple keys in the document • MultiKey Index – Index into arrays • Text Indexes – Support for text searches • GeoSpatial Indexes – 2d & 2dSphere indexes for spatial geometries • Hashed Indexes – Hashed based values for sharding Index Types • TTL Indexes – Single Field indexes, when expired delete the document • Unique Indexes – Ensures value is not duplicated • Partial Indexes – Expression based indexes, allowing indexes on subsets of data • Case Insensitive Indexes • supports text search using case insensitive search • Sparse Indexes – Only index documents which have the given field Index Features
- 14. 14 Aggregations Advanced data processing pipelinefor transformations and analytics • Multiple stages • Similar to a unix pipe – Build complex pipeline by chaining commands together • Rich Expressions Collection db.orders.aggregate( [ $match stage { $match: { status: "A" } }, $group stage { $group: { _id: "$cust_id",total: { $sum: "$amount" } } } ] ) { cust_id: "A123", amount: 500, status: "A", } { cust_id: "A123", amount: 250, status: "A", } { cust_id: "B212", amount: 200, status: "A", } { cust_id: "A123", amount: 300, status: "D", } Orders { cust_id: "A123", amount: 500, status: "A", } { cust_id: "A123", amount: 250, status: "A", } { cust_id: "B212", amount: 200, status: "A", } { id: "A123", total: 750 } { id: "B212", total: 200 } $match $group
- 15. 15 Aggregation Features A featurerich analytical framework • $match • $group • $facet • $geoNear • $graphLookup Pipeline Stages • Mathematical – $add, $abs, $substract, $multiply, $divide, $log, $log10, $stdDevPop, $stdDevSam, $avg, $sqrt, $pow, $sum, $zip, $convert, etc. • Array – $push, $reduce, $reverseArray, $addToSet, $arrayElemAt, $slice, etc. Operators • $lookup • $project • $sort • $unwind • $out • Conditionals – $and, $or, $eq, $lt, $lte, $gt, $gte, $cmp, $cond, $switch, $in, etc • Date – $dateFromParts, $dateToParts, $dateFromString, $dateToString, $dayOfMonth, $isoWeek, $minute, $month, $year, etc. • String – $toUpper, $toLower, $substr, $strcasecmp, $concat, $split, etc. • Laterals – $exp, $let, $literal, $map, $type, etc
- 16. 16 Compared to SQLJOINs and aggregation SELECT city, SUM(annual_spend) Total_Spend, AVG(annual_spend) Average_Spend, MAX(annual_spend) Max_Spend, COUNT(annual_spend) customers FROM ( SELECT t1.city, customer.annual_spend FROM customer LEFT JOIN ( SELECT address.address_id, city.city, address.customer_id, address.location FROM address LEFT JOIN city ON address.city_id = city.city_id ) AS t1 ON (customer.customer_id = t1.customer_id AND t1.location = "home") ) AS t2 GROUP BY city; SQL queries have a nested structure Understanding the outer layers requires understanding the inner ones So SQL has to be read “inside-out”
- 17. 17 db.customers.aggregate([ { $unwind: "$address", }, { $match: {"address.location":"home"} }, { $group: { _id: "$address.city", totalSpend: {$sum: "$annualSpend"}, averageSpend: {$avg: "$annualSpend"}, maximumSpend: {$max: "$annualSpend"}, customers: {$sum: 1} } } ]) Versatile: Complex queries fast to create, optimize, & maintain MongoDB’s aggregation framework has the flexibility you need to get value from your data, but without the complexity and fragility of SQL These “phases” are distinct and easy to understand They can be thought about in order… no nesting.
- 18. 18 Developer Agility –Compass – MongoDB GUI Debug & Optimize Visualize & Explore Insert, Modify, & Delete
- 19. 19 Sophisticated Analytics &Visualizations Of Data In Place • Rich MongoDB query language & idiomatic drivers • Connector for BI • Connector for Spark • Charts (beta)
- 20. MongoDB Charts: Create,Visualize, Share Work with complex data Connect to data sources securely. Filter. Sample. Visualize. Share dashboards and collaborate
- 21. 21 Versatile: MongoDB ChangeStreams Enabling developers to build reactive, real-time servicesChangeStreamsAPI Business Apps User Data Sensors Clickstream Real-Time Event Notifications Message Queue
- 22. 22 High Availability andData Durability – Replica Sets SecondarySecondary Primary
- 23.
- 24. 24 Replica Set NodeFailure SecondarySecondary Primary No Heartbeat
- 25.
- 26. 26 New Replica Set– 2 Nodes SecondaryPrimary Heartbeat And New Primary
- 27.
- 28.
- 29.
- 30. 30 Eventual Consistency SecondarySecondary Primary Client Application ClientDriver Write Read Read
- 31.
- 32. 32 Replica Set Read Preference WriteConcern Read Concern
- 33. 33 Replica Set Bottlenecks Application Driver Primary /data Secondary /data Secondary /data RAMLimits on single server CPU Limits on single server Network Bandwidth Disk I/O
- 34. 34 Reasons to Shard Performance Datalocality Recovery Time Objective (RTO)
- 35. Sharded Cluster Application mongos mongosmongos Driver
- 36. 36 Sharded Cluster Application mongos mongosmongos Driver Config Server
- 37. Cloud ManagerOps ManagerMongoDB Atlas Private DBaaS Compatibility multi-environment Hybrid DBaaS Public DBaaS Fully managed Same codebase, same API & same UI
- 38. 38 Operational Agility –Atlas - Database as a Service Self-service, elastic, and automated Secure by defaultGlobal and highly available Continuous backups Real-time monitoring and optimization Cloud agnostic
- 39.
- 40. Evolution of ComputingModels Evolution to more streamlined, managed infrastructure Large Data Center Virtual Machines VMs in the Cloud (EC2) Containers Serverless Manage H/W Manage less H/W Size & provision VMs Size & provision containers Just send in requests Wasted resources Better utilization Rent, not buy Rent with less waste Pay as you go $$$$$ $$$$ $$$ $$ $ Cheaper to build Cheaper to run Faster time to market
- 41. MongoDB Stitch The BestWay to Work With Data
- 42. Focus Your EnergyWhere You Can Make a Difference App Backend Infrastructure Core Database Functionality Storage Service integrations, data access control Code that moves the business forward Managing OS, Scale, Security, Backups, etc. Time 40% 40% 20%
- 43. Focus Your EnergyWhere You Can Make a Difference App Backend Infrastructure Core Database Functionality Storage Service integrations, data access control Code that moves the business forward Managing OS, Scale, Security, Backups, etc. MongoDB Atlas Time 40% 40% 20%
- 44. Focus Your EnergyWhere You Can Make a Difference App Backend Infrastructure Core Database Functionality Storage Service integrations, data access control Code that moves the business forward Managing OS, Scale, Security, Backups, etc. MongoDB Atlas MongoDB Stitch Fully managed Elastic scale Highly Available Secure Time 40% 40% 20%
- 45. Focus Your EnergyWhere You Can Make a Difference App Backend Infrastructure Core Database Functionality Storage Service integrations, data access control Code that moves the business forward Managing OS, Scale, Security, Backups, etc. MongoDB Atlas MongoDB Stitch Fully managed Elastic scale Highly Available Secure Customer can focus here Time 40% 40% 20%
- 46. Streamlines app developmentwith simple, secure access to data and services from the client with thousands of lines less code to write and no infrastructure to manage – getting your apps to market faster while reducing operational costs. Stitch QueryAnywhere Full power of MongoDB document model & query language in frontend code Fine-grained security policies through declarative rules MongoDB Stitch Serverless Platform Services
- 47. Streamlines app developmentwith simple, secure access to data and services from the client with thousands of lines less code to write and no infrastructure to manage – getting your apps to market faster while reducing operational costs. Stitch QueryAnywhere Full power of MongoDB document model & query language in frontend code Fine-grained security policies through declarative rules Stitch Functions Run simple JavaScript functions in Stitch’s serverless environment Power apps with Server-side logic, or enable Data as a Service with custom APIs. MongoDB Stitch Serverless Platform Services
- 48. Streamlines app developmentwith simple, secure access to data and services from the client with thousands of lines less code to write and no infrastructure to manage – getting your apps to market faster while reducing operational costs. Stitch QueryAnywhere Full power of MongoDB document model & query language in frontend code Fine-grained security policies through declarative rules Stitch Functions Run simple JavaScript functions in Stitch’s serverless environment Power apps with Server-side logic, or enable Data as a Service with custom APIs. Stitch Triggers Real-time notifications that launch functions in response to changes in the database Make further database changes, push data to other places, or interact with users MongoDB Stitch Serverless Platform Services
- 49. Stitch QueryAnywhere Full powerof MongoDB document model & query language in frontend code Fine-grained security policies through declarative rules Stitch Functions Run simple JavaScript functions in Stitch’s serverless environment Power apps with Server-side logic, or enable Data as a Service with custom APIs. Stitch Mobile Sync Automatically synchronizes data between documents held locally in MongoDB Mobile and the backend database (coming soon) Streamlines app development with simple, secure access to data and services from the client with thousands of lines less code to write and no infrastructure to manage – getting your apps to market faster while reducing operational costs. Stitch Triggers Real-time notifications that launch functions in response to changes in the database Make further database changes, push data to other places, or interact with users MongoDB Stitch Serverless Platform Services
- 50.
- 51. MongoDB Stitch Benefits ReduceTime to Market Functions as a Service: No waiting on infrastructure Service Integrations: Save coding Cross-Platform: Develop once Existing Apps Untouched: No reverse-engineering
- 52. MongoDB Stitch Benefits ReduceTime to Market Functions as a Service: No waiting on infrastructure Service Integrations: Save coding Cross-Platform: Develop once Existing Apps Untouched: No reverse-engineering Reduce Operational costs Serverless: We manage the platform for you PaYG: No up-front cost Capacity on Demand: Zero wasted resources Secure by Default: Less ops effort
- 53. MongoDB Stitch Benefits ReduceTime to Market Functions as a Service: No waiting on infrastructure Service Integrations: Save coding Cross-Platform: Develop once Existing Apps Untouched: No reverse-engineering Reduce Development Effort Backend Integrations Built in: Don't write generic backend code HA & Scalability Built in: Hard and time consuming to build Orchestrate Data Between Services: Reuse what's out there Stitch Runs Your Code: The only backend you need Reduce Operational costs Serverless: We manage the platform for you PaYG: No up-front cost Capacity on Demand: Zero wasted resources Secure by Default: Less ops effort
- 54. MongoDB Stitch Benefits ReduceTime to Market Functions as a Service: No waiting on infrastructure Service Integrations: Save coding Cross-Platform: Develop once Existing Apps Untouched: No reverse-engineering Reduce Development Effort Backend Integrations Built in: Don't write generic backend code HA & Scalability Built in: Hard and time consuming to build Orchestrate Data Between Services: Reuse what's out there Stitch Runs Your Code: The only backend you need Reduce Operational costs Serverless: We manage the platform for you PaYG: No up-front cost Capacity on Demand: Zero wasted resources Secure by Default: Less ops effort Secure Data Access: Simple, Declarative Rules Complete Authentication & Authorization out of the box: Authenticate anything and anyone; protect anything Precise, Flexible, Extensible Rules: Lock access down tighter Flexible Auth Options: Choose which auth service(s) to use
- 55. All the Functionality& Scalability of MongoDB •Full feature set – Not just key-value store •Scale up or out •Retain traditional access methods •No lock-in •AWS at start of beta, extending to on-premises and other cloud providers.
- 56.
- 57.
- 58. Where Europe’s fastestgrowing database community comes to connect, explore, and learn. MongoDB Europe 2018 November 8th, Old Billingsgate
- 59. ● Register at mongodbworld.com/europe18 ●Use code MUG25 to get 25% off tickets ● Groups get an additional 25% off! Ready to Register?