An Activities and related Metrics pattern for a NoSQL key-value store.
A general use case for NoSQL stores is the tracking of activities and events. An out-of-band process is generally then used to generate additional metrics from the events or activities data.
Tracking Boolean or numeric valued activities like reviews, reactions and macros.
A simple use case is tracking the reactions to a web post - likes, smiles, down-votes etc. these activities can be track with quantitative qualifiers (e.g., a down-vote can be a -3 instead of just -1).
The activities are stored in an “Activities” table. The implementor is free to assign any valid name to the table.
Additional processes can then be executed to generate the metrics, for example, counting the number of likes, or the average likes for an area of a website. The metrics are stored in the “Metrics” table. The implementor is free to assign any valid name.