Versions Compared

Old Version 5

changes.mady.by.user Brian Donnelly

Saved on

compared with

New Version 6

changes.mady.by.user Brian Donnelly

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • According to the Oracle 10G documentation, most of the mviews we are creating are "Materialized Views with Joins Only" and should be eligible for fast refresh. I will be reformulating the mview and view definitions to use rowid based logs and mviews with rowid columns based on information from this page: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/basicmv.htm#i1006803
  • First roadblock: Canonical Courses. We are mapping this data from the SCBCRSE table, which has term information. In order to generalize it to canonical courses, a distinct clause is necessary. Distinct clauses will not work with mviews based on ROWID mview logs, and SCBCRSE doesn't have a primary key. So, in its current formulation, this mview will never fast refresh. That being said, we probably only need to run this mview once a month or so, and it stores less than ten thousand rows.

Progress

  1. Banner Replicant MViews created with re-created Banner indexes.