Patent ID: 11860883
Assignee: JPMORGAN CHASE BANK, N.A.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A method that implements a data usage analytics engine for database systems, the method comprising:
receiving one or more database queries;
accessing a plurality of data sources comprising one or more databases, data object statistics, and data access patterns;
identifying one or more database tables associated with the one or more database queries from the plurality of data sources;
parsing, via the data usage analytics engine, the one or more database tables based on the one or more database queries to identify usage metrics, the parsing including horizontal data analysis and column usage analysis, and the usage metrics including a measure of utilization for each of the one or more database tables based on the horizontal data analysis and a measure of utilization for each of a plurality of attributes from the one or more database tables based on the column usage analysis;
generating, via the data usage analytics engine, one or more data usage patterns based on the usage metrics wherein the data usage patterns are identified on a periodic basis and identify what tables are used, how much of data is queried at what intervals, frequency of querying, and one or more attributes used in the queries;
transmitting the data usage patterns to an interactive user interface;
predicting access to a type of dataset at a particular time period based on the data usage patterns, and determining a first number of data requests and, based on the periodic basis and out of the first number of data requests, a second number of data requests that were not active in a most recent time period;
determining an optimal storage configuration for remote and local storage based on the data usage patterns, the first number of data requests, and the second number of data requests that were not active in the most recent time period;
generating a first interactive user interface display screen that provides the data usage patterns for at least one of the one or more databases, the first interactive user interface display screen including the usage metrics for periodic intervals, based on the periodic basis, and summary data of the usage metrics for the most recent time period, the summary data including a table summary and a first column summary, the table summary showing a used table count and an unused table count for the one or more database tables included in the at least one of the one or more databases, the first column summary including a used column count and an unused column count;
generating a second interactive user interface display screen that provides data usage analysis data for the at least one of the one or more databases, the second interactive user interface display screen including active periods for the periodic intervals, based on the periodic basis, and a second column summary, the second column summary including a used column size and an unused column size,
wherein, in the first interactive user interface display screen and the second interactive user interface display screen, the usage metrics for the periodic intervals and the active periods for the periodic intervals are each displayed as a first type of graphical element, and the first column summary and the second column summary are each displayed as a second type of graphical element different than the first type of graphical element,
wherein the usage metrics for the periodic intervals and the active periods for the periodic intervals are each displayed, as the first type of graphical element, on a first side of the first interactive user interface display screen and the second interactive user interface display screen, respectively,
wherein the first column summary and the second column summary are each displayed, as the second type of graphical element, on a second side opposite the first side of the first interactive user interface display screen and the second interactive user interface display screen, respectively,
wherein the optimal storage configuration includes moving data of the type of dataset for which access is predicted from a storage service to the local storage based on when the data is predicted to be accessed,
wherein the optimal storage configuration further includes compressing second data stored in the local storage when the second data cannot be moved to the remote storage, and
wherein the data of the type of dataset for which access is predicted is identified for a user of a specific role.