System and method for processing query requests in a database system
First Claim
1. A database system for processing a query request, comprising:
- at least one master node operable to;
store a precompiled query that is capable of resolving a query request received by the database system, each precompiled query being a query that has been deployed on the database system in advance of a user executing such query on the database system;
receive a query request comprising one or more parameters used by the precompiled query to resolve the query request;
communicate a request to a slave node to perform one or more activities associated with the precompiled query and one or more top level keys associated with the precompiled query, the one or more top level keys identifying the location of a key part within the database system; and
a plurality of slave nodes coupled to the at least one master node, each of the plurality of slave nodes operable to store one or more key parts each comprising stored data, an address associated with the stored data, and an identifier for identifying the location of additional data that satisfies at least a portion of the precompiled query, wherein the stored data is sorted according to combinations of the one or more parameters used by the precompiled query to resolve the query request, at least one of the plurality of slave nodes operable to;
receive the request communicated by the at least one master node; and
process the request communicated by the at least one master node.
3 Assignments
0 Petitions
Accused Products
Abstract
In certain embodiments, a database system for processing a query request comprises at least one master node operable to store a precompiled query that is capable of resolving a query request received by the database system. The at least on master node is further operable to receive a query request comprising one or more parameters and associated with the precompiled query, and to communicate a request to perform one or more activities associated with the precompiled query. The system further comprises a plurality of slave nodes coupled to the at least one master node, each of the slave nodes operable to store one or more key parts each comprising data capable of resolving a portion of the precompiled query. At least one of the slave nodes is operable to receive the request communicated by the at least one master node and to process the request communicated by the at least one master node.
-
Citations
30 Claims
-
1. A database system for processing a query request, comprising:
-
at least one master node operable to; store a precompiled query that is capable of resolving a query request received by the database system, each precompiled query being a query that has been deployed on the database system in advance of a user executing such query on the database system; receive a query request comprising one or more parameters used by the precompiled query to resolve the query request; communicate a request to a slave node to perform one or more activities associated with the precompiled query and one or more top level keys associated with the precompiled query, the one or more top level keys identifying the location of a key part within the database system; and a plurality of slave nodes coupled to the at least one master node, each of the plurality of slave nodes operable to store one or more key parts each comprising stored data, an address associated with the stored data, and an identifier for identifying the location of additional data that satisfies at least a portion of the precompiled query, wherein the stored data is sorted according to combinations of the one or more parameters used by the precompiled query to resolve the query request, at least one of the plurality of slave nodes operable to; receive the request communicated by the at least one master node; and process the request communicated by the at least one master node. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A method for processing a query request on a database system, the database system comprising one or more master nodes and a plurality of slave nodes coupled to the one or more master nodes, the method comprising:
-
receiving a query request comprising one or more parameters used by a precompiled query to resolve the query request, the precompiled query being stored on at least one master node of the database system and operable to resolve a query request received by the database system, each precompiled query being a query that has been deployed on the database system in advance of a user executing such query on the database system; communicating from the at least one master node a request to a slave node to perform one or more activities associated with the precompiled query and one or more top level keys associated with the precompiled query, the one or more top level keys identifying the location of a key part within the database system; receiving the request to perform one or more activities at one or more of the plurality of slave nodes, each of the plurality of slave nodes operable to store one or more key parts each comprising stored data, an address associated with the stored data, and an identifier for identifying the location of additional data that satisfies at least a portion of the precompiled query, wherein the stored data is sorted according to combinations of the one or more parameters used by the precompiled query to resolve the query request; and processing the request communicated by the at least one master node at the one or more slave nodes. - View Dependent Claims (19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29)
-
-
30. A computer-readable storage medium, storing program instructions for performing, when executed by a processor, a method for processing a query request on a database system, wherein the database system comprises one or more master nodes and a plurality of slave nodes coupled to the one or more master nodes, the method comprising:
-
receiving a query request comprising one or more parameters used by a precompiled query to resolve the query request, the precompiled query being stored on at least one master node of the database system and operable to resolve a query request received by the database system, each precompiled query being a query that has been deployed on the database system in advance of a user executing such query on the database system; communicating from the at least one master node a request to a slave node to perform one or more activities associated with the precompiled query and one or more top level keys associated with the precompiled query, the one or more top level key identifying the location of a key part within the database system; receiving the request to perform one or more activities at one or more of the plurality of slave nodes, each of the plurality of slave nodes operable to store one or more key parts each comprising stored data, an address associated with the stored data, and an identifier for identifying the location of additional data that satisfies at least a portion of the precompiled query, wherein the stored data is sorted according to combinations of the one or more parameters used by the precompiled query to resolve the query request; and processing the request communicated by the at least one master node at the one or more slave nodes.
-
Specification