RULES-BASED SYNCHRONOUS QUERY PROCESSING FOR LARGE DATASETS IN AN ON-DEMAND ENVIRONMENT
In accordance with embodiments, there are provided mechanisms and methods for facilitating rules-based synchronous query processing for large datasets in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method comprises detecting, by a rules-management server computing device, at least one of efficient classes and inefficient classes associated with a query, and designating a set of rules to the query, where one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast. The method may further include executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, where executing includes accessing contents of one or more portions of a database as identified by the set of rules, and transmitting the results in response to the query.
1 . A method comprising:
detecting, by a rules-management server computing device, at least one of efficient classes and inefficient classes associated with a query;
designating a set of rules to the query, wherein one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast;
executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, wherein executing includes accessing contents of one or more portions of a database as identified by the set of rules; and
transmitting the results in response to the query.
2 . The method of claim 1 , further comprising receiving the query from a client computing device over a communication network, wherein the query is placed by a user representing a tenant in a multi-tenant environment.
3 . The method of claim 1 , further comprising anticipating processing patterns of the query based on historical performances associated with the query or other queries similar to the query.
4 . The method of claim 2 , further comprising matching the anticipated processing patterns against the set of rules to identify the one or more portions of the database as being relevant in processing of the query.
5 . The method of claim 1 , wherein executing further comprises accessing contents of the one or more portions of the database without having to access other portions of the database.
6 . The method of claim 1 , wherein the results are generated based on the contents of the one or more portions of the database and further based on the efficient classes without having to process the inefficient classes.
7 . A database system comprising:
a rules-management server computing device having memory coupled to a processing device, the processing device to execute instructions to facilitate a mechanism to perform operations comprising:
detecting at least one of efficient classes and inefficient classes associated with a query;
designating a set of rules to the query, wherein one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast;
executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, wherein executing includes accessing contents of one or more portions of a database as identified by the set of rules; and
transmitting the results in response to the query.
8 . The system of claim 7 , wherein the operations further comprise receiving the query from a client computing device over a communication network, wherein the query is placed by a user representing a tenant in a multi-tenant environment.
9 . The system of claim 7 , wherein the operations further comprise anticipating processing patterns of the query based on historical performances associated with the query or other queries similar to the query.
10 . The system of claim 8 , wherein the operations further comprise matching the anticipated processing patterns against the set of rules to identify the one or more portions of the database as being relevant in processing of the query.
11 . The system of claim 7 , wherein executing further comprises accessing contents of the one or more portions of the database without having to access other portions of the database.
12 . The system of claim 7 , wherein the results are generated based on the contents of the one or more portions of the database and further based on the efficient classes without having to process the inefficient classes.
13 . A machine-readable medium comprising a plurality of instructions which, when executed by a processing device, cause the processing device to perform operations comprising:
detecting at least one of efficient classes and inefficient classes associated with a query;
designating a set of rules to the query, wherein one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast;
executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, wherein executing includes accessing contents of one or more portions of a database as identified by the set of rules; and
transmitting the results in response to the query.
14 . The machine-readable medium of claim 13 , wherein the operations further comprise receiving the query from a client computing device over a communication network, wherein the query is placed by a user representing a tenant in a multi-tenant environment.
15 . The machine-readable medium of claim 13 , wherein the operations further comprise anticipating processing patterns of the query based on historical performances associated with the query or other queries similar to the query.
16 . The machine-readable medium of claim 14 , wherein the operations further comprise matching the anticipated processing patterns against the set of rules to identify the one or more portions of the database as being relevant in processing of the query.
17 . The machine-readable medium of claim 13 , wherein executing further comprises accessing contents of the one or more portions of the database without having to access other portions of the database.
18 . The machine-readable medium of claim 13 , wherein the results are generated based on the contents of the one or more portions of the database and further based on the efficient classes without having to process the inefficient classes.