Data Partition - Vertical partitioning

Data System Architecture

Table pruning though a view

  • Create two tables with a column primary key
  • Create a view joining this two tables through this key
  • Selecting only columns of one tables must select only one table (pruning the second one).

Reference





Discover More
Data System Architecture
Data Partition - Horizontal

Horizontal partitions cuts the data by row. Vertical partition Partition is what enable parallelism. Do not under partition - Partitioning on columns with only a few values can cause few partitions...
Data System Architecture
Data Partitions (Clustering of data)

A partition cut out the storage in several part according to a predicate. You can have two types of partition : horizontal (sharding) (related to a cutting by row) vertical (related to a cutting...
Cost Genome Sequencing Vs Moore Laws
Data Science - Big Data

Big Data describes data defined in terms of the 3Vs: volume, (A lot, Internet-scale data set.) velocity, (Quick) and variety. (In a lot of structure) Doug Laney of Gartner originally defined the...
Columnar Physical Table Representation
Database - Column (Storage|Store)

Storing data in columns is functionally similar to having a built-in index for each column. This data structure is used in analytics and NoSql database. Columnar storage is a popular data structure in...
Bi Server Architecture With Client
OBIEE - Fact-based vertical partitioning/fragmentation

This technique allow you to : mix two facts table with two different grains (the level based partitioning) perform a densification (to preserve dimension value) : partition vertically your fact...



Share this page:
Follow us:
Task Runner