公开(公告)号：US11971793B2

公开(公告)日：2024-04-30

申请号：US16292990

申请日：2019-03-05

Applicant: ENTIT Software LLC

Inventor： Yuanzhe Bei ,  Zhihao Zheng

IPC: G06F16/00 ,  G06F7/00 ,  G06F11/30 ,  G06F16/2453 ,  G06F16/901

CPC classification number: G06F11/3006 ,  G06F16/24542 ,  G06F16/9027

Abstract: Current physical resources utilization of a computing system as a whole is monitored. The number of queries concurrently being executed against a database by a database management system (DBMS) running on a computing system is monitored. A query plan for a received query to be executed against the database is generated. The query plan includes operators; the generation of the query plan includes generation of query-based statistics for the received query on a per-operator basis without consideration of the queries concurrently being executed. An estimated execution time of the received query is dynamically predicted using a machine-learning model based on the query-based statistics generated for the received query on the per-operator basis, the current physical resources utilization of the computing system, and the number of queries concurrently being executed. The received query is executed against the database based on the dynamically predicted estimated execution time for the received query.

公开(公告)号：US20200311043A1

公开(公告)日：2020-10-01

申请号：US16368428

申请日：2019-03-28

Applicant: ENTIT Software LLC

Inventor： Thao Nguyen Pham ,  Yuanzhe Bei ,  Michael Leuchtenburg ,  Hoa Binh Nga Tran

IPC: G06F16/22 ,  G06F16/242

Abstract: A flattened table (FT) of a database of a database management system (DBMS) is defined. The FT logically materializes a number of columns over a number of partitions. The columns include normalized columns, denormalized columns from a plurality of source tables of the database, as well as an aggregate column defining an aggregation of a selected normalized column over a selected denormalized column. A live-aggregate projection (LAP) is defined on the FT of the database. The LAP corresponds to the aggregate column and physically materializes the aggregation of the selected denormalized column over the selected denormalized column, as defined by the aggregate column. The FT is refreshed on-demand, on a per-column, per-partition basis. Responsive to the FT being refreshed on-demand, the LAP is automatically refreshed.

公开(公告)号：US20200285642A1

公开(公告)日：2020-09-10

申请号：US16292990

申请日：2019-03-05

Applicant: ENTIT Software LLC

Inventor： Yuanzhe Bei ,  Zhihao Zheng

IPC: G06F16/2453 ,  G06N20/00 ,  G06F11/30 ,  G06K9/62 ,  G06F16/901

Abstract: Current physical resources utilization of a computing system as a whole is monitored. The number of queries concurrently being executed against a database by a database management system (DBMS) running on a computing system is monitored. A query plan for a received query to be executed against the database is generated. The query plan includes operators; the generation of the query plan includes generation of query-based statistics for the received query on a per-operator basis without consideration of the queries concurrently being executed. An estimated execution time of the received query is dynamically predicted using a machine-learning model based on the query-based statistics generated for the received query on the per-operator basis, the current physical resources utilization of the computing system, and the number of queries concurrently being executed. The received query is executed against the database based on the dynamically predicted estimated execution time for the received query.