Patent ID: 8655859

Claim:
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 having a plurality of tables; determining that a first current ETL process is accessing the database at a current time; determining that a second current ETL process is accessing the database at the current time; responsive to the first and second current ETL processes reading from a first subset of the plurality of tables, the first current ETL process writing into a second subset of the plurality of tables, the second current ETL process writing into a third subset of the plurality of tables, the first, second and third subsets being mutually exclusive, executing the first and second ETL processes simultaneously; 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 at least one of the first and second current ETL processes; and responsive to the first and second ETL processes writing into a common subset of the plurality of tables, performing ETL-level locking for the first current ETL process.