Invention Grant
- Patent Title: Concurrency control for extraction, transform, load processes
- Patent Title (中): 提取,转换,加载过程的并发控制
-
Application No.: US12714929Application Date: 2010-03-01
-
Publication No.: US08655859B2Publication Date: 2014-02-18
- Inventor: Ying Chen , Bin He , Rui Wang
- Applicant: Ying Chen , Bin He , Rui Wang
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

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.
Public/Granted literature
- US20110213756A1 CONCURRENCY CONTROL FOR EXTRACTION, TRANSFORM, LOAD PROCESSES Public/Granted day:2011-09-01
Information query