Method and system for managing database

A non-transitory computer-readable recording medium comprising computer readable instructions, which when executed by at least one processor, configures the at least one processor to:

• receive a first query from a user;
• generate a factorized character string based on the first query, the factorized character string being generated by converting at least one execution value of a character string of the first query into a desired factor;
• transmit the factorized character string to a server;
• receive an execution plan identifier associated with the factorized character string from the server, the execution plan identifier identifying an execution plan, stored on the server, equivalent to the factorized character string;
• generate a second query request including the execution plan identifier and an execution value list associated with the first query, the second query request being in a pair format;
• transmit the second query request to the server;
• determine whether a query result associated with the second query is stored on the server, the determination based on at least the execution plan identifier and the execution value list;
• receive a query result corresponding to the second query request from the server, wherein when the query result corresponding to the second query request is determined to be stored on the server, the receiving includes receiving the stored query result from the server;
• generate an execution plan with respect to the factorized character string in response to a response to the factorized character string being received from the server;
• and
• transmit the generated execution plan to the server, before the receiving of the execution plan identifier.

A system configured to manage a database, the system comprising:

• a memory having computer readable instructions stored thereon;
• and
• at least one processor configured to execute the computer readable instructions to,
• receive a first query from a user,
• generate a factorized character string based on the first query, the factorized character string being generated by converting at least one execution value of a character string of the first query into a desired factor,
• transmit the factorized character string to a server;
• receive an execution plan identifier associated with the factorized character string from the server, the execution plan identifier identifying an execution plan, stored on the server, equivalent to the factorized character string,
• generate a second query request including the execution plan identifier and an execution value list associated with the first query, the second query request being in a pair format,
• transmit the second query request to the server,
• determine whether a query result associated with the second query is stored on the server, the determination based on at least the execution plan identifier and the execution value list,
• receive a query result corresponding to the second query request from the server, wherein when the query result corresponding to the second query request is determined to be stored on the server, the receiving includes receiving the stored query result from the server;
• generate an execution plan with respect to the factorized character string in response to a response to the factorized character string being received from the server, and
• transmit the generated execution plan to the server, before the receiving of the execution plan identifier.