Supply chain event management

A system comprising:

• a processor;
• and
• a tangible, non-transitory memory configured to communicate with the processor,
• the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to perform operations comprising:
• associating, by the processor, an aggregation event with a parent electronic product code (EPC) and a child EPC at a first location;
• wherein a proximity-based scanner scans the parent EPC and the child EPC at the first location to obtain data,
• wherein the first location impacts that data that is obtained by the proximity-based scanner at the first location,
• wherein the proximity-based scanner communicates the data to the processor;
• storing, by the processor, the data for the aggregation event in a database as ungrouped data elements formatted as a block of binary (BLOB);
• tuning, by the processor, the database to optimize database performance;
• obtaining, by the processor, the data from the database for the aggregation event;
• setting, by the processor, a parent EPC state to a condition reflecting error, in response to at least one of:
• a decommissioning event existing earlier in an event sequence for the parent EPC,
• a disaggregation event existing for the parent EPC,
• at least one of a shipping event or a receiving event existing for the parent EPC, or
• more than one commissioning event;
• in response to the parent EPC being not reusable, checking, by the processor, for at least one of:
• disaggregation events earlier in the event sequence than the current aggregation event,
• the at least one of the shipping event or the receiving event earlier in the event sequence than the current aggregation event, or
• only one commissioning event earlier in the event sequence than the current aggregation event;
• in response to the parent EPC event sequence having events subsequent in time to the current aggregation event, associating, by the processor, each of the subsequent events for the parent EPC with each of the child EPCs listed in the aggregation event, wherein the subsequent events are applied recursively through a parent and child containment hierarchy;
• and
• in response to beginning the event sequence with the aggregation event, setting, by the processor, at least one of a child EPC state or the parent EPC state to indicate a missing commissioning event.