2024-9-16 Dan Marcus

• Mirror Database: repo for image data from clinical workflows

  • running for 5-6 year, multiple projects
  • looking for cohort to validate AI models
  • incidental findings discovery tools
  • have ability to get reports, but kind of a struggle
  • images are working but slow
  • trying to get radiology reports to be stable
  • want to run AI models against the data to improve mirror db usage
  • Jenny G helping get DICOM data into data lake
  • This is an extension of that effort but focused on using the mirror db

• Technical Pieces

  • API, creds, etc, focus for today
  • What DB stack
    • psql and other things, can transact in SQL
  • What data are we looking for?
    • EPIC radiant module, an assumption and may not be complete
    • Broker and radiant team create queries to surface to Radiology
    • Radiology's clinical findings, from dictated reports
      • Impressions, diagnosis
    • Some templated reports
      • secondary priority
      • Not sure how they are captured
      • Usually comes to us as plain text
      • May have some tag data
  • Option 1
    • Onboard team into isolated sandbox
    • Brokers would materialize views in the sandbox
      • How to source a broker?
        • Currently getting HL7 files nightly from PowerScribe
        • Anyone that can help figure out what to find from the front end
    • Incremental push 1/day
      • How to do more realtime?
        • maybe a FHIR stream in the future?
        • Albert has an idea to get streaming ADT
  • Option 2
    • DIY ETL
  • Were to push, if needed?
    • Still designing a connector
    • May be able to dump straight to psql for further processing

• Governance Regulatory

  • How to dot the I's
  • Who has access to what

• Billing?