Patent · US Active

Method and apparatus for executing query and computer readable medium therefor

US10275491B2 · kind B2 · utility

1Cited by
9References
11Claims
0Family size

Assignee

Inventors

Key dates

Filing dateJul 26, 2016
Grant dateApr 30, 2019
Priority date
Expiry dateApr 5, 2037

Classification

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

Abstract

Provided is a method for executing a query in a DBMS. The method may include: receiving a query statement including a pivot operator—the query statement being associated with an original table; executing a pivot operation for the original table in response to reception of the query statement; generating BLOB data by serializing at least a part of an execution result of the pivot operation to a BLOB type; and storing the generated BLOB data in a pivot table.

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