Oracle Specifics: Misc

• ETL

• • Merge Statements
  • • ROCK for doing UPSERTs in the database.
  • Sequences for Surrogate IDs.

• REDO

• • Lots of REDO during batch load.
  • Hardly ANY REDO during data access.

• Oracle Streams

• • Next generation message based Delta communication.
  • Log Miner ++.
  • Allows the warehouse to get a complete view of the Oracle source.

• Availability / Backup

• • Can USUALLY take cold backups (10pm at night).
  • Has less stringent availability then OLTP databases.