Utilities
Usual Suspects
Database
General
Fun Facts
100

This is the name of the tool we created to track processes related to OCADO

What is ManifestTracker?

100

This event some times is not published on a timely manner. And causes problems with NRs.
Is the way for Picking to say "I'm done picking"

What is EndOrderPick?

100

This is the approach we take when creating Cassandra tables.
It separates it from other Databases, in the magnitud of tables we own.

What is one table per query?

100

This is the name of the event, for which we listen and create containers for orders at the store.

What is End Trolley Run

100

This is a princess name, and also of beautiful kid living in Brazil.

Léia

200

This is the meaning behind the letters NR, in NR Container

What is NOT READY Container?

200

It is a recent issue we've had with Dispatch team, the generic term in computer science may also be used in Formula One broadcasting.

What is a Race condition?

200

This is the time window for rows to be turned to null, for then to be deleted by Garbage collection, after the grace period ends, in a Cassandra DB

What is TTL? / What is Time To Leave?

200

The only one able to talk to our DB directly

What is Staging Core?

200

This is a language both Pema and Swathi can speak.

Hindi

300
Alexander Hall created this in 2022 to help business partners on their daily tasks.

What is Staging Visualizer?

300
The main thing that is expected from Staging, and that releases other flows like CustomerOrderRelease(COR)

What is End Order Stage (EOS)?

300

This key, along with partition key, allows you to further narrow down your results, and can be part of the schema of a table.

What is clustering key?

300

This entity we persist in our DB for Picking, but we don't make decisions on it.

Vehicles

300

Place of one of the latest new Grand Prix in F1.
Larry spend some important days there recently!.

Las Vegas, Nevada

400

Final differentiator between using Power User endpoint or regular for EOS fix.

What is 5 days?

400

It is the inability or unknowingly wrong setup that Ocado has, that is introducing issues in our stores.

If this was fixed, even replacing containers several times a day wouldn't be an issue.

The inability to produce unique container Ids ?

400

This is required of Staging from EDS, when altering or creating new stuff for Cassandra in Production, alongside a CR.

What is a CTask ?

400

These two recent new features leverage the same logic inside our service for multiple containers

What is Bulk Staging and Lockers?

400

This is the State where two of our engineers live.

Some of them might have visited a Buc-ee's from time to time.

Texas

500

Place where you would check what flags a store has enabled, outside of Launch Darkly

What is Store Configuration utility?

500

This team publishes before we work on a Locker flow, and could be the origin of untimely processing.

What is Partner Integration Framework or (PIF)?

500

This set of tables allow for internal auditing on certain entities

what is history? / i.e. what is container_history? 

500
We publish these events around 3 am, every day.
What are Manifest Persisted events?
500

This is the grand father of Granular Staging

What is Smart Staging?