×

Database query construction and handling

  • US 7,984,058 B2
  • Filed: 05/03/2006
  • Issued: 07/19/2011
  • Est. Priority Date: 06/02/2005
  • Status: Active Grant
First Claim
Patent Images

1. A computer implemented method, comprising:

  • receiving, by a processor, a selection of meta data from a client system indicative of searchable data values stored in two or more database tables, wherein a first database table stores search groups and a second database table stores search conditions for each group;

    constructing, by the processor, a complex database query, by concatenating structured query language (SQL) snippets together to form the complex database query, to search the two or more database tables based on the received selection of meta data;

    identifying, by the processor, each condition of the complex database query with a unique condition identifier and a unique group identifier for a group to which the condition is a member;

    storing, by the processor, query meta data with the unique condition identifier and the unique group identifier that represents the complex database query;

    in response to a determination that one or more data items obtained from evaluation of the complex database query are being displayed by the client system, reconstructing, by the processor, the complex database query from the stored query meta data at periodic intervals to update the one or more database items independent of client system requests to update the one or more data items;

    writing the complex database query to a tracking server, the tracking server to provide modified links to the client system for entry to a website, the modified links in a format that resembles a website address for the website served from a web server, but to resolve at the tracking server through which client system interactions with the website can be tracked;

    for each periodic interval, the tracking server evaluating the complex database query against a tracking database coupled with the tracking server, the tracking database to store user clickflow data for client system selections of the modified links monitored and updated by the tracking server in real time; and

    sending a result of the evaluation to the client system to update the display of the one or more data items to provide real time updates for results of the evaluated complex database query to a user without receiving a query request from the user.

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