Query Throttling During Query Translation

An electronic computing system comprising:

• a processing unit comprising a set of at least one integrated circuit;
• and
• a data storage system comprising a set of at least one computer-readable data storage medium, the data storage system storing a set of instructions that, when executed by the processing unit, configure the electronic computing system to:
• receive an original query from a querying client, the original query expressed in a first query language;
• automatically determine whether the original query includes a clause unsupported by a second query language;
• automatically separate, in response to determining that the original query includes an clause unsupported by the second query language, the original query into a server-side query and a client-side query, the server-side query comprising supported clauses of the original query, the client-side query comprising unsupported clauses of the original query;
• automatically determine, after separating the original query into the server-side query and the client-side query, whether the client-side query is efficient;
• automatically send, in response to determining that the client-side query is not efficient, an error message to the querying client, the error message indicating to the querying client that the computing system did not execute the original query because the original query is not efficient;
• automatically translate the server-side query into a supplemental query expressed in the second query language;
• automatically dispatch the server-side query;
• automatically receive, after dispatching the server-side query, a server-side result set from a database management system, the database management system managing a database, the server-side result set comprising data items in the database responsive to the supplemental query;
• automatically generate, when the computing system determines that the client-side query is efficient, a client-side result set by querying the server-side result set using the client-side query;
• and
• automatically return the client-side result set to the querying client as a result set of the original query.

A computer-readable data storage medium comprising computer-executable instructions that, when executed by a processing unit of an electronic computing system, configure the electronic computing system such that the electronic computing system:

• receives an original query from a querying client, the original query expressed in a Language Integrated Query (LINQ) query language;
• automatically determines whether the original query includes a clause unsupported by a Collaborative Application Markup Language (CAML) query language;
• automatically separates, in response to determining that the original query includes an clause unsupported by the CAML query language, the original query into a client-side query and at least one server-side query, the server-side query comprising supported clauses of the original query, the client-side query comprising unsupported clauses of the original query;
• automatically determines, after separating the original query into the server-side query and the client-side query, whether the client-side query is efficient, the client-side query being efficient when the client-side query does not require retrieval of redundant data from a database;
• automatically translates the server-side query into a supplemental query expressed in the CAML query language;
• automatically dispatches the server-side query;
• automatically receives, after dispatching the server-side query, a server-side result set from a database management system, the database management system managing the database, the server-side result set comprising data items in the database responsive to the supplemental query;
• automatically generates, when the electronic computing system determines that the client-side query is efficient, a client-side result set by querying the server-side result set using the client-side query;
• automatically returns, when the electronic computing system determines that the client-side query is efficient, the client-side result set to the querying client as a result set of the original query;
• automatically determines, when the computing system determines that the client-side query is not efficient, whether execution of inefficient queries selected;
• automatically generates, when the electronic computing system determines that the client-side query is not efficient and determines that execution of inefficient queries is selected, the client-side result set by querying the server-side result set using the client-side query;
• and
• automatically sends, in response to determining that the client-side query is not efficient and that execution of inefficient queries is not selected, an error message to the querying client, the error message indicating to the querying client that the electronic computing system did not execute the original query because the original query is not efficient.