Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

Vertical partitioning#

Sumit Rawal answered on February 3, 2023 Popularity 6/10 Helpfulness 2/10

Contents


More Related Answers

  • disk partition
  • Why do we need partitioning?
  • Horizontal partitioning#
  • Data Partitioning: Horizontal, Vertical and Functional Data Partitioning
  • What is vertical partitioning, also known as columnar partitioning ?
  • Why do we need partitioning?

  • Vertical partitioning#

    0

    Vertical partitioning involves splitting a table into multiple tables with fewer columns and using additional tables to store columns that relate rows across tables. We commonly refer to this as a join operation. We can then store these different tables in different nodes.

    Normalization is one way to perform vertical partitioning. However, general vertical partitioning goes far beyond that: it splits a column, even when they are normalized. 

    Popularity 6/10 Helpfulness 2/10 Language whatever
    Source: Grepper
    Tags: whatever
    Link to this answer
    Share Copy Link
    Contributed on Jun 24 2023
    Sumit Rawal
    0 Answers  Avg Quality 2/10

    Closely Related Answers



    0

    ▪ Vertical partitioning is a "Row Splitting".

    ▪ Each partition holds a subset of the columns for table in the database.

    ▪ The data divided based on columns and we can divide by mostly visited columns and the other columns in different servers.

    ▪ Frequently accessed columns can be use in one vertical partition and less frequently accessed fields in another.

    ▪ Example case: Facebook, the user profile data can be in different partition and user mostly visited data can be different server.

    ▪ Benefit of Vertical Partitioning is you can separate the critical and mostly visited columns in a separate server.

    ▪ Best practice: Divide by rarely-changes and frequentlychange columns into different servers. 

    https://blog.bytebytego.com/p/vertical-partitioning-vs-horizontal

    Popularity 7/10 Helpfulness 2/10 Language whatever
    Source: Grepper
    Link to this answer
    Share Copy Link
    Contributed on Feb 03 2023
    Pragya Keshap
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.