|
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.
-
Creating a table from a table
-
Creating an index-organized tables
-
Other indexes (bitmap, function based, reverse,
multi-column)
-
Using partitioned tables
-
By what authority – users and privileges
-
Views
-
Materialized views
-
Accessing Remote Data - synonyms, db links
-
Introduction to PL/SQL
-
Triggers
-
PL/SQL procedures, functions and packages
|
