DATABASE PERFORMANCE ANALYSIS

摘要

A computer-implemented method, a computer program product and a system are provided. The method relates to calculating a duration of an action, wherein the action comprises at least one database operation, wherein the action is one of multiple actions carried out in order to process a request, wherein processing the request includes executing multiple applications, each application having a corresponding application database, wherein the execution of one of the applications includes performing the action on the corresponding application database and storing duration information for the action. The method comprises determining a primary order identifier of the action. Also, the method further comprises querying the stored duration information. The querying comprises specifying a proper subset of attributes of one or more relations, the relations including at least one table, each relation including a plurality of rows. The attributes describe the primary order identifier. The attributes further describing a subset of the duration information including a start time of the action. The querying further comprises specifying conditions that must be met by at least one row of the relations, wherein at least one condition includes attributes of multiple relations. The querying further comprises retrieving, according to the conditions, the specified attributes of the at least one row of the relations. The querying further comprises calculating a duration of the action based on the start time of the action.