Distributed DBMS Architecture-Distributive Database System-Lecture Slides, Slides of Distributed Database Management Systems

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

2011/2012

Uploaded on 07/19/2012

cool_bre
cool_bre 🇮🇳

4.3

(4)

27 documents

1 / 57

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
In the name of Allah
docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39

Partial preview of the text

Download Distributed DBMS Architecture-Distributive Database System-Lecture Slides and more Slides Distributed Database Management Systems in PDF only on Docsity!

In the name of Allah

Distributed Database Systems

(CS-5323)

Spring 2012

Lecture 2

22-02-

Dept of CS, MAJU, Ibd

Architecture of a system defines its

structure

Dept of CS, MAJU, Ibd

Sheth, A. P., Larson, J. A.,

‘Federated Database Systems

for Managing Distributed

Heterogeneous, and

Autonomous Databases’, ACM

Computing Surveys, 22, No. 3,

p(183-236), Sep., 90

Dept of CS, MAJU, Ibd

DBMS Standardization

A conceptual framework

to divide standardization

work into manageable

pieces

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

  1. Distribution
  2. Heterogeneity**

Three Dimensions

Dept of CS, MAJU, Ibd

Autonomy

Degree to which member databases

can operate independently