

















































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This lecture was delivered by Prof. Mriganka Rao for Distributive Database System at Anna University of Technology. It includes: Distributed, Database, Systems, , DBMS, Architecture, Structure, Heterogeneous, Autonomous, Peer, Client, Server
Typology: Slides
1 / 57
This page cannot be seen from the preview
Don't miss anything!


















































Lecture 2
22-02-
Dept of CS, MAJU, Ibd
Architecture of a system defines its
structure
Dept of CS, MAJU, Ibd
Dept of CS, MAJU, Ibd
Dept of CS, MAJU, Ibd
Component-based
Function-based
Data-based
Dept of CS, MAJU, Ibd
A committee for the task established
in 1972 by ANSI under SPARC
Published standard in 1977
Dept of CS, MAJU, Ibd Reference Model Internal View Conceptual View External View External View External View Internal Schema Conceptual Schema External Schema Users
Dept of CS, MAJU, Ibd
Enterprise Administrator
Application Programmer
Conceptual Database schema Processor
Database Administrator
Internal Database schema Processor
External Database schema Processor
Internal storage/ Internal database transformation
Conceptual/ External database Transformation
Internal Database Application Program
External database Application program
Application System Administrator
Application/ System Administrator
Internal database/ Conceptual transformation
Dept of CS, MAJU, Ibd
Hexagons are admin roles
Arrows indicate data, command,
execution flow
I represent Interfaces
Dept of CS, MAJU, Ibd
DB Administrator
Enterprise Admin
Application Administrator
May be same person
Dept of CS, MAJU, Ibd
That concludes our discussion on
Reference DBMS Architecture.
Dept of CS, MAJU, Ibd
**1. Autonomy
Three Dimensions
Dept of CS, MAJU, Ibd
Autonomy
Degree to which member databases
can operate independently