×

System and method for pre-compiling a query and pre-keying a database system

  • US 7,693,826 B1
  • Filed: 06/11/2004
  • Issued: 04/06/2010
  • Est. Priority Date: 06/11/2004
  • Status: Active Grant
First Claim
Patent Images

1. A database system, including memory and at least one processor, capable of deploying a pre-compiled query and pre-keying data associated with the pre-compiled query, the system comprising:

  • at least one master node operable to store a pre-compiled query and a top level key, the pre-compiled query being stored on the master node in advance of receiving a plurality of data requests capable of being resolved by the pre-compiled query;

    a communication channel; and

    a plurality of slave nodes coupled to the at least one master node by the communication channel, each of the plurality of slave nodes operable to store one or more key parts comprising a portion of a data file sorted based on the pre-compiled query in advance of receiving the plurality of data requests,wherein the top level key associates a particular one of the key parts with one of the plurality of slave nodes that stores the particular one of the key parts, andwherein the at least one master node executes the pre-compiled query by communicating the data requests over the communication channel to the plurality of slave nodes, and the plurality of slave nodes perform operations responsive to the data requests to resolve the data requests by accessing the one or more key parts.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×