Dynamic row count prediction technique

A system configured to process a Structured Query Language (SQL) query, the system comprising:

• a dynamic prediction generator comprising a processor and a memory configured to store a neural network model;
• and
• a user device comprising a processor and a memory, wherein the memory is configured to store instructions that, when executed by the processor, cause the user device to:
• identify a parameter of the SQL query;
• generate a plurality of input vectors based on the parameter of the SQL query;
• transmit the plurality of input vectors to an input layer of the neural network;
• receive a predicted number of rows associated with the plurality of input vectors from an output layer of the neural network, wherein the predicted number of rows is generated based on a descent gradient of the neural network and a hidden state generated by an intermediate layer of the neural network;
• and
• modify the parameter of the SQL query based on the predicted number of rows to generate a modified parameter, wherein the modified parameter is configured to reduce computational resources required to generate an SQL query result, and wherein the modified parameter is configured to improve an accuracy of the SQL query result.

A computer-implemented method of processing a Structured Query Language (SQL) query, the method comprising:

• receiving, by an input layer of a neural network, a plurality of input vectors based on a parameter of the SQL query;
• converting, by an intermediate layer of the neural network, the plurality of input vectors into a hidden state based on a plurality of randomly initialized weights, wherein the plurality of randomly initialized weights are determined based on a descent gradient of the neural network;
• and
• generating, by an output layer of the neural network, a predicted number of rows based on the hidden state;
• generating a recommendation to modify the SQL query based on the predicted number of rows;
• and
• transmitting the recommendation to a processor, wherein an implementation of the recommendation improves the SQL query result.