Patent · US Active

Trigger-free asynchronous maintenance of custom indexes and skinny performance meta-structures

US11003662B2 · kind B2 · utility

1Cited by
90References
20Claims
0Family size

Assignee

Inventor

Key dates

Filing dateOct 30, 2017
Grant dateMay 11, 2021
Priority date
Expiry dateJul 4, 2038

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F16/2365
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

Trigger-free asynchronous maintenance of custom indexes and skinny performance meta-structures is described. A database system receives a request to manipulate data in an object in a database table, and determines whether the object in the database table is associated with a user-based data structure. If the object in the database table is associated with the user-based data structure, the database system manipulates the data in the object in the database table and data in an object in an intermediate data table. The database system receives a query, and determines whether the query requests any data that is in the user-based data structure. If the query requests any data that is in the user-based data structure, the database system creates a query result by combining any data that is in the object in the intermediate data table with any requested data that is in the user-based data structure, and outputs the query result.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.