Efficient real-time hierarchy using change events

A system of comprising:

• at least one hardware processor;
• and
• a non-transitory computer-readable medium of the managed private cloud architecture, the non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one processor to perform operations comprising:
• storing a first hierarchy table in a database, the first hierarchy table comprising first hierarchy data that represents a snapshot state of a hierarchy tree of entities at a first point in time, the first hierarchy table having been last updated at the first point in time;
• subsequent to the first point in time, receiving one or more user requests to change entity data stored in a data storage structure, the entity data stored in the data storage structure representing entities of the hierarchy tree;
• storing one or more change events in a queue based on the receiving of the one or more user requests to change entity data, the one or more change events representing the one or more requested changes of entity data;
• receiving a first query request for the hierarchy tree subsequent to the receiving of the one or more user requests to change entity data;
• in response to the receiving of the first query request, generating a first query result based on the first hierarchy table stored in the database and the one or more change events stored in the queue;
• and
• performing a function of an enterprise application platform using the generated first query result.

A non-transitory machine-readable storage medium of a managed private cloud architecture serving an organization, the non-transitory machine-readable storage medium tangibly embodying a set of instructions that, when executed by at least one hardware processor, causes the at least one processor to perform operations comprising:

• storing a first hierarchy table in a database, the first hierarchy table comprising first hierarchy data that represents a snapshot state of a hierarchy tree of entities at a first point in time, the first hierarchy table having been last updated at the first point in time;
• subsequent to the first point in time, receiving one or more user requests to change entity data stored in a data storage structure, the entity data stored in the data storage structure representing entities of the hierarchy tree;
• storing one or more change events in a queue based on the receiving of the one or more user requests to change entity data, the one or more change events representing the one or more requested changes of entity data;
• receiving a first query request for the hierarchy tree subsequent to the receiving of the one or more user requests to change entity data;
• in response to the receiving of the first query request, generating a first query result based on the first hierarchy table stored in the database and the one or more change events stored in the queue;
• and
• performing a function of an enterprise application platform using the generated first query result.