applications in SQL do not need to be rewritten to run on parallel server (all parallelizations of SQL programs are carried out by the server), compared to scientific areas where both parallel application algorithms and a parallel compiler are required
|
data-independent --- two-phase database schema (logical and physical database)
|
SQL in Oracle 7
-
create tables in the database
-
store information in tables
-
select exactly the information you need from your database
-
make changes to your data and the structure of underlying tables, and
-
combine and calculate data to generate the information you need
|