Abstract: A method and associated system for improving the operation of an optimizer module of a database-management system. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

Abstract: A method and associated system for offloading the collection and optimization of database statistics to an external computer system, without using significant resources required by the database system during its normal operation. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

Abstract: A method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

Abstract: A method and associated system for offloading the collection and optimization of database statistics to an external computer system, without using significant resources required by the database system during its normal operation. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

Abstract: A method and system for determining account health, identifying and rating hidden and visible risks, and identifying remediation actions in response to identified risks and as a means to improve account health scores is provided. The method includes retrieving metrics associated with a customer account of a customer. Aggregated metrics from the metrics and additional aggregated metrics are generated and stored. Weighting factors are applied to the aggregated metrics and the additional aggregated metrics. Attributes of events and symptoms of incidents are modeled to identify best fit & possible root causes.