Managing event databases using histogram-based analysis

A method comprising:

• generating, by a server system:
• profile data for a plurality of users, wherein the profile data comprises, for each user, an indication of one or more interest categories associated with the user;
• and
• event data for a plurality of social media events, wherein the event data comprises, for each social media event, an indication of one or more users associated with the social media event;
• determining, by the server system, that a first subset of users is associated with a first social media event;
• storing, by the server system, the profile data and the event data in one or more databases;
• determining, by the server system, that a first subset of interest categories is associated with the first subset of users;
• determining, by the server system, that a second subset of interest categories is associated with the first social media event, the second subset of interest categories being selected by a controlling user of the first social media event;
• generating an event data structure for the first social media event based on the first subset of interest categories and the second subset of interest categories, wherein the event data structure comprises:
• an indication of the first subset of interest categories and the second subset of interest categories, and
• for each interest category of the first subset of interest categories and the second subset of interest categories, a respective frequency metric based on a number of users of the first subset of users associated with that interest category and whether that interest category had been selected by the controlling user of the first social media event,
• executing, by the server system, one or more processes configured to monitor database transactions causing a change to the data of the one or more databases;
• determining, by the server system, that a transaction meets trigger criteria with respect to the first social media event;
• responsive to determining that the transaction meets the trigger criteria with respect to the first social media event, modifying the event data structure based on the transaction.