Database Systems

DBS lecture 1

ANSI/SPARC Architecture

?

DBMS

Database Management System

1 of 8

Database

Collection of informtation

2 of 8

Relational Systems

Information is stored as tuples or records in relations or tables

3 of 8

ANSI/SPARC Architecture

Three level architecture:

  • Internal Level
  • Conceptual Level
  • External Level
4 of 8

Internal Level (ANSI/SPARC Architecture)

  • Deals with the physical storage of data
  • Used by database programmers
5 of 8

Conceptual Level (ANSI/SPARC Architecture)

  • Deals with the organisation of the data as a whole
  • Used by DBAs and application programmers
6 of 8

External Level (ANSI/SPARC Architecture)

  • Provides a view of the database tailored to a user
  • Used by end users and application programmers
7 of 8

Mappings (ANSI/SPARC Architecture)

  • Translate information from one level to the next
  • Provide data independance
    • Physical data independence
    • Logical data independence
8 of 8

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »