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.

Abstract: Distributed locks (e.g., among a plurality of database management services) can be used for accessing a database to ensure data consistency in the database during concurrent continuous data processing and schema or data administration of the database. An exclusive lock of the database may not be held for all operations of an extract, transform, load (ETL) process to load data from a data source into the database. 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 can be resolved.

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.