Database systems

Overview Database DB Management system Uses Logical structures (data models) Hierarchical Network Relational Object Issues DB v's conventional Data independence Integrity Centralised DBMS Distributed DBMS Security Logical controls Division of responsibility Access (Firewall) Contingency planning Logical controls Physical controls Client server Compression Connectivity Middleware Performance (Client/server | Oracle) Recovery Replication Resource management Year 2000 NZ Top 20 IT companies Dataprocessing (Transaction) Activities Audit (Overview | DB) Backup & archiving Maintenance Support (DB administrator) Schema/sub-schema definition Data manipulation SQL Overview Select ( Select .. From..Where..Group | Order, Functions | Joins) End user query Information systems Decision support systems 4Gl's in a DBMS Examples Oracle Exercise Student record

[Rev 25/04/00] 30/5/97 © 1997-98 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.