GTU MCA MATERIAL FOR DBMS II

RSS
  • Home
  • Quick Review
  • Assignment
  • Backup and Recovery
  • Differences
  • About Me

Monday, April 18, 2011

Assignment - 5 Introduction to Other Databases


Assignment – 5  Introduction to Other Databases  
Submission Date : 25-04-2011   

Q.1
Explain the Following Questions in detail.

1)
What is Parallel Database System? Why we need it?
2)
Explain Key element of Parallel Database system?
3)
Explain Architecture of parallel Database with advantage and disadvantage?
4)
Explain inter query parallelism and intra query parallelism?
5)
Explain Advantage, disadvantage of Distributed Database System?
6)
Explain Types and Property of Distributed Databases?
7)
Explain Architecture of Distributed Database System?
8)
Explain Two Phase commit?
9)
Explain features, Advantage and Disadvantage of OODBMS?
Q.2
Differentiate the following :

  1. Parallel Database System Vs Distributed Database
  2. Interquery parallelism Vs Intraquery parallelism
  3. Homogeneous DDBS Vs Heterogenous DDBS
  4. Shared Memory multiple CPU Vs Shared Disk multiple CPU
  5. Speed Up Vs Scale Up






Posted by Dr. Parag Shukla at 11:58:00 PM
Email This BlogThis! Share to X Share to Facebook

0 comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

255056

Blog Archive

  • ►  2019 (1)
    • ►  March (1)
  • ►  2016 (7)
    • ►  August (6)
    • ►  July (1)
  • ▼  2011 (16)
    • ►  May (2)
    • ▼  April (6)
      • Basic of Join
      • Relational Algebra
      • Speed Up Vs Scale Up
      • Assignment - 5 Introduction to Other Databases
      • Mid Term Exam Feedback
      • Assignment - 4 Database Security
    • ►  March (5)
    • ►  February (3)
  • ►  2010 (9)
    • ►  May (4)
    • ►  March (5)
  • ►  2009 (1)
    • ►  December (1)

Followers

Blog List

Search

Parag Shukla. Powered by Blogger.

Popular Posts

  • Serial Schedule Vs Non-Serial Schedule
    Serial Schedule Non-Serial Schedule A serial schedule is a sequence of operat...
  • Dirty Read Vs Unrepeatable Read
    Dirty Read Unrepeatable Read A dirty read problem occurs when one transaction updates a ...
  • Log Based Recovery
    Log Based Recovery The most widely used structure for recording database modification is the log. The log is a sequence of log ...
  • Lost Update Vs Uncommitted Data
    Lost Update Uncommitted Data This problem is also known as “Multiple Update...
  • Shadow Paging
    Shadow Paging This technique does not require LOG in single user environment In mult...
  • Starvation Vs Deadlock
    Starvation Deadlock Starvation happens if same transaction is always choosen ...
  • Checkpoints
    Checkpoints When System failure occurs o We must consult log to determine those transaction that need to be redone and those tra...
  • Defferred Update method
    Deferred update Do not physically update the database on disk until after a transaction reaches its commit point; Then updates are r...
  • Assignment - 7 Query Processing & Optimization
    Assignment – 7         Query Processing & optimization    Submission Date 30-05-11   Q-1. Explain th...
  • Immediate Update Method
    Immediate update technique Database may be updated by some operations of a transaction before the transaction reaches its commit poi...
Copyright © 2010 GTU MCA MATERIAL FOR DBMS II