Concurrency control for extraction, transform, load processes
US8655859B2 · kind B2 · utility
0Cited by
4References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 1, 2010 |
| Grant date | Feb 18, 2014 |
| Priority date | — |
| Expiry date | Aug 30, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2336
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.