Concurrency control for extraction, transform, load processes
AssigneeInternational Business Machines Corporation
InventorsYing Chen, Bin He, Rui Wang
Life of this patent
Estimating the term…
Abstract
System and methods manage concurrent ETL processes accessing a database. Exemplary embodiments include a method for concurrency management for ETL processes in a database having database tables and communicatively coupled to a computer, the method including establishing a session lock for the database, determining that a current ETL process is accessing the database at a current time, associating a current expiration time with the session lock, the expiration time being stored in a lock table in the database, sending the session lock to the current ETL process and performing ETL-level locking for the current ETL process.
Claims20
A method for concurrency management for extraction, transform, load (ETL) processes in a database having database tables and communicatively coupled to a computer, the method comprising:
- establishing a session lock for the database;
- determining that a current ETL process is accessing the database at a current time;
- associating a current expiration time with the session lock, the expiration time being stored in a lock table in the database;
- sending the session lock to the current ETL process;
- and
- performing ETL-level locking for the current ETL process.
A database communicatively coupled to a computer having a current ETL process, the database comprising:
- data accessible to the current ETL process;
- at least one database table including the data accessible to the ETL process;
- and
- a lock table including an expiration time value for a subsequent ETL process, the subsequent ETL process accessing data accessible to the current ETL process in the at least one database table.
A computer program product for concurrency management for extraction, transform, load (ETL) processes in a database having database tables and communicatively coupled to a computer, the computer program product including instructions for causing the computer to implement a method, the method comprising:
- establishing a session lock for the database;
- determining that a current ETL process is accessing the database at a current time;
- associating a current expiration time with the session lock, the expiration time being stored in a lock table in the database;
- sending the session lock to the current ETL process;
- and
- performing ETL-level locking for the current ETL process.
Dependencies are inferred from the claim text.