Computer program for processing a pivot query

A method for performing pivot query, the method comprising:

• identifying one or more classification factors from a query when receiving the query from a client;
• generating a search table for filtering one or more records corresponding to at least one row of a table corresponding to the query based on the one or more classification factors;
• and
• generating a result table by performing an aggregation of a plurality of records included in the table based on the search table.

A computing device for performing a pivot query, the computing device comprising:

• a processor including one or more cores;
• a storage storing program codes executable by the processor;
• and
• a network unit transmitting and receiving data with a client;
• wherein the processor:
• identifies one or more classification factors from a query when receiving the query from a client;
• generates a search table for filtering one or more records corresponding to at least one row of a table corresponding to the query based on the one or more classification factors;
• and
• generates a result table by performing an aggregation of a plurality of records included in the table based on the search table.