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