Versions Compared

Old Version 4

changes.mady.by.user Daniel Popham

Saved on

compared with

New Version 5

changes.mady.by.user Daniel Popham

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page will be used to track the different projects that need to be moved from the Oracle Exadata environment to another environment.

Database Schema List

The list of affected projects are below:

...

  • CDRNLabReload    
  • CDRNStaticIdDAG    
  • CODI_DAG    
  • CVD19GetPatKeys
  • STAR_CopyPcornetTables
  • STAR_ETL_Master    
  • STAR_ETL_PostOp    
  • STAR_Inc_Load    
  • STAR_N3C_Hash_Tokens    
  • STAR_Recover    


Exadata Schema NameProject NameProcess TypeProcess NameProcess LocationOwnerNotes

ACT_I2B2_DATA

ACTN/A
N/ADaniel Popham




Decommissioned

process

project as of May 2023. However, there is data in the following schemas that should be archived somewhere before Exadata is decommissioned.

ACT_I2B2_HIVE

ACTN/A
N/ADaniel Popham

ACT_I2B2_IMDATA

ACTN/A
N/ADaniel Popham

ACT_I2B2_METADATA

ACTN/A
N/ADaniel Popham

ACT_I2B2_PM

ACTN/A
N/ADaniel Popham

ACT_I2B2_SHRINE_ONT

ACTN/A
N/ADaniel Popham

ACT_I2B2_WORKDATA

ACTN/A
N/ADaniel Popham
ACT_TEST_DATAACTN/A
N/ADaniel Popham




Decommissioned project as of May 2023. All of these schemas can be removed.

ACT_TEST_HIVEACTN/A
N/ADaniel Popham
ACT_TEST_IMDATAACTN/A
N/ADaniel Popham
ACT_TEST_METADATAACTN/A
N/ADaniel Popham
ACT_TEST_PMACTN/A
N/ADaniel Popham
ACT_TEST_SHRINE_ONTACTN/A
N/ADaniel Popham
ACT_TEST_WORKDATAACTN/A
N/ADaniel Popham
CODICODIAirflow DAG

CODI_DAG

DEV: plt-nosql01.dhe.duke.edu

PRD: plp-nosql01.dhe.duke.edu

Daniel PophamContains data used for the CODI project, supported by the PCORNet CDM data.

HSC_I2B2_DATA

Carolinas Collaborative (CC)N/A
N/ADaniel Popham







Decommissioned project some time before 2020. However, required to keep data until end of year 2025 for archival/historical purposes. Data in the following schemas should be archived somewhere before Exadata is decommissioned

HSC_I2B2_HIVECarolinas Collaborative (CC)N/A
N/ADaniel Popham
HSC_I2B2_IMDATACarolinas Collaborative (CC)N/A
N/ADaniel Popham
HSC_I2B2_METADATACarolinas Collaborative (CC)N/A
N/ADaniel Popham
HSC_I2B2_PMCarolinas Collaborative (CC)N/A
N/ADaniel Popham
HSC_I2B2_SHRINE_ONTCarolinas Collaborative (CC)N/A
N/ADaniel Popham
HSC_I2B2_WORKDATACarolinas Collaborative (CC)N/A
N/ADaniel Popham





HSC_PCOR

PCORNet/STARAirflow DAGs
  • CDRNLabReload    
  • CDRNStaticIdDAG    
  • CVD19GetPatKeys
  • STAR_CopyPcornetTables
  • STAR_ETL_Master    
  • STAR_ETL_PostOp    
  • STAR_Inc_Load    
  • STAR_N3C_Hash_Tokens    
  • STAR_Recover    

DEV: plt-nosql01.dhe.duke.edu

PRD: plp-nosql01.dhe.duke.edu

Daniel Popham




Project that contains the PCORNet CDM data that is refreshed both quarterly and monthly.

BayerPython Script\\duhs-clin-nc1\duhs_pmn_dmc_fs\Bayer\BayerExtract.py

vwp-pmndmc.dhe.duke.edu

Daniel Popham

Data extract from external database. Not affected by migration.

RXNORMPCORNet/STARUnix Shell Script/dwhome/airflow_ci/master/dags/CDRN_ETL/RxNormLoad/RxNormLoad.sh

DEV: plt-nosql01.dhe.duke.edu

PRD: plp-nosql01.dhe.duke.edu

Daniel PophamProcess related to the PCORNet/STAR project that refreshes RxNorm data on a quarterly basis, before the STAR quarterly refresh. Manually run.
RXNORM_2017PCORNet/STARWindows Batch File\\duhs-clin-nc1\duhs_pmn_dmc_fs\N3C\Project\N3C_Main.batvwp-pmndmc.dhe.duke.eduDaniel PophamActually used for N3C project. These tables should be moved somewhere else that makes more sense.