Data Base Architecture

Слайд 2

CONTENTS ANSI/SPARC architecture Conceptual level External level Internal level Mappings Data base management system

CONTENTS

ANSI/SPARC architecture
Conceptual level
External level
Internal level
Mappings
Data

base management system
Слайд 3

Different Meaning of «architecture» Functional architecture Software architecture Hardware architecture Network architecture Implementation architecture Information architecture

Different Meaning of «architecture»

Functional architecture
Software architecture
Hardware architecture
Network

architecture
Implementation architecture
Information architecture
Слайд 4

Architecture ANSI/X3/SPARC ANSI/X3/SPARC – Study Group on Data Base Management Systems

Architecture ANSI/X3/SPARC

ANSI/X3/SPARC – Study Group on Data Base Management Systems

Areas of DB technology standardization
Only DB interfaces may be standardized
Interfaces ?DB architecture
Слайд 5

Слайд 6

Conceptual Level A uniform basis of understanding of AD Includes only

Conceptual Level

A uniform basis of understanding of AD
Includes only conceptually

relevant aspects
Feature of allowed evolution of DB
Basis of mappings external-intenral levels
Supports the data independance
Supports centralized administration
Stability
Слайд 7

External Level Convinient data representation Promotes logical independance Promotes data safety problem Supports different external interfaces

External Level

Convinient data representation
Promotes logical independance
Promotes data safety

problem
Supports different external interfaces
Слайд 8

Internal Level Provides DB adjustments Supports data storage structures and access

Internal Level

Provides DB adjustments
Supports data storage structures and

access methods
DB efficiency, prformance, redundancy
Physical data independance
Promotes data safety problem
Mapping internal schema to the OS data structures
Слайд 9

Mappings External-conceptual Conceptual-internal and vise-versa

Mappings

External-conceptual
Conceptual-internal
and vise-versa