# US 2006/0277157 A1 · Database query construction and handling > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2006/0277157 A1 - Document ID: US20060277157A1 - Status: Published application - Kind: A1 - Application number: 11/417,948 - Filed: 2006-05-03 - Published: 2006-12-07 - Earliest claimed: 2005-06-02 - Assignees: Genius.com Incorporated - Inventors: Robert Seidl; Frank Flynn; Michael DeLorenzo - Web page: https://patentgrep.com/patent/US20060277157A1 ## CPC - G06F 16/24575: {using context} - G06F 16/2423: {Interactive query statement specification based on a database schema} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A method and apparatus is disclosed herein for constructing a complex database query. In one embodiment, the method comprises receiving a selection of meta data indicative of searchable data values stored in two or more database tables. The method also includes constructing a complex database query to search the two or more database tables based on the received selection of meta data. ## Claims ### Claim 1 A method, comprising: receiving a selection of meta data indicative of searchable data values stored in two or more database tables; and constructing a complex database query to search the two or more database tables based on the received selection of meta data. ### Claim 2 (depends on 1) The method of claim 1, further comprising: evaluating the complex database query. ### Claim 3 (depends on 2) The method of claim 2, further comprising: receiving resultant meta information, in response to evaluating the complex database query, corresponding to the constructed complex database query; and dynamically generating a graphical user interface based on the received resultant meta information. ### Claim 4 (depends on 1) The method of claim 1, wherein the complex query is a complex multi-table and multi-database query. ### Claim 5 (depends on 1) The method of claim 1, wherein the meta data is a condition defined by a field, an operator, and a value. ### Claim 6 (depends on 1) The method of claim 1, wherein the query is a compound query comprising a plurality of conditions. ### Claim 7 (depends on 1) The method of claim 1, further comprising: validating the selection of metadata, prior to constructing the complex database query, when the received selection includes user-inputted data. ### Claim 8 (depends on 7) The method of claim 7, further comprising: notifying a user when the selection of metadata includes invalid meta data. ### Claim 9 (depends on 1) The method of claim 1, further comprising: obtaining metadata indicative of all searchable data values associated with an identification of a user using a user interface; dynamically constructing a user interface, prior to the receiving, to present the metadata indicative of all searchable data values. ### Claim 10 (depends on 1) The method of claim 1, wherein the constructing is performed by a Hypertext Preprocessor (PHP) script. ### Claim 11 (depends on 1) The method of claim 1, further comprises: concatenating structured query language (SQL) snippets together to form the complex database query. ### Claim 12 (depends on 11) The method of claim 11, further comprising: joining the two or more database tables into a single searchable database table. ### Claim 13 (depends on 1) The method of claim 1, wherein the searchable data is clickflow data indicative of a user's interactions with a web page. ### Claim 14 (depends on 1) The method of claim 1, further comprising: adding new searchable data values to the two or more database tables; and updating metadata definitions for the new searchable data values. ### Claim 15 A machine-readable medium that provides instructions, which when executed by a receiving a selection of meta data indicative of searchable data values stored in two or more database tables; and constructing a complex database query to search the two or more database tables based on the received selection of meta data.machine, causes the machine to perform the operations comprising: ### Claim 16 (depends on 15) The machine readable medium of claim 15, further comprising: evaluating the complex database query. ### Claim 17 (depends on 16) The machine readable medium of claim 16, further comprising: receiving resultant meta information, in response to evaluating the complex database query, corresponding to the constructed complex database query; and dynamically generating a graphical user interface based on the received resultant meta information. ### Claim 18 (depends on 15) The machine readable medium of claim 15, wherein the complex query is a complex multi-table and multi-database query. ### Claim 19 (depends on 15) The machine readable medium of claim 15, wherein the meta data is a condition defined by a field, an operator, and a value. ### Claim 20 (depends on 15) The machine readable medium of claim 15, wherein the query is a compound query comprising a plurality of conditions. ### Claim 21 (depends on 15) The machine readable medium of claim 15, further comprising: validating the selection of metadata, prior to constructing the complex database query, when the received selection includes user-inputted data. ### Claim 22 (depends on 21) The machine readable medium of claim 21, further comprising: notifying a user when the selection of metadata includes invalid meta data. ### Claim 23 (depends on 15) The machine readable medium of claim 15, further comprising: obtaining metadata indicative of all searchable data values associated with an identification of a user using a user interface; dynamically constructing a user interface, prior to the receiving, to present the metadata indicative of all searchable data values. ### Claim 24 (depends on 15) The machine readable medium of claim 15, wherein the constructing is performed by a Hypertext Preprocessor (PHP) script. ### Claim 25 (depends on 15) The machine readable medium of claim 15, further comprises: concatenating structured query language (SQL) snippets together to form the complex database query. ### Claim 26 (depends on 25) The machine readable medium of claim 25, further comprising: joining the two or more database tables into a single searchable database table. ### Claim 27 (depends on 15) The machine readable medium of claim 15, wherein the searchable data is clickflow data indicative of a user's interactions with a web page. ### Claim 28 (depends on 15) The machine readable medium of claim 15, further comprising: adding new searchable data values to the two or more database tables; and updating metadata definitions for the new searchable data values. ### Claim 29 A system, comprising: a database; and a client, wherein the client is to: receive a selection of meta data indicative of searchable data values stored in two or more database tables of the database; and construct a complex database query to search the two or more database tables based on the received selection of meta data. ### Claim 30 (depends on 29) The system of claim 29, further comprising: the client to request an evaluation of the complex database query. ### Claim 31 (depends on 30) The system of claim 30, further comprising: the client to: receive resultant meta information, in response to the request, corresponding to the complex database query; and dynamically generate a graphical user interface based on the received resultant meta information. ### Claim 32 (depends on 29) The system of claim 29, wherein the complex query is a complex multi-table and multi-database query. ### Claim 33 (depends on 29) The system of claim 29, wherein the meta data is a condition defined by a field, an operator, and a value. ### Claim 34 (depends on 29) The system of claim 29, wherein the query is a compound query comprising a plurality of conditions. ### Claim 35 (depends on 29) The system of claim 29, further comprising: the client to: validate the selection of metadata, prior to construction of the complex database query, when the received selection includes user-inputted data. ### Claim 36 (depends on 35) The system of claim 35, further comprising: the client to: notify a user when the selection of metadata includes invalid meta data. ### Claim 37 (depends on 29) The system of claim 29, further comprising: the client to: obtain metadata indicative of all searchable data values associated with an identification of a user using a user interface; dynamically construct a user interface to present the metadata indicative of all searchable data values before the selection of meta data is received. ### Claim 38 (depends on 29) The system of claim 29, wherein the construction is performed by a Hypertext Preprocessor (PHP) script. ### Claim 39 (depends on 29) The system of claim 29, further comprises: the client to: concatenate structured query language (SQL) snippets together to form the complex database query. ### Claim 40 (depends on 29) The system of claim 29, further comprising: the client to: join the two or more database tables into a single searchable database table. ### Claim 41 (depends on 29) The system of claim 29, wherein the searchable data is clickflow data indicative of a user's interactions with a web page. ### Claim 42 (depends on 29) The system of claim 29, further comprising: the client to: adding new searchable data values to the two or more database tables; and updating metadata definitions for the new searchable data values.