Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

Abstract: A method, via a processor, of forecasting energy usage including selecting a plurality of reference days with at least one feature matching a corresponding feature of a day to be forecasted and filtering the plurality of reference days with a humidity filter to identify at least one matching reference day. The at least one matching reference day is associated with a correlation coefficient greater than or equal to a minimum correlation coefficient, and a minimum number of humidity values within a range of corresponding humidity values of the day to be forecasted. The method also includes retrieving energy load values and corresponding temperature values corresponding to the at least one matching reference day, calculating a plurality of regression coefficients of a polynomial equation linking the temperature values to the energy load values, and calculating and storing a forecasted load value of the day to be forecasted according to the polynomial equation.

Abstract: A method, via a processor, of forecasting energy usage including selecting a plurality of reference days with at least one feature matching a corresponding feature of a day to be forecasted and filtering the plurality of reference days with a humidity filter to identify at least one matching reference day. The at least one matching reference day is associated with a correlation coefficient greater than or equal to a minimum correlation coefficient, and a minimum number of humidity values within a range of corresponding humidity values of the day to be forecasted. The method also includes retrieving energy load values and corresponding temperature values corresponding to the at least one matching reference day, calculating a plurality of regression coefficients of a polynomial equation linking the temperature values to the energy load values, and calculating and storing a forecasted load value of the day to be forecasted according to the polynomial equation.