Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Expanding Retail Frontiers with MongoDB

Norberto
October 01, 2013

Expanding Retail Frontiers with MongoDB

How MongoDB is being used by retail organisations, use cases, references and challenges MongoDB helps to overcome

Norberto

October 01, 2013
Tweet

More Decks by Norberto

Other Decks in Technology

Transcript

  1. 2 •  Norberto Leite •  Solutions Architect –  Technical Account

    Manager –  Engineer •  Barcelona, Spain •  [email protected] •  @nleite Presenter Notes
  2. Phoenician  saying   “The  art  of  commerce  is  to  buy

     goods  for  5   when  they  are  worth  10  and  sell  for  10  what   is  worth  5”  
  3. 7 To provide the best database for how we build

    and run apps today MongoDB Vision Build –  New and complex data –  Flexible –  New languages –  Faster development Run –  Big Data scalability –  Real-time –  Commodity hardware –  Cloud
  4. 9 4,000,000+ MongoDB Downloads 100,000+ Online Education Registrants 20,000+ MongoDB

    User Group Members 20,000+ MongoDB Days Attendees 15,000+ MongoDB Management Service (MMS) Users Global Community
  5. 10 Data Hub User Data Management Big Data Content Mgmt

    & Delivery Mobile & Social MongoDB Solutions
  6. 11 •  10 of the Top Financial Services Institutions • 

    10 of the Top Electronics Companies •  10 of the Top Media and Entertainment Companies •  8 of the Top Retailers •  6 of the Top Telcos •  5 of the Top Technology Companies •  4 of the Top Healthcare Companies Fortune 500 & Global 500
  7. 13 •  Old School –  Evolving Landscape –  Customer Loyalty

    –  New Competitors –  New Markets •  Avant-garde –  Seamless Experience –  Online + Offline –  Buying Patterns –  Predict Trends Challenges
  8. 15 •  Extended Offering •  Home delivery •  Online only

    supermarkets –  Lots of new companies –  Lots of traditional retailers populating the web •  Physical stores as complements –  Show rooms –  Pick up locations Evolving Landscape
  9. 17 •  Understand your customer •  “Customize” what customer needs

    and wants –  And when he want’s it! •  Reward the your “fans” •  Make sure everyone knows they have been rewarded –  Gamification is a strong powerful driver! –  points + points + points Customer Loyalty
  10. 18 •  How easy it is nowadays to open a

    web shop? •  How many are approaching a need that you do not attend? •  Is your market share growing or shrinking? –  Time to get a Vietnamese translator ? •  How fast can I react to habits and perception change ? New Competitors and Markets
  11. 20 •  It’s all about knowing your Customer •  Make

    better customized offers •  Avoid useless promotions –  Not valuable for your customers –  Degradation of your brand •  Make use of the network effect •  Analytics anyone? Buying Patterns + Trends Prediction
  12. 22 •  Flexible Datastore •  Horizontal Scalability •  Multi Platform

    •  Polyglot •  Cost Efficient •  Large Community •  Talent War? MongoDB = Good Stuff
  13. 23 RDBMS Flexible Datastore MongoDB { _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" } ] }
  14. 24 Horizontal Scalability Auto-Sharding •  Increase capacity as you go

    •  Commodity and cloud architectures •  Improved operational simplicity and cost visibility
  15. 27 Shell Command-line shell for interacting directly with database Polyglot

    Drivers Drivers for most popular programming languages and frameworks > db.collection.insert({product:“MongoDB”, type:“Document Database”}) > > db.collection.findOne() { “_id” : ObjectId(“5106c1c2fc629bfe52792e86”), “product” : “MongoDB” “type” : “Document Database” } Java Python Perl Ruby Haskell JavaScript
  16. 28 Developer/Ops Savings •  Ease of Use •  Agile development

    •  Less maintenance Hardware Savings •  Commodity servers •  Internal storage (no SAN) •  Scale out, not up Software/Support Savings •  No upfront license •  Cost visibility for usage growth Cost Efficient DB Alternative
  17. 29 Cost Efficient Dev. and Admin Compute – Scale-Up Servers

    Storage - SAN Dev. and Admin Compute – Scale-Up Servers Storage - SAN
  18. 32 •  Rich Catalog Management •  Customer Data Management • 

    Customer Interaction and Sentiment Analysis •  Digital Coupons •  Inventory Management •  Demand Chain Optimization •  Real-Time Price Optimization Use Cases
  19. 33 •  Flexibility –  External + Internal information –  Evolving

    Product Data –  Different Buying Process –  Funnels –  Promotions && Campaigns –  Hierarchy of Products and Sections User Preferences Product Insights References Product Details Commercial Positioning Rich Catalog Management
  20. 34 •  Multiple Geographies •  Online + Offline •  Engagement

    Process •  Preferences •  Permissions •  Privacy and other regulation Preferences Permissions Regional Data Engagements Customer Customer Data Management
  21. 35 •  Realtime analytics –  Aggregation Framework –  MapReduce • 

    KPI calculation –  CTR –  Bounce Rates –  Conversion Rates •  Automation of Price Margins •  DSL Web metrics Availability Conversion Rate •  Per User •  Global •  Per Product •  Inventory •  Catalog •  Margin •  Per Section •  Per Unit •  Per Segment Realtime Price Optimiation Optimum Price
  22. 37 MongoDB enables Gilt to roll out new revenue- generating

    features faster and cheaper Case Study Problem Why MongoDB Results •  Monolithic Postgres architecture expensive to scale •  Limited ability to add new features for different business silos •  Spiky server loads •  Dynamic schema makes it easy to build new features •  Alignment with SOA •  Cost-effective, horizontal scaling •  Easy to use and maintain •  Developers can launch new services faster, e.g., customized upsell emails •  Stable, sub-ms performance on commodity hardware •  Reduced complexity yields lower overhead
  23. 38 Serves variety of content and user services on multiple

    platforms to 7M web and mobile users Case Study 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
  24. 39 Delivers agile automated supply chain service to retailers powered

    by MongoDB Case Study Problem Why MongoDB Results •  RDBMS poorly- equipped to handle varying data types (e.g., SKUs, images) •  Inefficient use of storage in RDBMS (i.e., 90% empty columns) •  Complex joins degraded performance •  Document-oriented model less complex, easier to code •  Single data store for structured, semi-structured and unstructured data •  Scalability and availability •  Analytics with MapReduce •  Decreased supplier onboard time by 12x •  Grew from 400K records to 40M in 12 months •  Significant cost reductions on schema design time, ongoing developer effort, and storage usage
  25. 43 MongoDB Products and Services Training Online and In-Person for

    Developers and Administrators MongoDB Management Service (MMS) Cloud-Based Suite of Services for Managing MongoDB Deployments Subscriptions MongoDB Enterprise, MMS (On-Prem), Professional Support, Commercial License Consulting Expert Resources for All Phases of MongoDB Implementations
  26. 44 For More Information Resource Location MongoDB Downloads mongodb.com/download Free

    Online Training education.mongodb.com Webinars and Events mongodb.com/events White Papers mongodb.com/white-papers Case Studies mongodb.com/customers Presentations mongodb.com/presentations Documentation docs.mongodb.org Additional Info [email protected] Resource Location