Database - Distributed Databases - Discussion

Discussion :: Distributed Databases - General Questions (Q.No.6)

6. 

Some of the columns of a relation are at different sites is which of the following?

[A]. Data Replication
[B]. Horizontal Partitioning
[C]. Vertical Partitioning
[D]. Horizontal and Vertical Partitioning

Answer: Option C

Explanation:

No answer description available for this question.

Rutuja said: (Jul 9, 2012)  
What is vertical & horizontal Partitioning ?

Jagdeep Mankotia said: (Apr 26, 2013)  
Partitioning a database improves performance and simplifies maintenance. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. Maintenance tasks, such as rebuilding indexes or backing up a table, can run more quickly.

Jagdeep Mankotia said: (Apr 26, 2013)  
Partitioning a database improves performance and simplifies maintenance. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. Maintenance tasks, such as rebuilding indexes or backing up a table, can run more quickly.

Horizontal partitioning divides a table into multiple tables. Each table then contains the same number of columns, but fewer rows.

Vertical partitioning divides a table into multiple tables that contain fewer columns.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.