Differentiate between horizontal and mixed partitioning, Database Management System

Assignment Help:

Question:

In relation to distributed database answer the following questions:

(i) Give a brief definition of distributed database. Support your answer with an appropriate diagram that shows the major component of the distributed database.

(ii) Differentiate between homogeneous distributed database and heterogeneous database system and explain which one will be appropriate for a company which has been using a database for the past 30 years and who now, wants to implement a distributed database.

(iii) Describe briefly two transparency features that exist in a distributed database environment.

(iv) Differentiate between horizontal partitioning and mixed partitioning with appropriate example.

(v) Briefly describe any three advantages of replication.


Related Discussions:- Differentiate between horizontal and mixed partitioning

Equi-join, explain equi-join using illustration

explain equi-join using illustration

Database, Three way to handle missing field val

Three way to handle missing field val

Write short notes on relational model, Write short notes on relational mode...

Write short notes on relational model   The  relational  model  uses a  collection of  tables  to show  both data  and the relationships between those  data.  The relational mo

Components of database manager, Components of database manager The ab...

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod

State the definition of association, State the definition of association ...

State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

Types of attributes, Attributes attached to an entity can be of various typ...

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

A database administrator'', A database administrator''s responsibilities an...

A database administrator''s responsibilities and data contents

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Get details of employee working on both comp354 and comp345, Consider the r...

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd