RVWG - Architecture Approaches

Owned by Ann Su
Jan 23, 2020
1 min read

Self-Contained

  • Data flows in/out of the Ed-Fi ODS
  • Ed-Fi ODS is the main data store
  • Front-End connects to ODS via API, or direct to DB


Self-Contained++

  • Data Flow - Into the ODS with an Analytic Middle Tier layer

  • Data Store - Separate Schema in ODS

  • Front End - Connects to Analytics Middle Tier and/or ODS

External Access

  • Data Flow - Into the ODS and then Out of the ODS to external system (PostgreSQL, Big Query, etc...)
  • Data Store - Separate stand alone database
  • Front End - Connects to the external source only

Data Warehouse/Lake

  • Data Flow - Into the ODS and then into read-optimized data architecture

  • Data Store - Distinct schema but database can be on the same or external server to ODS

  • Front End - Connects to the data warehouse/lake infrastructure