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

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

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

• What factors can be used to measure efficiency? (Solved)
  

  What factors can be used to measure efficiency?

  Date posted: July 4, 2018 .    Answers (1)

• State and discuss how the four basic hardware components interact and affect system performance (Solved)
  

  State and discuss how the four basic hardware components interact and affect system performance

  Date posted: July 4, 2018 .    Answers (1)

• How should you distribute data across disks? (Solved)
  

  How should you distribute data across disks?

  Date posted: July 4, 2018 .    Answers (1)

• Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing? (Solved)
  

  Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?

  Date posted: July 4, 2018 .    Answers (1)

• Discuss the advantages of a DDBMS (Solved)
  

  Discuss the advantages of a DDBMS

  Date posted: July 4, 2018 .    Answers (1)

• Discuss the disadvantages of DDBMS (Solved)
  

  Discuss the disadvantages of DDBMS

  Date posted: July 4, 2018 .    Answers (1)

• Describe the expected functionality of a replication server. (Solved)
  

  Describe the expected functionality of a replication server.

  Date posted: July 4, 2018 .    Answers (1)

• Discuss the Update-anywhere (symmetric replication) ownership in replication (Solved)
  

  Discuss the Update-anywhere (symmetric replication) ownership in replication

  Date posted: July 4, 2018 .    Answers (1)

• Discuss the workflow ownership as portrayed in replication (Solved)
  

  Discuss the workflow ownership as portrayed in replication.

  Date posted: July 4, 2018 .    Answers (1)

• Discuss the master/slave type of ownership model in replication (Solved)
  

  Discuss the master/slave type of ownership model in replication

  Date posted: July 4, 2018 .    Answers (1)

• Give a definition of an OODBMS. (Solved)
  

  Give a definition of an OODBMS.

  Date posted: July 4, 2018 .    Answers (1)

• Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse (Solved)
  

  Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse

  Date posted: July 4, 2018 .    Answers (1)

• Describe the characteristics of the data held in a data warehouse. (Solved)
  

  Describe the characteristics of the data held in a data warehouse.

  Date posted: July 4, 2018 .    Answers (1)

• Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships (Solved)
  

  Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships

  Date posted: July 4, 2018 .    Answers (1)

• Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence. (Solved)
  

  Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.

  Date posted: July 4, 2018 .    Answers (1)

• How do the contents of a users’ requirements specification differ from a systems specification? (Solved)
  

  How do the contents of a users’ requirements specification differ from a systems specification?

  Date posted: July 4, 2018 .    Answers (1)

• What is the purpose of the systems definition stage? (Solved)
  

  What is the purpose of the systems definition stage?

  Date posted: July 4, 2018 .    Answers (1)

• Describe how fact-finding is used throughout the stages of the database system development lifecycle (Solved)
  

  Describe how fact-finding is used throughout the stages of the database system development lifecycle

  Date posted: July 4, 2018 .    Answers (1)

• Briefly describe what the process of fact-finding attempts to achieve for a database developer. (Solved)
  

  Briefly describe what the process of fact-finding attempts to achieve for a database developer.

  Date posted: July 4, 2018 .    Answers (1)

• Discuss Redundant Array of Independent Disks (RAID) (Solved)
  

  Discuss Redundant Array of Independent Disks (RAID)

  Date posted: July 4, 2018 .    Answers (1)