Data access and recommendation system

A system comprising:

• a memory;
• and
• at least one processor coupled to the memory and configured to perform operations comprising:
• identifying, by the at least one processor, a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period;
• recording a count of how many of the one or more data values are accessed during the column access;
• incrementing a first counter, corresponding to the first column and stored in a distributed hash table, by the count, wherein the distributed hash table stores a plurality of other counters corresponding to each of the plurality of columns of the table;
• determining that the sampling period has expired;
• computing a load recommendation on how to load data values into the first column based on the first counter, wherein the load recommendation includes at least one of a full load of data values recommendation or a partial load of data values recommendation;
• and
• providing the load recommendation for implementation into the database for one or more subsequent column accesses.

A non-transitory computer-readable device having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:

• identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period;
• recording a count of how many of the one or more data values are accessed during the column access;
• incrementing a first counter, corresponding to the first column and stored in a distributed hash table, by the count, wherein the distributed hash table stores a plurality of other counters corresponding to each of the plurality of columns of the table;
• determining that the sampling period has expired;
• computing a load recommendation on how to load data values into the first column based on the first counter, wherein the load recommendation includes at least one of a full load of data values recommendation or a partial load of data values recommendation;
• and
• providing the load recommendation for implementation into the database for one or more subsequent column accesses.