DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
A
SEMINAR REPORT
ON
DISTRIBUTED DATABASE
By
MAHESH KUMAR KUMAWAT
Submitted in partial fulfillment for the Award of degree of
Bachelor of Technology
Submitted To:-
Mr. Navin Goyal (Head of Department)
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
A
SEMINAR REPORT
ON
DISTRIBUTED DATABASE
By
MAHESH KUMAR KUMAWAT
Guided by
Mr. MADHUMAY SEN
Assistant Professor
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
PREFACE
This presentation discusses a real‐world approach to applying usability to
A Distrubuted Database. Usability was a primary driver in the selection and
customization of an enterprise database management application. The results
of this testing were a set of usability issues to address in the customization
phase.During this phase, prototype screens were designed to address problems
related to terminology, workflow, navigation, password guidelines and
authentication questions. Usability testing of the prototype led to further
refinement. While this focus on usability led to an improved user interface,
issues of security, and the impact of usability recommendations on security
had to be balanced with ease of use.
A database management is a form of secret manage data that is used to control
access to a resource. Distributed databases in general, and heterogeneous
distributed databases in particular, are of increasing practical importance, as
organizations attempt to integrate databases across physical and organizational
boundaries.
Such interconnection of databases to create a distributed or multidatabase is in
fact proving crucial to competitiveness for many companies. This chapter
reconsiders the issues addressed earlier in the text, such as query processing,
recovery and concurrency control, from the standpoint of distributed
databases.This is a long chapter, and is appropriate only for an advanced
course. Single topics may be chosen for inclusion in an introductory course.
Good choices include distributed data storage, heterogeneity and two-phase
commit.
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
CERTIFICATE
This is to certify that the Seminar entitled “DISTRIBUTED DATABASE”
has been carried out by MAHESH KUMAR KUMAWAT under my guidance
in partial fulfillment of the degree of Bachelor of Technology in Computer
Engineering of Rajasthan Technical University during the academic year
2010-2011. To the best of my knowledge and belief this work has not been
submitted elsewhere for the award of any other degree.
Guide Examiner Head of the Department
Mr. Madhumay Sen Mr. Navin Goyal
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
ACKNOWLEDGEMENT
I express my sincere thanks to Mr. Madhumay Sen,Designation Assistant
Professor, Dept. Computer Science ,
For guiding me right form the inception till the successful completion of the
Seminar. I sincerely acknowledge him for extending their valuable guidance,
support for literature, Critical reviews of training and the report and above all
the moral support he had provided to me with all stages of this Seminar.
Mahesh Kumar Kumawat
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
CONTENTS
S.No. TOPIC NAME Page No.
1 Introduction to Distributed Database
2 Types of Distributed Databases
3 Distributed Database Architecture
3.1 Homogeneous Distributed Database System
3.1.1 Distributed Database Versus Distributed Processing
3.1.2 Distributed Database Versus Replicated Databases
3.2 Heterogeneous Distributed Database System
3.2.1 Hetergeneous Services
3.2.2 Transparency Gateway Agents
3.2.3 Generic Connectivity
3.3 Client/Server Database Architecture
4 Storing Data in a Distributed DBMS
4.1 Fragmentation
4.2 Replication
5 Distributed Database Application Development
5.1 Transparency in a Distributed Database System
5.2 Remote Procedure Calls (RPCs)
5.3 Distributed Query Optimization
6 Form of Distributed Data
7 Distributed DBS Issues
8 Transparency Issues
9. Reorganized Data
10. Distributed Data Independence
11 Introduction to Distributed Transactions
12 Distributed Concurrency Control
12.1 Distributed Deadlock
13 Distributed Recovery
13.1 Normal Execution and Commit Protocols
13.2 Restart after a Failure
13.3 Two-Phase Commit Revisited
13.4 Three-Phase Commit
14 Disadvantages & Advantages of Distributed Database
15 Conclusion
16 References & Bibliography
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
SEMINAR GUIDE INTERACTION REPORT
Phase Interaction Remarks
Topic Decision
Resources search
Compilation of resources
Abridged report
Rough draft
Intermediate draft
Signature
Seminar Guide
DEPARTMENT OF COMPUTER ENGINEERING
Regional College For Engineering Research and Technology- Jaipur
Seminar Session- 2010 - 2011
Seminar Observer’s Report
Name Observations Remarks/Marking (10)
Note: Seminar will be treated as Void in case of non presence of Observer, Guide, HoD
Observers can be Principal sir, Director sir, Dean sir.
