2 - HP Vertica Database Intro Series

HP Vertica is built on a base of four distinctive features

• 1- columnar storage, optimized for access.
• 2- compression.
• 3- Use grouping of the cluster
• 4- Continuous Performance

Columnar Storage for optimized access. Vertica stores like data that is usually consulted for better performance. Storage column is ideal for read-intensive because it can dramatically reduce I/O to disk in comparison to traditional storage per line. Vertica Clumn Storage Compression. Vertica stores more data, provides more views and uses less hardware than other databases. 50-90% are possible compression ratio. Using compression you keep more historical data on physical storage. Vertica can consult compressed data without decompressing it first. Vertica uses several different compression methods and automatically chooses the best for the data being compressed (about compression types in more detail in future articles). Grouping as a cluster You can scale the database cluster easily adding more hardware, and you can improve reliability by distributing and replicating data across your cluster. The data is distributed among the nodes in the cluster, so if a node becomes unavailable, the database continues to work. When a node is added to the cluster, or back online after being available, it will automatically query other nodes to update its local data. Continuous Performance We can load data and simultaneously we can see them, you can real-time access and eliminate the need for nightly load windows.