Wednesday 23 February |
|||
14:00 - 14:55 | Lecture 3 | Advanced Database Features |
Zornitsa
Zaharieva Miguel Anjo |
This lecture will give an overview of what a database offers
to improve the performance of very big databases
(index-organized tables, partitioning, etc.) and certain
features for protecting the data when working in a
multi-user environment in a database. It will also show how
to put more logic into the database layer and make the
database ‘smarter’ by capturing database events through
triggers or adding programming logic to the execution of SQL
commands (PL/SQL functions). The lecture is heavily based on
the Oracle implementation of all these features.
|