International Business Machines Corporation

Vitaliy Bondar

Rick A Hamilton, Ii

Clifford A Pickover

Randal James Richardt

Ching-Hua Chen-Ritzo

Nicholas K Puz

Ralph Peter Williams

Rupa Bhaghavan

Methods, systems and apparatus for optimizing consumption of one or more resources are presented. For example, a method may be implemented on a processor device and includes obtaining user preferences for the consumption of resources that include water and electricity, predicting the consumption of, and a first metric for the consumption of, the resources for each of a plurality of first time periods, determining a projected second metric for the consumption of the resources during a second time period according to the predicted consumption and the predicted first metric, and optimizing the consumption of the resources according to the projected second metric and the user preferences. The second time period includes the plurality of first time periods. The first metric is associated with the user preferences and at least one of the plurality of first time periods. The second metric indicates full or partial projected attainment of the preferences during the second time period.

Optimizing consumption of resources

A method, system and article of manufacture for two phase intermediate query security using access control. A networked client-server computer system having a plurality of users of the client-server system and including software performing database queries via a DBMS for users of the system implements the method. The method includes receiving a query string from one of the users by the client system, the query string including references to database objects. The received query string is transformed by the client system to an intermediate query string, and a first phase query security is performed by the client system including identifying the referenced database objects and inserting a security marker into the intermediate query string for each respective identified database object, and sending the intermediate query string to the server system. Access control checks are performed by the server system on the inserted security markers in the intermediate query string, and the inserted security markers are replaced with corresponding DBMS code to enforce access control.

Two phase intermediate query security using access control

Growing community of inventors

San Jose, CA, United States of America

Vitaliy Bondar