Notes: Team: TTL Automation - Cleanup & Design - Implementation Sai/George as team

---------------------- -- Setup: ---------------------- - Build NEW Oracle 26ai DB and environment for dev (not current prod) - Test Stand-alone machine for builds in OCI (Ask about OCI Integration - Buckets etc.) ---------------------- -- Changes: ---------------------- Add: Dashboard for Execution and Process Management Add: Multi-Graph Build (parallel processing) Add: Multi-Version Support: DP_COUNTRY_ID, DP_VERSION Add: Trig: Graph Update Date Add: System Info (Database Info) Add: Validation of row level data vs views Add: Referential Integrity Checks in Graph (No internal dead links) Add: Tighter integration with pel_supplemental_v250415.ttl files (Automate upload of file from external sources as part of build (New UCA? or Integrate Poojan's processing into this process.) Enhance: Multi-Graph Support (GKG,Lexi-Pediatric-DRC) Enhance: Data Driven Index Creation vs Script? Refactor: DrugImage IRI (External IRIs - UTIL_GRF_R2RML_COLUMN_EXTERNAL? vs Output Data in View??) Refactor: ICD10 Request (External IRIs/Granularity) Refactor: Manual Table Builds Refactor: Tables per Graph (for parallel processing) or Graph Column Implementation?? ---------------------- -- Concepts and Parts: ---------------------- Separate out Migration Doc to sections: 1. Database Objects (Views) 2. Tables, Indexes, Metadata, Customer Meta Generation 3. Generation: Download tables, Generate TTL file 4. Validation: Validate files and Data OCI Machine for use Design Goals: Built for Performance (FAST is the only way here) DB METADATA: DB OBJECTS: SDK Views, Tables, Indexes - Auto Build DB in general other items Terraform? Git Repository Structure Naming Convension and Folders for Organization of Project items