Dynamic query engine for data visualization

A system comprising:

• one or more processors;
• and
• a memory, the memory storing instructions, which when executed cause the one or more processors to:
• receive user interaction in association with rendering a visualization of a data cube in a user interface of a client device, the user interaction being one of a group of user interactions received in a predetermined interval of time;
• responsive to the user interaction received, determine a data container including a multi-dimensional array of data associated with the visualization of the data cube and a set of visibility constraints corresponding to one or more indices of the multi-dimensional array of data in the data container brought into view in the user interface of the client device by the user interaction, wherein bounds in the set of visibility constraints is defined by a display size of the user interface of the client device and a number of dimensions in the data container is defined by a number of split axes, a measure axis, and a comparison axis in the multi-dimensional array of data;
• periodically check in with the data container using the set of visibility constraints every predetermined interval of time to determine that there is data to be loaded;
• issue a query to fetch values of the data from a database responsive to determining that there is data to be loaded;
• dynamically loading the fetched values of the data into the data container;
• and
• render the visualization of the data cube in the user interface of the client device using the dynamically loaded data container.