PPT Slide

Other OR-Related Features

• Support for large objects
  • Multimedia data types aren't small (e.g., video)
  • Special handling required for efficiency
    • Minimal copying, piecewise retrieval, optional logging, movement to/from files, separate storage area from other attributes
  • DB2 has blob, clob, and dbclob types (up to 2GB)

• Support for active data (triggers and constraints)
  • Ex:

create trigger me_too

after insert on IBM_Emps

referencing new as newemp

foreach row mode db2sql

when salary > department->manager->salary

begin atomic

set newemp.department->manager->salary

= newemp.salary;

end

Previous slide

Next slide

Back to first slide

View graphic version