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

Edit

Convert to:

Notes

----------------------
-- 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

Back

Checklist 3 items

☰ Mac

☰ Scripts to Procs

☰ Auromate Procs?

Links

Link

Role

+ New Link

No links