Banner ODS/EDW - PowerPoint PPT Presentation

banner ods edw n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Banner ODS/EDW PowerPoint Presentation
Download Presentation
Banner ODS/EDW

play fullscreen
1 / 11
Banner ODS/EDW
103 Views
Download Presentation
leal
Download Presentation

Banner ODS/EDW

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Banner ODS/EDW

  2. OLTP • Our Banner database instance is currently 350+ Gbytes in size and is comprised of several hundred tables that house Student, HR, and Finance data. • On a typical day, we have approximate 300 active Banner users with at least as many Self Service Banner users (more during registration, grades, etc) • OLTP is On-Line Transaction Processing

  3. Banner ODS/EDW

  4. ODS – Operation Data Store • The Banner ODS is a real-time copy of the Banner database. • Leverages Oracle Streams technology • The Banner OLTP database has a few views • The BANNER ODS has many views to de-normalize the data

  5. ODS

  6. ODS diagram

  7. EDW • Analytics and Data Mining (Cognosand Argos) • An EDW is an aggregation of underlying data that may provide strategic analysis to help form business strategies.

  8. EDW – Enterprise Data Warehouse

  9. EDW

  10. ODS/EDW