All Tables Proposal List

GET AI Document that explains modeling Relational vs RDF Graph

All tables: multi model distribution files, RDF, etc - Need Same Results for Same Version Regardless of Format

We can NOT distribute all columns e.g. drug_name_id change over time (concept permanence)

We can NOT distribute all tables: e.g. drug_name_distributed (prod fix), tool tables, Xref tables

Data Model as a function of Performance: Normalized, Relational = Write optimized; Denormalized = Read optimized

Data Model as a function of Usability: all tables: Normalized highly complex

Normalization as a function of performance too many hops in RDF Graph (we have current performance problems in SKG) - rules 4 optionals

Views filter data: by country, version, source (e.g. Lexicomp DRC - Licensing)

All tables: what is our goal? Speed or quality?

All tables Multiple Databases GLOBAL_DISTRIBUTE = GR + GE + ? Med Supplies