Generating a venn diagram using a columnar database management system

A method comprising:

• determining, by a computer, a plurality of intersection sets for all combinations of a plurality of input sets of data retrieved from a columnar format database, each intersection set of the plurality of intersections sets determined by the computer using a combination of input sets, the determining comprising:
• loading a first combination of input sets,
• determining a first intersection set from the first combination of input sets,
• selecting a second intersection set based on a second combination of input sets, the second intersection set selected such that the input sets of the second combination include the input sets of the first combination,
• loading input sets of the second combination that are not included in the first combination, and
• determining the second intersection set;
• determining, by the computer, one or more subsets of a Venn diagram based on the plurality of intersection sets, the determining comprising computing a cardinality of each subset of the Venn diagram as a difference of a cardinality of a first intersection set and cardinality of previous computed subsets of the Venn diagram;
• storing the one or more subsets of the Venn diagram on a non-transitory computer-readable medium;
• and
• communicating the one or more subsets of the Venn diagram to a client device over a network for display on the client device.