The i2 Link Notebook enabled investigators to create entity relationship diagrams ( a kind of visual database ) allowing raw intelligence largely textual reports ( e . g . witness statements ) to be entered manually, revealing the relationships within the data and enabling data from different sources to be collated and graded.
22.
The LDDT software, ADAM, supported view ( model ) entry, view merging, selective ( subset ) viewing, namespace inheritance, normalization, a quality assurance analysis of views, entity relationship graph and report generation, transformation to a relational database expressed as SQL data declaration statements, and referential integrity checking SQL . Logical models were serialized with a structural modeling language.
