公开(公告)号：US20220019585A1

公开(公告)日：2022-01-20

申请号：US16930157

申请日：2020-07-15

Applicant: Oracle International Corporation

Inventor： John Mark Beresniewicz

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2458 ,  G06F16/21

Abstract: Techniques for managing database workloads using similarity measures based on queries executed are described. Classical techniques from information retrieval are applied to the domain of database workload management. Specifically, the technique of using document term vectors to compute similarity measures are applied using the conceptual mapping of SQL workloads as “documents” composed of SQL queries as “terms.” The techniques include generating two or more sets of workloads with each workload representing a set of queries executed on at least one database. Based on the sets of workloads, workload term vectors are calculated that represent the set of queries executed on the database. Then, based on the calculated workload vectors, a similarity score is generated between the two or more sets of workloads.

公开(公告)号：US20230128408A1

公开(公告)日：2023-04-27

申请号：US17452094

申请日：2021-10-25

Applicant: Oracle International Corporation

Inventor： Sriram Vrinda ,  Xiaobin Chen ,  Naimuddin Qureshi ,  Hari Krishna Galla ,  John Mark Beresniewicz ,  Shravan Kumar Shivanagari ,  Paul James Tangen

IPC: G06F3/0482 ,  G06F3/0484 ,  G06F11/34

Abstract: Techniques are described for generating a composite display of multiple user interface elements, each of which presents datasets corresponding to the operational parameters of computing resources even though the computer resources may operate in different computing environments. In some cases, the composite display includes a feature that enables a comparison of operational performance data between a target measurement period relative to a selectable reference period. The reference period may be manually selectable from a menu of candidate time periods or identified and/or selected by the system based on a similarity between data characteristics in the target measurement period and a baseline measurement period.

公开(公告)号：US11327969B2

公开(公告)日：2022-05-10

申请号：US16930157

申请日：2020-07-15

Applicant: Oracle International Corporation

Inventor： John Mark Beresniewicz

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/21 ,  G06F16/2458

Abstract: Techniques for managing database workloads using similarity measures based on queries executed are described. Classical techniques from information retrieval are applied to the domain of database workload management. Specifically, the technique of using document term vectors to compute similarity measures are applied using the conceptual mapping of SQL workloads as “documents” composed of SQL queries as “terms.” The techniques include generating two or more sets of workloads with each workload representing a set of queries executed on at least one database. Based on the sets of workloads, workload term vectors are calculated that represent the set of queries executed on the database. Then, based on the calculated workload vectors, a similarity score is generated between the two or more sets of workloads.

公开(公告)号：US12292886B2

公开(公告)日：2025-05-06

申请号：US17580071

申请日：2022-01-20

Applicant: Oracle International Corporation

Inventor： John Mark Beresniewicz ,  Kusumaharanadh Poduri

IPC: G06F16/245 ,  G06F11/30 ,  G06F11/34 ,  G06F16/2453

Abstract: Techniques are described herein for probabilistic monitoring of high-frequency, low-latency database queries. In some embodiments, a probabilistic query monitoring system periodically samples active database sessions. For example, the system may generate sample data every one second or at some other sampling rate for each database session that is currently active. The sample data may include a mapping between query identifiers to sample counter values that are extracted at different sample intervals. The system may then estimate performance metrics for the set of active database based on the counter values sampled across consecutive sample intervals.

公开(公告)号：US12271572B2

公开(公告)日：2025-04-08

申请号：US17452094

申请日：2021-10-25

Applicant: Oracle International Corporation

Inventor： Sriram Vrinda ,  Xiaobin Chen ,  Naimuddin Qureshi ,  Hari Krishna Galla ,  John Mark Beresniewicz ,  Shravan Kumar Shivanagari ,  Paul James Tangen

IPC: G06F11/34 ,  G06F3/0482 ,  G06F3/0484

Abstract: Techniques are described for generating a composite display of multiple user interface elements, each of which presents datasets corresponding to the operational parameters of computing resources even though the computer resources may operate in different computing environments. In some cases, the composite display includes a feature that enables a comparison of operational performance data between a target measurement period relative to a selectable reference period. The reference period may be manually selectable from a menu of candidate time periods or identified and/or selected by the system based on a similarity between data characteristics in the target measurement period and a baseline measurement period.

公开(公告)号：US20230229659A1

公开(公告)日：2023-07-20

申请号：US17580071

申请日：2022-01-20

Applicant: Oracle International Corporation

Inventor： John Mark Beresniewicz ,  Kusumaharanadh Poduri

IPC: G06F16/2453 ,  G06F11/34 ,  G06F11/30

CPC classification number: G06F16/24542 ,  G06F11/3419 ,  G06F11/3075

Abstract: Techniques are described herein for probabilistic monitoring of high-frequency, low-latency database queries. In some embodiments, a probabilistic query monitoring system periodically samples active database sessions. For example, the system may generate sample data every one second or at some other sampling rate for each database session that is currently active. The sample data may include a mapping between query identifiers to sample counter values that are extracted at different sample intervals. The system may then estimate performance metrics for the set of active database based on the counter values sampled across consecutive sample intervals.