Performance of distributed databases and database-dependent software applications

A computer-implemented method of categorizing tables of a database into groups, the method comprising:

• processing a set of queries used to access a database with a processing system to generate a log that identifies for each of the queries (i) a database operation associated with the query, (ii) a table of the database accessed via the query, and (iii) a column or columns of the table used by the query to access the table;
• accessing with the processing system criteria for categorizing database tables into groups, the criteria being based on a total number of times that a table is accessed by the set of queries, a number of times that the table is accessed using a column or group of columns, a number of times that a read operation is executed on the table, a number of times that a write operation is executed on the table, and a number of rows in the table;
• and
• applying an algorithm that evaluates data of the log against the criteria, the algorithm being configured to (a) automatically categorize the database tables identified in the log into multiple groups based on the evaluation, (b) classify the database tables as being predominantly for read operations or predominantly for write operations based on a ratio between a number of times that a read operation is executed in the set of queries and a total number of times that a read operation and a write operation is executed on the database tables, wherein the database tables are classified as being predominantly for read operations when the ratio meets or exceeds a read threshold, and (c) grouping together the database tables classified as predominantly for read operations based on a number of rows within each database table and the database tables classified as predominantly for write operations based on the number of times that each database table is accessed using the column or the group of columns.

A computer-implemented system for categorizing tables of a database into groups, the system comprising:

• a processing system;
• and
• computer-readable memory in communication with the processing system encoded with instructions for commanding the processing system to execute steps comprising:
• processing a set of queries used to access a database to generate a log that identifies for each of the queries (i) a database operation associated with the query, (ii) a table of the database accessed via the query, and (iii) a column or columns of the table used by the query to access the table;
• accessing database operation criteria for categorizing database tables into groups, the database operation criteria being based on a total number of times that a table is accessed by the set of queries, and a number of times that the table is accessed using a column or group of columns;
• and
• applying an algorithm that evaluates data of the log against the database operation criteria, the algorithm being configured to (a) automatically categorize the database tables identified in the log into multiple groups based on the evaluation, (b) classify the database tables as being predominantly for read operations or predominantly for write operations based on a ratio between a number of times that a read operation is executed in the set of queries and a total number of times that a read operation and a write operation is executed on the database tables, wherein the database tables are classified as being predominantly for read operations when the ratio meets or exceeds a read threshold, and (c) grouping together the database tables classified as predominantly for read operations based on a number of rows within each database table and the database tables classified as predominantly for write operations based on the number of times that each database table is accessed using the column or the group of columns.

A non-transitory computer-readable storage medium for categorizing tables of a database into groups, the computer-readable storage medium comprising computer executable instructions which, when executed, cause a processing system to execute steps including:

• processing a set of queries used to access a database to generate a log that identifies for each of the queries (i) a database operation associated with the query, (ii) a table of the database accessed via the query, and (iii) a column or columns of the table used by the query to access the table;
• accessing database operation criteria for categorizing database tables into groups, the database operation criteria being based on a total number of times that a table is accessed by the set of queries, and a number of times that the table is accessed using a column or group of columns;
• and
• applying an algorithm that evaluates data of the log against the database operation criteria, the algorithm being configured to (a) automatically categorize the database tables identified in the log into multiple groups based on the evaluation, (b) classify the database tables as being predominantly for read operations or predominantly for write operations based on a ratio between a number of time that a read operation is executed in the set of queries and a total number of times that a read operation and a write operation is executed on the database tables, wherein the database tables are classified as being predominantly for read operations when the ratio meets or exceeds a read threshold, and (c) grouping together the database tables classified as predominantly for read operations based on a number of rows within each database table and the database tables classified as predominantly for write operations based on the number of times that each database table is accessed using the column or the group of columns.