Projections in HP-Vertica:
When we create tables in the database management system the table would not be stored as it is in the physical disk. But the tables would be stored using the concept of projections in the HP-Vertica. Projections are way in which the tables are stored physically on the disk. Projections are created only when we initially load the data into the table and just when the table is created.
Projections can be created manually or by using the database designer (DBD) provided by HP-Vertica.
Consider the table consisting of the 3 columns as shown below:
When the projections are created on the initial load of the data the projections in particular node in the cluster would look as shown below:
In HP-Vertica columnar storage of the data occurs, hence the various columns are distributed as projections on the node of a cluster.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Eventual vs Strong Consistency in Distributed Databases
- Difference between Open Source Database and Commercial Database
- Difference between MapR platform and Cloudera platform
- Difference between Cypress and Selenium
- Differences between Cassandra and Elasticsearch
- Overview of Apache Spark
- Difference between Traditional Data Center and Software Defined Data Center
- Constraints on Generalization
- Difference between Shared Lock and Exclusive Lock
- Difference between POM and PageFactory
- Difference between Selenium Webdriver and Protractor
- Difference between Puppeteer and Protractor
- Transaction Management
- The Multistage Algorithm in Data Analytics
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.