Living in the Post-transactional Future Order-processing systems largely “done” (RDBMS); new focus on better search and recommendations or adapting prices on the fly (NoSQL) Vast majority of its engineering is focused on recommending better movies (NoSQL), not processing monthly bills (RDBMS) Easy part is processing the credit card (RDBMS). Hard part is making it location aware, so it knows where you are and what you’re buying (NoSQL)
Relational Database Challenges Data Types Unstructured data Semi-structured data Polymorphic data Agile Development Iterative Short development cycles New workloads Volume of Data Petabytes of data Trillions of records Millions of queries/sec New Architectures Horizontal scaling Commodity servers Cloud computing
Baseball Bat -3 length to weight ratio 2-5/8" barrel diameter Two-piece construction R2 alloy barrel provides outstanding durability, performance and "pop" R2 composite handle shifts weight into the bat's knob for ultra-fast swing speeds Rifle Barrel design removes weight from the barrel for thinner wall thickness Acoustic barrel offers that sweet-sounding "ping" Contact grip helps eliminate sting and vibration AIR Elite is RIP-IT's® fastest BBCOR bat and the one with the most performance BBCOR certified - approved for high school and collegiate play Includes RIP-IT's® "Love It Or Return It" 30 Day Refund Policy with free return shipping Manufacturer's warranty: 400 days Made in the USA Model: B1403E
Bat Product Table Category Model Name Brand Length to weight ratio Barrel Dia Type Barrel Handle Cert. Country Price Bat B1403E Air Elite RIP-IT -3 2 5/8 Composite R2 Alloy R2 composite BBCOR USA $399.99 Bat B1403 Prototype RIP-IT -3 2 5/8 One-piece R1 Alloy R1 Alloy BBCOR USA $199.99 Bat MCB1B One Marucci -3 2 5/8 One-piece AZ3000 aluminum AZ3000 aluminum BBCOR Imported $199.99 Bat BB14S1 S1 Easton -3 2 5/8 Composite IMX SIC Black Carbon BBCOR China $399.99
Lets Add Gloves Size: 12" Infield/Outfield/Pitcher model 2-Piece Web pattern Most popular MLB® pattern among pitchers Pro Stock® American steerhide leather offers rugged durability and a superior feel Dual-Welting™ on "exposed edges" of the fingers helps maintain pocket shape and durability Pro Stock™ hand-designed pattern for unbeatable craftsmanship Dri-Lex® ultra-breathable wrist lining repels moisture from your hand Black leather with rich brown embellishments Pattern: B212 Model: WTA2000BBB212 Wilson
Bat and Glove Product Table Category Model Name Brand Length to weight ratio Barrel Dia Type Barrel Handle Cert. Country Price Bat B1403E Air Elite RIP-IT -3 2 5/8 Composite R2 Alloy R2 composite BBCOR USA $399.99 Bat B1403 Prototype RIP-IT -3 2 5/8 One-piece R1 Alloy R1 Alloy BBCOR USA $199.99 Bat MCB1B One Marucci -3 2 5/8 One-piece AL AL BBCOR Imported $199.99 Bat BB14S1 S1 Easton -3 2 5/8 Composite IMX SIC Black Carbon BBCOR China $399.99 Category Model Name Brand Size Position Pattern Web Pattern Material Color Country Price Glove WTA2000B BB212 A2000 Wilson 12" Infield B212 2-piece Leather black Vietnam $299.99 Glove PRO112PT HOH Pro Rawlings 11.25" Outfield Pro taper Modified Trap-Eze Horween Leather black China $229.99
Add some baseballs Cover: Full grain leather for excellent durability Core: Cushioned cork core Additions/Technologies: Made to the exact specifications of MLB Stitching/Seams: 108 classic red stitches/Rawlings® Major League seaming League/Certification(s): MLB Balls included per purchase: individual Recommended Age: All ages Model : ROMLB Rawlings
Bat and Glove Product Table Category Model Name Brand Length to weight ratio Barrel Dia Type Barrel Handle Cert. Country Price Bat B1403E Air Elite RIP-IT -3 2 5/8 Composite R2 Alloy R2 composite BBCOR USA $399.99 Bat B1403 Prototype RIP-IT -3 2 5/8 One-piece R1 Alloy R1 Alloy BBCOR USA $199.99 Bat MCB1B One Marucci -3 2 5/8 One-piece AL AL BBCOR Imported $199.99 Bat BB14S1 S1 Easton -3 2 5/8 Composite IMX SIC Black Carbon BBCOR China $399.99 Category Model Name Brand Size Position Pattern Web Pattern Material Color Country Price Glove WTA2000B BB212 A2000 Wilson 12" Infield B212 2-piece Leather black Vietnam $299.99 Glove PRO112PT HOH Pro Rawlings 11.25" Outfield Pro taper Modified Trap-Eze Horween Leather black China $229.99 Category Model Name Brand Color Cover Core Cert. Country Price Baseball DICRLLB1 PBG Little League Rawlings white Leather Cork rubber Little League China $4.99 Baseball ROML MLB Rawlings white Leather cork China $6.99
Sparse Table Category Model Name Brand Length to weight ratio Barrel Dia Type Barrel Handle Certificati on Country Price Size Position Pattern Web Pattern Material Color Cover Core Bat B1403E Air
Elite RIP-‐IT -‐3 2
5/8 Composite R2
Alloy R2
composite BBCOR USA $399.99
Bat B1403 Prototype RIP-‐IT -‐3 2
5/8 One-‐piece R1
Alloy R1
Alloy BBCOR USA $199.99
Bat MCB1B One Marucci -‐3 2
5/8 One-‐piece AZ3000
aluminum AZ3000
aluminum BBCOR Imported $199.99
Bat BB14S1 S1 Easton -‐3 2
5/8 Composite IMX SIC
Black
Carbon BBCOR China $399.99
Glove WTA2000BB B212 A2000 Wilson Vietnam $299.99
12" Infield B212 2-‐piece Leather black Glove PRO112PT HOH
Pro Rawlings China $229.99
11.25" Outfield Pro
taper Modified
Trap-‐Eze Horween
Leather black Baseball DICRLLB1PB G Little
League Rawlings Little
League China $4.99
white Leather cork
and
rubber Baseball ROML MLB Rawlings China $6.99
white Leather cork Continue adding columns as you add new products
Maybe this design will work better prodID property value 1 length/weight -3 1 barrel dia 2 5/8 1 type composite 1 certification BBCOR … 5 size 12 5 position infield 5 pattern B212 5 material leather 5 color black … 8 color white 8 cover leather 8 core cork prodID Category Model Name Brand Country Price 1 Bat B1403E Air Elite RIP-IT USA $399.99 2 Bat B1403 Prototype RIP-IT USA $199.99 3 Bat MCB1B One Marucci Imported $199.99 4 Bat BB14S1 S1 Easton China $399.99 5 Glove WTA2000BBB 212 A2000 Wilson Vietnam $299.99 6 Glove PRO112PT HOH Pro Rawlings China $229.99 7 Baseball DICRLLB1PBG Little League Rawlings China $4.99 8 Baseball ROML MLB Rawlings China $6.99
Document Model Benefits Agility and flexibility Data model supports business change Rapidly iterate to meet new requirements Intuitive, natural data representation Eliminates ORM layer Developers are more productive Reduces the need for joins, disk seeks Programming is more simple Performance delivered at scale { _id : ObjectId("4c4ba5e5e8aabf3"), employee_name: "Dunham, Justin", department : "Marketing", title : "Product Manager, Web", report_up: "Neray, Graham", pay_band: “C", benefits : [ { type : "Health", plan : "PPO Plus" }, { type : "Dental", plan : "Standard" } ] }
THE LARGEST ECOSYSTEM 9,000,000+ MongoDB Downloads 200,000+ Online Education Registrants 35,000+ MongoDB User Group Members 35,000+ MongoDB Management Service (MMS) Users 750+ Technology and Services Partners 2,000+ Customers Across All Industries
High Availability Replica Set – two or more copies Self-healing shard Addresses availability considerations: High Availability Disaster Recovery Maintenance Deployment Flexibility Data locality to users Workload isolation: operational & analytics
Single-click provisioning, scaling & upgrades, admin tasks Monitoring, with charts, dashboards and alerts on 100+ metrics Backup and restore, with point-in-time recovery, support for sharded clusters MongoDB Ops Manager The Best Way to Manage MongoDB In Your Data Center Up to 95% Reduction in Operational Overhead
Example: MongoDB Management Service Cloud service for managing MongoDB systems 100+ system metrics visualized and alerted 35,000+ MongoDB systems submitting data every 60 seconds 90% updates, 10% reads ~30,000 updates/second ~3.2B operations/day Eight x86-64 servers
For More Information Resource Location Case Studies mongodb.com/customers Presentations mongodb.com/presentations Free Online Training education.mongodb.com Webinars and Events mongodb.com/events Documentation docs.mongodb.org MongoDB Downloads mongodb.com/download Additional Info [email protected]
Comparing Data Models MongoDB Key/Value Relational Rich Data Model Yes No No Dynamic Schema Yes Yes No Typed Data Yes No Yes Data Locality Yes Yes No Field Updates Yes No Yes Easy for Programmers Yes Yes No
Comparing Query Models MongoDB Key/Value Relational Key/Value Yes Yes Yes Secondary Indexes Yes No Yes Index Intersection Yes No Yes Range Queries Yes No Yes Geospatial Yes No Yes Text Search Yes No Yes Aggregation Yes No Yes MapReduce Yes Yes No
Comparing Operational Capabilities MongoDB Key/Value Relational Automatic Failover Yes Limited Yes Data Center Awareness Yes No Expensive Add- Ons Continuous Backup Yes No Yes Point in Time Recovery Yes No Yes Caching Layer Needed No No Often Automatic Sharding Yes Yes No
Store files larger than 16MB i.e. video, images - Load chunks without reading entire file into memory Atomically sync files with their metadata Shard and distribute around the cluster GridFS doc.jpg doc.jpg (meta data) doc.jpg (1) GridFS API fs.files fs.chunks Driver
MongoDB & Hadoop Applications powered by Analysis powered by Low latency Rich fast querying Flexible indexing Ad hoc aggregations in database Known data relationships Great at looking at any subset of data Longer jobs and queries Analytical processing Often highly partitionable Unknown data relationships Great at looking at all of data MongoDB Connector for Hadoop
Single View of Customer Insurance leader generates coveted 360-degree view of customers in 90 days – “The Wall” Problem Why MongoDB Results • No single view of customer • 145 yrs of policy data, 70+ systems, 15+ apps • 2 years, $25M in failing to aggregate in RDBMS • Poor customer experience • Agility – prototype in 9 days; • Dynamic schema & rich querying – combine disparate data into one data store • Hot tech to attract top talent • Production in 90 days with 70 feeders • Unified customer view available to all channels • Increased call center productivity • Better customer experience, reduced churn, more upsell opps • Dozens more projects on same data platform
Product Catalog Serves variety of content and user services on multiple platforms to 7M web and mobile users Problem Why MongoDB Results • MySQL reached scale ceiling – could not cope with performance and scalability demands • Metadata management too challenging with relational model • Hard to integrate external data sources • Unrivaled performance • Simple scalability and high availability • Intuitive mapping • Eliminated 6B+ rows of attributes – instead creates single document per user / piece of content • Supports 115,000+ queries per second • Saved £2M+ over 3 yrs. • “Lead time for new implementations is cut massively” • MongoDB is default choice for all new projects
Reference Data Distribution Global Bank Distribute reference data globally in real-time for fast local accessing and querying Problem Why MongoDB Results • Delays up to 36 hours in distributing data by batch • Charged multiple times globally for same data • Incurring regulatory penalties from missing SLAs • Had to manage 20 distributed systems with same data • Dynamic schema: easy to load initially & over time • Auto-replication: data distributed in real-time, read locally • Both cache and database: cache always up-to-date • Simple data modeling & analysis: easy changes and understanding • Will avoid about $40,000,000 in costs and penalties over 5 years • Only charged once for data • Data in sync globally and read locally • Capacity to move to one global shared data service