Changes between Version 19 and Version 20 of LEGACY - i2b2 - The algorithms applied to importing a PDO


Ignore:
Timestamp:
12/30/11 15:43:04 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2 - The algorithms applied to importing a PDO

    v19 v20  
    9797If an error does occur, the overall loading process (of the seven possible subsets) is terminated, so the situation can be one of uncertainty. For example, the process could be terminated after three of the seven subsets had been processed, leaving four unprocessed.
    9898
     99Comments on the steps:
     100 * The load temporary table step is basically mapping the data within the relevant PDO subset into a temporary table. Nothing too controversial about this (one might think), but there are cardinality issues. I'll take these up when the pid_set processing is considered in detail.
     101 * For each PDO subset, the real work is done in step/txn 4 where a temporary table is merged with a real table. The detailed processing for this is always carried out by a database procedure.