Ed-Fi ODS/API - New Capabilities (205)

TODS - Metadata Tables

• tods.Snapshot: Stores snapshot-level metadata, such as the SnapshotName and the Status (e.g., ACTIVE).
• tods.SnapshotCode:
  • Associates individual Snapshot records to one or more SnapshotCodes
  • This supports snapshot aliasing, meaning that client systems and queries can use multiple names to query or perform operations against a single Snapshot
  • A set of metadata-to-data bridge tables: t_[ODS namespace].[ODS table name]SnapshotRecord
    • e.g., t_edfi.StudentSnapshotRecord
    • Associates individual records in the T-ODS domain aggregate data tables to one or more snapshots.

TODS - Data Tables

• The T-ODS contains a set of data tables parallel to the Ed-Fi ODS data tables, including Ed-Fi Extensions
• SQL schema generated using MetaEd
• To support the ODS extension schema, as well as plans for future namespace extensions, T-ODS data tables are generated in a separate schema for every ODS table generated presently
• The T-ODS data tables are generated using the schema naming convention: t_[ODS namespace] (e.g., t_edfi, t_extension)
• The T-ODS tables are generated within the ODS database

Partial Student model - a concrete example to show the relationships between:

• Snapshot metadata and the t_[ODS namespace].[domain root table name]SnapshotRecord tables
• Relationships between the domain data tables, type tables, and Ed-Fi Descriptor tables
• Note that relationships within the domain data tables such as the parent-child relationship are established via new primary key identities (i.e., "tid_[TableName]") instead of natural keys or their ODS surrogate keys.