Please download the dossier by clicking on the dossier button x
×

Pruning of columns in synopsis tables

  • US 10,649,991 B2
  • Filed: 04/26/2016
  • Issued: 05/12/2020
  • Est. Priority Date: 04/26/2016
  • Status: Active Grant
First Claim
Patent Images

1. A computer program product for data management, comprising:

  • a computer readable storage medium and program instructions stored on the computer readable storage medium, the program instructions comprising;

    program instructions to organize a plurality of columns in one or more data tables, wherein respective columns of the plurality of columns are utilized upon receiving a query that includes a predicate to search a main data table;

    program instructions to monitor a usage of the plurality of columns in the one or more data tables using an in-memory structure, wherein the in-memory structure stores, for each column in the plurality of columns, (i) a predicate type and (ii) a count of queries that have used the respective column to search the main data table; and

    program instructions to drop one or more columns of the plurality of columns in the one or more data tables, based on a period of time threshold which defines an effectiveness for optimizing data queries, wherein dropping the one or more columns comprises dropping a subset of a plurality of content associated with at least one type of data structure within the one or more data tables.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×