Invention Grant
- Patent Title: Implementation of data access metrics for automated physical database design
-
Application No.: US17324896Application Date: 2021-05-19
-
Publication No.: US11803521B2Publication Date: 2023-10-31
- Inventor: Michael Brendle , Norman May , Robert Schulze , Alexander Boehm , Guido Moerkotte , Michael Grossniklaus
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/22 ; G06F11/34 ; G06F16/2455 ; G06F16/2457 ; G06F16/2453 ; G06F16/215 ; H03M7/30

Abstract:
The present disclosure involves systems, software, and computer implemented methods for improved design and implementation of data access metrics for automated physical database design. An example method includes identifying a database workload for which index advisor access counters are to be tracked. Each SQL statement in the database workload is executed. For each SQL statement, attribute sets are determined for which a selection predicate filters a result for an SQL statement. An output cardinality of each selection predicate is determined. A logarithmic counter for an attribute set corresponding to the selection predicate is determined based on the output cardinality of the selection predicate. The determined logarithmic counter is incremented. Respective values for logarithmic counters of the determined attributes are provided to an index advisor. The index advisor determines attribute sets for which to propose an index based on the logarithmic counters of the respective attribute sets.
Public/Granted literature
- US20220269684A1 DESIGN AND IMPLEMENTATION OF DATA ACCESS METRICS FOR AUTOMATED PHYSICAL DATABASE DESIGN Public/Granted day:2022-08-25
Information query