Abstract: 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.

Abstract: Methods, systems and apparatus for optimizing consumption of one or more resources are presented. For example, a method that 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.

Abstract: 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.

Abstract: 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.