Database workload analysis and optimization visualizations

A method for facilitating analysis of the usage of data stored in a data storage system without accessing the stored data, the method comprising:

• receiving workload data indicative of queries executed at the data storage system on the stored data;
• processing the workload data to identify a plurality of data elements associated with the stored data;
• processing the workload data to determine relationships between the identified plurality of data elements based on operations performed during execution of the queries;
• and
• causing display of an interactive visualization including a usage heatmap diagram based on the processing, the usage diagram including:
• a plurality of nodes representative of the plurality of data elements present in the stored data, each of the plurality of nodes visually linked to one or more of the other plurality of nodes based on the determined relationships between the plurality of data elements;
• wherein each of the plurality of nodes is displayed as a graphical object indicative of a relative usage of a corresponding data element.

A system for facilitating analysis of the usage of data stored in a data storage system without accessing the stored data, the system comprising:

• a processing unit;
• and
• a memory coupled to the processing unit, the memory having instructions stored thereon, which when executed by the processing unit, cause the system to:
• receive workload data indicative of queries executed at the data storage system on the stored data;
• process the workload data to identify data elements associated with the stored data;
• process the workload data to determine relationships between the identified plurality of data elements based on operations performed during execution of the queries;
• and
• cause display of an interactive visualization including a usage diagram based on the processing, the usage diagram including:
• a plurality of nodes representative of the plurality of data elements present in the stored data, each of the plurality of nodes visually linked to one or more of the other plurality of nodes based on the determined relationships between the plurality of data elements;
• wherein each of the plurality of nodes is displayed as a graphical object indicative of a relative usage of a corresponding data element.