Skip navigation

Moving Data Closer to the Business with a NoSQL Solution

Customer Story
  • Retail & Distribution

Providing simply the best, most up-to-date insider data about nearby dealerships, market prices, sales, and car specifications, Edmunds delivers paid advertising for car manufacturers as well as leads- and subscription-based services to dealers. With Edmunds, potential customers get all of the essential information about the car they are shopping for before they ever step through the door of a dealership.

Edmunds approached EPAM to find a solution for replacing the expensive, hard-to-maintain Oracle Coherence in-memory data grid that had been powering their website for five years and simultaneously limiting the company’s platform evolution. After one-and-a-half years of hard work and collaboration with Edmunds on the dataset migration project, EPAM successfully completed the replacement of Oracle Coherence with MongoDB. The engagement resulted in the lasting business benefits for the client.

Key Challenges

  • Replacing the expensive, hard-to-maintain Oracle Coherence in-memory data grid that had been powering Edmund's website and limiting the company's platform evolution
  • Migrating the data from one large cluster feature multiple datasets consisting of 4-24 Coherence nodes each
  • Delivering an open-source, fast-performing NoSQL that organizes, embeds and monitors its data based on use cases
  • Integrating the solution into the existing platform, keeping APIs intact without jeopardizing performance

Solution Highlights

The first step in finding the proper solution for Edmunds was the launch of a joint investigation into which database would best fit the client’s needs. This resulted in the NoSQL market analysis phase, during which EPAM analyzed roughly 15 different data storages characterized as distributed in-memory data grids, document-oriented databases, and key value databases. EPAM then ranked the storages by criteria such as licensing and operational costs, performance, applicability, reliability, ease of maintenance, and others.

After conducting comprehensive research on each storage solution, EPAM chose three candidates for use in proof-of-concept testing. Our team started to run multiple learning loops in order to choose the best candidate to replace Coherence and, based on the results, chose MongoDB as the most balanced solution for the client. In order to meet strict performance requirements throughout the migration, we also applied a combination of Microservices and Direct Data Access Architecture.

With the right storage solution selected and the data architectures in place, the EPAM team was ready to begin the migration of Edmunds’ core datasets. We seamlessly migrated the following datasets to MongoDB:

  • Vehicle: a configurations, specifications, and pricing dataset
  • Region: a DMA, geo regions, and incentive region dataset
  • Incentive: a manufacturer incentive and rebate dataset
  • TMV: a dataset that powers the True Market Value calculator
  • TCO: a dataset that powers the True Cost to Own calculator for new and used cars
  • Partner: information about Edmunds partners and contracts
  • Rules: rules for Dealer and Inventory data processing
  • Maintenance: car maintenance actions, recalls, and service bulletins dataset

Throughout the migration process, our team worked diligently to ensure that Edmunds’ front-end applications and internal tools would be able to access the data via the shared REST and Java APIs. We also implemented a comparison tool to measure performance of numerous UI pages and REST responses across different environments to make sure that performance was not affected while moving from Coherence to MongoDB.

The Results

After one-and-a-half years of hard work and collaboration with Edmunds on the dataset migration project, EPAM successfully completed the replacement of Oracle Coherence with MongoDB in December 2015. This project is another in EPAM’s very impressive series of collaborations in partnership with Edmunds – a partnership made stronger by EPAM’s ability to accomplish the following:

  • Refactor the client’s data structure so deeply that the following improvements became apparent:
    • Bulkdata load times improved 3 to 5 times
    • Nodes size scaled down from 12 - 24 to 4 - 8
    • True Market Value generation time was cut in half from 100 minutes to 50 minutes
  • Respond to the client’s needs with professional analysis of the business domain and custom IT architecture to produce the following infrastructure savings:
    • 200 fewer hosting companies utilized
    • $10,000 to $12,000 per month saved (based on 75% utilization)
    • Network bandwidth reduction from 6 Gbps to 3 Gbps for vehicle storage
    • Enabled microservices architecture

Technologies Used

  • MongoDB
  • Oracle Coherence

Hello. How Can We Help You?


Our Offices

  • Canada

    • Ottawa

      343 Preston Street,
      ON K1S 1N4, Ottawa
      Canada

      Map
    • Toronto

      5 Park Home Avenue,
      Suite 400,
      ON M2N 6L4, North York,
      Toronto
      Canada

      Map
      F: +1-416-595-1551
  • Mexico

    • Guadalajara

      Periférico Sur #8110,
      Col. El Mante
      45609 Tlaquepaque, Jalisco
      Mexico

      Map
  • United States

    • Newtown, PA

      41 University Drive,
      Suite 202,
      Newtown, PA 18940
      USA

      Map
      F: +1-267-759-8989
    • Bellevue, WA

      110 110th Ave. NE,
      Suite 310
      Bellevue, WA 98004
      USA

      Map
    • Boston, MA

      21 Drydock Avenue,
      Suite 410 W,
      Boston, MA 02210
      USA

      Map
    • Conshohocken, PA

      101 East 8th Ave,
      Suite 201,
      Conshohocken, PA 19428
      USA

      Map
    • Los Angeles, CA

      11601 Wilshire Blvd,
      Suite 350,
      Los Angeles, CA 90025
      USA

      Map
    • New York, NY

      24 West 25th Street,
      5th Floor,
      New York, NY 10010
      USA

      Map
      F: +1-267-759-8989
    • Philadelphia, PA

      30 South 15th Street,
      9th Floor,
      Philadelphia, PA 19102
      USA

      Map
    • San Francisco, CA

      222 Kearny Street,
      Suite 308,
      San Francisco, CA 94108
      USA

      Map
    • San Jose, CA

      2055 Gateway Place,
      Suite 510,
      San Jose, CA 95110
      USA

      Map
    • Washington D.C.

      7901 Jones Branch Drive,
      Suite 400,
      McLean, VA 22102
      USA

      Map
  • Australia

  • China

    • Guangzhou

      Unit B01, 23/F,
      Yuexiuxinduhui Building,
      No. 236, 6th Zhongshan Road,
      Yuexiu District, Guangzhou,
      China 510180

      Map
    • 广州

      中国广州市越秀区
      中山六路236号
      越秀新都会大厦中座 23楼 B01室
      邮编510180

      地图
    • Shanghai

      Room B509, 5th Floor,
      48 Weihai Road,
      Huangpu District, Shanghai,
      China 200000

      Map
    • 上海

      上海市黄浦区
      威海路48号
      5楼B509室
      邮编200000

      地图
    • Shenzhen

      3/F, Block 5, Vision Shenzhen Business Park,
      9th Gaoxin South Road, 
      Shenzhen Hi-tech Industrial Park,
      Nanshan District, Shenzhen,
      Guangdong, China 518057

      Map
    • 深圳

      中国广东省深圳市
      南山区高新南九道
      威新软件园5号楼3楼
      邮编518057

      地图
    • Suzhou

      Building 12, Creative Industrial Park,
      328 Xinghu Street,
      Suzhou Industrial Park,
      Suzhou, China 215123

      Map
    • 苏州

      中国江苏省苏州市
      苏州工业园区星湖街328号
      创意产业园内12号楼
      邮编215123

      地图
  • Hong Kong

    • Hong Kong

      26F&17F, The Wellington Tower,
      198 Wellington Street,
      Central, HK

      Map
  • India

    • Bangalore

      Smartworks,  
      Global Technology Park,
      Block C, Outer Ring Rd,
      Adarsh Palm Retreat, Bellandur,
      Bengaluru, Karnataka 560103
      India

      Map
    • Hyderabad

      10, 11 & 12th Floors,
      Salarpuria Sattva Knowledge City,
      Plot No. 2, Phase - 1,
      Survey No. 83/1,
      Raidurgam Village,
      Serilingampally Mandal,
      Hyderabad, Telangana - 500081
      India

      Map
    • Pune

      SmartWork Business Center Pvt Ltd,
      Suite 8, Level 1,
      West Wing, Nyati Unitree,
      Samrat Ashok Road,
      Yerwada, Pune - 411006,
      Maharashtra
      India

      Map
  • Japan

    • Tokyo

      Floor 1-10-11
      Shibadaimon Centre Building 10th
      Shibadaimon Minato-ku
      Tokyo 105-0012
      Japan

      Map
      F: +81-03-6880-9201
  • Singapore

    • Singapore

      5 Shenton Way
      UIC Building, #10-01,
      Singapore (068808)

      Map
  • United Arab Emirates

    • Dubai

      EPAM Systems FZ-LLC Dubai Branch
      2307 Arenco Tower, Dubai Media City
      PO Box 501929 Dubai
      United Arab Emirates

      Map