Evaluation of expressions using recursive SQL
AssigneeInternational Business Machines Corporation
InventorsThomas E. Chefalas, Alexei A. Karve
Life of this patent
Estimating the term…
Abstract
The present invention is directed towards a system and method for delivering client content. The system compares a plurality of client properties with a plurality of properties stored in a content server and determines a plurality of Boolean expressions. The system evaluates the expressions according to a recursive SQL query to retrieve applicable qualifying rules. Further, the system supplies an action associated with the applicable qualifying rules to a client. The actions allow client content to be automatically updated from a FTP server.
Claims17
A method for delivering an action to a client device comprising the steps of:
- comparing a plurality of client properties describing the client device with a plurality of properties stored in a content server;
- determining a plurality of expressions applicable to the client device according to the comparison;
- evaluating the plurality of expressions according to a recursive Structured Query Language (SQL) query to retrieve applicable qualifying rules;
- and
- applying the action to the client device, wherein the action is associated with the applicable qualifying rules, and wherein the action installs a software update on the client device changing at least one of the plurality of properties of the client device.
A method for providing an action to a client device over a network in response to a Structured Query Language (SQL) query comprising the steps of:
- accepting a plurality of client properties describing the client device;
- comparing the plurality of client properties with a plurality of properties stored in a database having recursive SQL capabilities;
- determining a plurality of expressions in the database applicable to the client device according to the SQL query;
- evaluating the expressions iteratively to retrieve a plurality of applicable qualifying rules, the qualifying rules associating the expressions with a plurality of actions;
- and
- applying the action to the client device, wherein the action is associated with the applicable qualifying rules, and wherein the action installs a software update on the client device changing at least one of the plurality of properties of the client device.
A computer program product comprising:
- a computer usable medium having computer readable program code embodied therein for causing the computer to provide an action to a client device over a network in response to a Structured Query Language (SQL) query, the computer readable program code in the computer program product comprising:
- computer readable program code for causing a computer to accept a plurality of client properties describing a client device;
- computer readable program code for causing the computer to compare the plurality of client properties with a plurality of properties stored in a database having recursive SQL capabilities;
- computer readable program code for causing the computer to determine a plurality of expressions in the database according to the SQL query applicable to the client device;
- and
- computer readable program code for causing the computer to evaluate the expressions iteratively to retrieve a plurality of applicable qualifying rules, the qualifying rules associating the expressions with a plurality of actions;
- and
- computer readable program code for causing the computer to apply the action to the client device, wherein the action is associated with the applicable qualifying rules, and wherein the action installs a software update on the client device changing at least one of the plurality of properties of the client device.
A system connected to a plurality of clients through an electronic network for determining and applying an action upgrading at least one client comprising:
- an object relational database management system having a recursive capability for determining the action in response to a Structured Query Language (SQL) query based on elements describing the at least one client, the SQL query evaluating logic expressions linking the elements and the determined action;
- and
- a server for receiving a client request specifying the elements, determining the SQL query, and returning the determined action to the at least one client.
Dependencies are inferred from the claim text.