Get lightning fast access to your data!

Vertica

specs

Are you interested to find out how you can use Vertica to get valuable insights from your data?
Contact us to find out how we can help!

Hpe-vertica.png

Relational databases have been doing a great job for the last half century to retrieve and store data in  CRUD (Create, Read, Update, Delete) operations.
However, in analytical scenarios, the relational, row based architecture doesn't work anymore. Analytical requests, which consist of a relatively limited number of huge select queries, simply don't work against the relational architecture, which was designed to handle large amount of CRUD operations typically found in application (OLTP) databases. 

Column oriented or analytical databases like Vertica were developed with analytical workloads in mind. The data is stored in a columnar (as opposed to row) oriented architecture and use compression to reduce physical disk operations. Because of this columnar architecture and compression, there no longer is a need for indexes, partitioning and other time consuming tasks. Performance comes by design. 

Vertica is the industry's most advanced analytical database. It can be used on premise, in the cloud or on Hadoop. Vertica can be scaled up (bigger machine) or scaled out (more machines) through clustering, so you'll always be able to query even the largest data sets in no time.

On top of the pure SQL analytical functions, Vertica included embedded R from the early releases.
With Vertica 8, machine learning is more accessible and intuitive to use than ever before, allowing data science directly from the database.

Vertica is used by Facebook on a (at the start) +/- 300 node, 6PB+ cluster ( case).
The 2012 Obama election campaign used Vertica to store and analyse voter behaviour ( case). 

Are you interested to find out how you can use Vertica to get valuable insights from your data? 
Contact us to find out how we can help!

customer cases