System and methods for performing updated query requests in a system of multiple database engine

A non-transitory computer-readable medium, comprising computer-executable instructions that, when executed by one or more processors, cause the one or more processors to:

• receive a query request configured to identify one or more entries in a first set of data entries associated with a row-oriented database, a second set of data entries associated with a column-oriented database, or both, wherein the column-oriented database and the row-oriented database are different databases;
• determine whether the query request comprises performing a row-oriented operation, a column-oriented operation, or both;
• execute the query request via the column-oriented database in response to the query request comprising the column-oriented operation, wherein executing the query request via the column-oriented database comprises:
• determining whether the column-oriented operation is associated with one or more changes made to the first set of data entries;
• comparing an amount of time associated with replicating the one or more changes to the column-oriented database to a threshold amount of time;
• based on the amount of time exceeding the threshold amount of time:
• creating a transient file associated with the one or more changes in response to the column-oriented operation being associated with the one or more changes, wherein the transient file corresponds to a format recognized by the column-oriented database;
• transmitting the transient file and the query request to the column-oriented database;
• and
• querying the column-oriented database based on the query request and the transient file;
• based on the amount of time being less than or equal to the threshold amount of time:
• replicating the one or more changes to the column-orientated database in response to the column-oriented operation being associated with the one or more changes;
• and
• querying the column-oriented database based on the query request.

A method, comprising:

• receiving, via a processor, a query request that identifies one or entries in a first set of data entries associated with a row-oriented database, a second set of data entries associated with a column-oriented database, or both, wherein the column-oriented database and the row-oriented database are different databases;
• determining, via the processor, whether the query request comprises performing a row-oriented operation, a column-oriented operation, or both;
• executing, via the processor, the query request via the column-oriented database in response to the query request comprising the column-oriented operation, wherein executing, via the processor, the query request via the column-oriented database comprises:
• determining whether the column-oriented operation is associated with one or more changes made to the first set of data entries;
• comparing an amount of time associated with replicating the one or more changes to the column-oriented database to a threshold amount of time;
• based on the amount of time exceeding the threshold amount of time:
• creating a transient file associated with the one or more changes in response to the column-oriented operation being associated with the one or more changes, wherein the transient file corresponds to a format recognized by the column-oriented database;
• transmitting the transient file and the query request to the column-oriented database;
• and
• querying the column-oriented database based on the query request and the transient file;
• based on the amount of time being less than or equal to the threshold amount of time:
• replicating the one or more changes to the column-orientated database in response to the column-oriented operation being associated with the one or more changes;
• and
• querying the column-oriented database based on the query request.