Store locator for a pharmacy chain

DesignEasy25 min

Your task

Design the "find a pharmacy near me" feature for a chain of 900 pharmacies. A user shares their location or types an address or postcode, and sees the 10 nearest stores with distance, today's opening hours and whether each store is open now; they can filter to stores with a drive-through or 24-hour service. Store details change a few times a week, and holiday hours are entered in advance. The feature gets about 500,000 searches a day, more during flu season. Describe the data model, how the nearest stores are found, how typed addresses are handled, and how opening hours are computed.

It covers

  • Nearest neighbors
  • Geocoding
  • Opening hours