Method and apparatus for executing query and computer readable medium therefor
US10268723B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 26, 2016 |
| Grant date | Apr 23, 2019 |
| Priority date | — |
| Expiry date | Apr 5, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2219
- 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 for requesting BLOB data serialized to a binary large object (BLOB) type and stored in a pivot table; determining name information for one or more columns generated as a result of a pivot operation included in respective pivot columns of the pivot table by querying a pivot name table for the pivot table; determining internal storage type information of the pivot table by querying a pivot meta table for the pivot table; and generating output information for the BLOB data corresponding to the query statement based on the determined name information and internal storage type information.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.