Footprints Data Model |
Table |
Name | data_mart_load_lock |
Comment |
A pessimistic lock table designed to prevent multiple loads from running against the same item. It is also used to count and throttle the number of simultaneous loads. Both the full and incremental loads drop and create tables so that faster non-logged database operations can be used (Select * INTO..., CREATE TABLE AS SELECT *...) The tables have item specific names, so they must single thread. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
data_mart_name | varchar(255) | The name of the Data Mart Load Lock. | Yes | No |
item_defn_id | bigint | A Foreign Key to the Definition table. | Yes | Yes |
is_locked | bit | Indicates if Is Locked. | No | No |
owning_proc_id | varchar(255) | The name of the Data Mart Load Lock. | No | No |
data_mart_load_lock_id | bigint | A Foreign Key to the Data Mart Load Lock table. | No | No |