Skip to main content
Blackboard Help

ODS Schema

An operational data store (ODS) is a database designed to integrate data from multiple sources. The ODS schema consists of tables and synonyms based on core tables and views. The ODS schema resides in the stats database.

By providing this set of diagrams and views, customers can generate custom report definitions. These definitions can be used with the BIRT Report Designer and Eclipse plugin to import custom built report definitions into Outcomes.

The ODS schema is broken down into multiple star schemas. Each star schema is centered on a fact views surrounded by dimension and miscellaneous views, which are views that do not fit into a star schema but are useful. A description for each star schema and their fact views are included in this section.

The dimension and miscellaneous views are described separately in an alphabetical list since they are shared between star schemas.