Topological data analysis of data from a fact table and related dimension tables

A non-transitory computer readable medium comprising instructions executable by a processor to perform a method, the method comprising:

• receiving a selection of data from a fact table and one or more dimension tables related to the fact table, the data including a plurality of values from a plurality of dimensions from the fact table and the one or more dimension tables, the fact table and the one or more dimension tables being stored in a data warehouse;
• receiving a lens function identifier, a metric function identifier, and a resolution function identifier;
• mapping data points from the selection of the data from the fact table and the one or more dimension tables to a reference space utilizing a lens function identified by the lens function identifier;
• generating a cover of the reference space using a resolution function identified by the resolution identifier;
• clustering the data points mapped to the reference space using the cover and a metric function identified by the metric function identifier to determine each node of a plurality of nodes of a graph, each node including at least one data point of the data points;
• determining a plurality of segments of the graph, each segment including at least one node of the plurality of nodes;
• and
• generating a segment data structure identifying each segment as well as membership of each segment, the membership of each segment including at least one node from the plurality of nodes in the graph.

A system comprising:

• one or more processors;
• and
• memory containing instructions executable by at least one of the one or more processors to:
• receive a selection of data from a fact table and one or more dimension tables related to the fact table, the data including a plurality of values from a plurality of dimensions from the fact table and the one or more dimension tables, the fact table and the one or more dimension tables being stored in a data warehouse;
• receive a lens function identifier, a metric function identifier, and a resolution function identifier;
• map data points from the selection of the data from the fact table and the one or more dimension tables to a reference space utilizing a lens function identified by the lens function identifier;
• generate a cover of the reference space using a resolution function identified by the resolution identifier;
• cluster the data points mapped to the reference space using the cover and a metric function identified by the metric function identifier to determine each node of a plurality of nodes of a graph, each node including at least one data point of the data points;
• determine a plurality of segments of the graph, each segment including at least one node of the plurality of nodes;
• and
• generate a segment data structure identifying each segment as well as membership of each segment, the membership of each segment including at least one node from the plurality of nodes in the graph.