Abstract: A computer-implemented method, system and computer program product for improving performance for retrieving and reporting information from a data warehouse. A query (e.g., SQL query) is received. If a materialized view is present, and if such a materialized view was generated within the designated time frame, then the query is translated to query a materialized view. The translated query is then sent to a first data storage database of the data warehouse storing materialized views to be processed to obtain the materialized object associated with the query. If, on the other hand, the materialized view is not present, or the materialized view is present but has not been generated within the designated time frame, then the query is sent to the second data storage database of the data warehouse storing the original data without any modification to retrieve and report the appropriate information from the second data storage database.

Abstract: Using a code transformation tool, a portion of executable code is inserted into existing executable code, the existing executable code comprising an existing constructor of a class, the existing constructor, when executed, instantiating an object of the class. During execution of the existing constructor, execution of the portion is caused to occur, the execution generating a record, the record comprising execution tracing data of the object.

Abstract: A computer-implemented method, system and computer program product for improving performance for retrieving and reporting information from a data warehouse. A query (e.g., SQL query) is received. If a materialized view is present, and if such a materialized view was generated within the designated time frame, then the query is translated to query a materialized view. The translated query is then sent to a first data storage database of the data warehouse storing materialized views to be processed to obtain the materialized object associated with the query. If, on the other hand, the materialized view is not present, or the materialized view is present but has not been generated within the designated time frame, then the query is sent to the second data storage database of the data warehouse storing the original data without any modification to retrieve and report the appropriate information from the second data storage database.

Abstract: Using a code transformation tool, a portion of executable code is inserted into existing executable code, the existing executable code comprising an existing constructor of a class, the existing constructor, when executed, instantiating an object of the class. During execution of the existing constructor, execution of the portion is caused to occur, the execution generating a record, the record comprising execution tracing data of the object.