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