Basic HTML version of Foils prepared 7 October 97

Foil 36 Features of Structure Query Language (SQL)

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou
1 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
2 data-independent --- two-phase database schema (logical and physical database)
3 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
in Table To:

© on Mon Oct 13 1997