What is different in Vertica

Column storage

• Vertica stores data tables as sections of columns of data rather than as rows of data.
• Is ideal for read-intensive(read-optimized database arch) workloads because it can dramatically reduce disk I/O.

Compression/Encoding.

• We can store more data, provides more views, and uses less hardware then row-bases RDBMS.
• Uses over a dozen encoding and compression algorithms.
• Vertica queries data in encoded form.
• We will talk more about encoding types in the future tutorials.

Clustering.

• Vertica can be easily scaled out by only adding more hardware. When adding a new node Vertica will query all the existing node and populate the new node with the existing data.

Continuous performance.

Queries and loads data 24x7. Load windows are not needed in Vertica.

• Automatic data replication, fail-over, and recovery provided for active redundancy, which increases performance. Nodes recover automatically by querying the system(cluster).