Avillach, Murphy, et al., discuss the challenge in going from the dimensional tables of i2b2 (and similar data stores) to the sparse table representation that is expected in most instantiations of the PIC-SURE API.