Download CS-5323: Distributed Database Systems - Spring 2012 Course Materials and more Slides Distributed Database Management Systems in PDF only on Docsity! In the name of Allah docsity.com Distributed Database Systems (CS-5323) Spring 2012 docsity.com Dept of CS, MAJU, Ibd Components of Course Theoretical Part; mainly from book; You will have to do reading for it mainly Technical Part; Drills from SQL Server; very basic, any expert can create variations Project Part; You will have to do a project using any Distributed technology like CORBA, DCOM, RMI, WS or anything Research Part; You will study papers on the related topic and write a paper that we will try to submit somewhere docsity.com Dept of CS, MAJU, Ibd Topics for research papers Schema Translation Schema Matching Schema Mapping Schema Merging Data Merging/Integration Data Stream Integration docsity.com Dept of CS, MAJU, Ibd Little bit of History Traditional File Processing System docsity.com Dept of CS, MAJU, Ibd Database Approach (Also called centralized database) Database is a shared collection of logically related data docsity.com Dept of CS, MAJU, Ibd Database Data Description Data Manipulation …. PROGRAM 1 PROGRAM 2 PROGRAM 3 Database Approach Takes care of all major drawbacks of File System Environment plus more docsity.com Dept of CS, MAJU, Ibd Distributed Computing System A number of autonomous processing elements that are connected through a computer network and that cooperate in performing their assigned tasks docsity.com Dept of CS, MAJU, Ibd Suits some Organizations Nature of applications Technological Push Why DCS? docsity.com Dept of CS, MAJU, Ibd DCS’s Alerts Information Islands Difficulties in Design Too Many Options. docsity.com Distributed Database System (DDBS) docsity.com Dept of CS, MAJU, Ibd Where to Apply Candidate Applications – Large clientage – Users spread over a large geographical area docsity.com Dept of CS, MAJU, Ibd Example Applications Banking Air Ticketing Business at multiple locations docsity.com Dept of CS, MAJU, Ibd Distributed Database Management System A software system that permits the management of DDB and makes the distribution transparent to the users docsity.com Dept of CS, MAJU, Ibd Distributed Files: A collection of files stored on different computers of a network; not a DDBS docsity.com Dept of CS, MAJU, Ibd DDBS is logically related, common structure among files, and accessed via same interface Multiprocessor System: multiple processors that share some form of memory docsity.com Dept of CS, MAJU, Ibd Processor Unit Processor Unit Processor Unit Memory I/O System Shared Everything Tight Coupling docsity.com Dept of CS, MAJU, Ibd Centralized C/S System docsity.com Dept of CS, MAJU, Ibd Reasons for DDBS Local units want control over data. Consolidate data for integrated decisions Reduce telecom costs. Reduce the risk of telecom failures. docsity.com Dept of CS, MAJU, Ibd Distributed DBMS DBMS 1 DBMS 1 DBMS n • • • • Global User Global User Node 1 Node n Global Schema Local User Local User docsity.com {
*
uo}
ne)
—
=)
_=
4
=
7)
Oo
i)
[o)
~~
jo
0)
<
@
Dept of CS, MAJU, Ibd System View docsity.com Dept of CS, MAJU, Ibd Data Independence Two types, Logical Data Independence and Physical Data Independence Network Transparency Replication Transparency Fragmentation Transparency Promises of DDBS docsity.com Dept of CS, MAJU, Ibd Reliability in DDBS Reliability through Distributed Transactions (in replication) Concurrency Issues (DDBS takes care of consistency in case of distributed transaction) Failure Recovery It also provides Performance Improvement through data localization and query parallelism docsity.com Dept of CS, MAJU, Ibd Complicating Factors In case of Replication Failure Recovery Complexity, Cost, Distribution of Control docsity.com Dept of CS, MAJU, Ibd The Problem Areas Database Design Query Processing Concurrency Control OS Support Heterogeneity Fig shows relationship docsity.com