Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer

      

Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer

  

Answers


KELVIN
1)Horizontal partitioning Distributing the records of a table across a number of (smaller) tables.
2)Vertical partitioning Distributing the columns of a table across a number of (smaller) tables (the primary key is duplicated to allow the original table to be reconstructed).
Partitions are particularly useful in applications that store and analyze large amounts of data. For example, let’s suppose there are hundreds of thousands of records in the VideoForRent table that are held indefinitely for analysis purposes. Searching for a particular record at a branch could be quite time consuming, however, we could reduce this time by horizontally partitioning the table, with one partition for each branch.
There may also be circumstances where we frequently examine particular columns of a very large table and it may be appropriate to vertically partition the table into those columns that are frequently accessed together and another vertical partition for the remaining columns (with the primary key replicated in each partition to allow the original table to be reconstructed).


kalvinspartan answered the question on July 4, 2018 at 17:04


Next: What factors can be used to measure efficiency?
Previous: Explain the meaning of denormalization.

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions