Method and apparatus for executing query and computer readable medium therefor
AssigneeTmaxData Co., Ltd.
InventorsSukwon Yi, Youngjae Choi, Kyungtae Lee, Seungkeol Kim
Life of this patent
Estimating the term…
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.
Claims14
A non-transitory computer-readable medium including encoded commands,
- which allow one or more processors to perform the following operations for executing a query statement in a database management system (DBMS) when the commands are executed by the one or more processors of a computing system, wherein the operations include:
- an operation of receiving a query statement including a pivot operator, where the query statement is associated with an original table;
- an operation of executing the pivot operation for the original table in response to reception of the query statement;
- an operation of generating binary large object (BLOB) data by serializing at least a part of an execution result of the pivot operation to a BLOB type;
- and
- an operation of storing the generated BLOB data in a pivot table.
A method for executing a query in a DBMS, the method comprising:
- receiving a query statement including a pivot operator, where the query statement is 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.
An apparatus for executing a query statement in a database management system, the apparatus comprising:
- a database management module in the database management system, where the database management module is configured to cooperate with components in the database management system that include one or more processors to execute instructions, one or more memories to store information, one or more data input components to receive data input from a user of the database management system, a communication circuit to establish a communication link to communicate with other computing devices external to the database management system, a display device to display at least some of the information stored in the one or more memories, where portions of the database management module implemented in software are stored in the one or more memories and are executed by the one or more processors, where the database management module consists of multiple different modules including but not limited to a communication module, an operation executing module, a BLOB data generating module, and a storage module to efficiently store, query, and output an execution result for a pivot calculation in a binary large object (BLOB) type;
- where the communication module is configured to receive the query statement includes a pivot operator and the query statement is associated with an original table;
- where the operation executing module is configured to execute a pivot operation for the original table in response to reception of the query statement;
- where the BLOB data generating module is configured to generate BLOB data by serializing at least a part of an execution result of the pivot operation to a BLOB type;
- and
- where the storage module is configured to store the generated BLOB data in a pivot table.
Dependencies are inferred from the claim text.