Sakai Enterprise Database BANNER Data Sourcing
This page will describe the critical information about sourcing data to the External Database from Banner.
Requirements
- Availability: The BANNER data used by Sakai must be available on a 24x7 basis.
- Fast Refresh: Updated Student Registration information must be available as soon as possible. In general, the other BANNER data sources do not need to be updated as frequently.
- Flexibility: The resultant data store must be felxible enough to adapt to changes in Sakai's data requirements, as well as to include and augment data with data from external sources.
BANNER, while a core campus system, is not yet a 24x7 application. In the current Course Management system there are weekly and monthly scheduled downtimes in order to account for the system's dependency on the BANNER data. This is a glaring deficiency we would like to correct in the Sakai External Database.
SED ERD.vsd - Original BANNER External Database ERD (Created in visio and unconvertable, will need to replace once a new ERD tool is found)
Banner Tables.vsd - BANNER Table descriptions (Created in Visio)
SQL Scripts
Banner MViews.sql - The sql ddl for the BANNER Materialized Views (deployed in the SED Schema)
Banner MV Logs.sql - Sql ddl for the BANNER Materialized View Logs (deployed on the BANNER instance)