公开(公告)号：US20230214395A1

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

申请号：US17647338

申请日：2022-01-06

Applicant: VMware, Inc.

Inventor： Iva KOLEVA ,  Antoni IVANOV ,  Dako DAKOV

IPC: G06F16/2455

CPC classification number: G06F16/24564

Abstract: A method for query execution using a dual-resource pool design (e.g., a fast resource pool and a slow resource pool design) is provided. The method includes receiving a first query requesting retrieval of first data from a database, admitting the first query to a fast resource pool for execution, wherein the fast resource pool is configured with one or more thresholds for execution, executing the first query in the fast resource pool using resources allocated to the fast resource pool, during execution of the first query in the fast resource pool, determining the one or more thresholds for execution have been exceeded, admitting the first query to a slow resource pool for execution, and executing the first query in the slow resource pool using resources allocated to the slow resource pool.

公开(公告)号：US20190018865A1

公开(公告)日：2019-01-17

申请号：US15651823

申请日：2017-07-17

Applicant: VMware, Inc.

Inventor： Antoni IVANOV ,  Denitsa GENCHEVA ,  Marin NOZHCHEV

IPC: G06F17/30

CPC classification number: G06F16/212 ,  G06F16/2343 ,  G06F16/2379 ,  G06F16/258

Abstract: Embodiments of the present disclosure relate to techniques for using distributed locks (e.g., among a plurality of database management services) for accessing a database to ensure data consistency in the database during concurrent continuous data processing and schema or data administration of the database. In particular, certain embodiments relate to not holding an exclusive lock of the database for all operations of an extract, transform, load (ETL) process to load data from a data source into the database. Further, certain embodiments relate to resolving schema changes that occur to a database schema of the database in the middle of the ETL process when the exclusive lock is not held.