Database Systems DBS lecture 1 ANSI/SPARC Architecture 2.0 / 5 based on 1 rating ? ComputingOtherAll boards Created by: Samantha BinghamCreated on: 04-05-09 12:10 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
Computing Standard Grade - Unit 1 Computer Applications - General Purpose Packages 4.0 / 5 based on 1 rating
Comments
No comments have yet been made