Close

Why Vertica?

EssentialNET has teamed up with Vertica because it is, simply put, the best database and data analytics solution on the market with a whole raft of advanced features which we believe bring significant advantages to our customers and prospective customers.

EssentialNET has an exceptional track record of bringing the best business technology to the UK and Vertica is right up there with the best of them.

Vertica is designed for use in data warehouses and other big data workloads where speed, scalability, simplicity, and openness are crucial to the success of analytics. With Vertica Enterprise Edition software, you get high-performance data analytics for all of your data to make better business decisions in real time. Packed with powerful features for harnessing the value from all your data, Vertica Enterprise Edition manages massive amounts of data quickly and reliably, giving you real-time insight for advanced, Big Data analytics.

Key Highlights
As part of the Vertica Analytics Platform, you can perform queries 50 to 1,000 times faster than with traditional databases, at a fraction of the cost and using a fraction of the hardware. Unlike traditional RDBMS databases, which are not designed for analytics and today’s complex analytics workloads, the Vertica Analytics Platform is built from the ground up to deliver breakneck performance on Exabyte volumes at nearly infinite scale.
Key Features and Benefits
Columnar Storage and Execution
By eliminating costly disk I/O associated with traditional row-oriented SQL databases, you can perform queries 50 to 1,000 times faster.1 And you can store 10x–30x more data per server than traditional databases with patented columnar compression.2
“Scale-Out” Massively Parallel Processing (MPP)
Scale your solution as much as you need by adding an unlimited number of industry-standard servers and storage to your analytics environment.
Extensible In-Database Analytics Framework
Achieve open access to in-database processing through a robust development framework for procedural, user-defined analytics. In addition to using built-in SQL analytic and aggregate functions, you can define your own custom functions by using a software developers’ kit (SDK). The SDK features secure sandboxing, and resulting functions run in parallel for fast performance.
In-Database Analytics Library
Vertica provides a number of machine learning functions for performing in-database analysis. Out-of-the-box, in-database analytics include event-series pattern matching, event-series joins, clustering, linear regression, geospatial support, advanced time series, and more. You also get open source analytics libraries, including thousands of packages from CRAN (Comprehensive R Archive Network).
Native Support for Hadoop, Kafka, and More
Vertica Enterprise Edition includes application programming interfaces (APIs) for user-defined aggregates, analytics, and multi-phase transform functions. These dynamically integrate with Apache Hadoop, Apache Kafka, and MapReduce, so that you can analyze large sets of structured, semi-structured, and unstructured data in real time.

Automatic High Availability
Run non-stop with data replication, failover, and recovery. Vertica Enterprise Edition is optimized for performance and is transparent to your integration and operations teams.
Optimized System and Performance Management
Management Console displays tuning recommendations from the Workload Analyzer tool, addressing a wide range of system concerns, including empty administrator passwords, high CPU usage, and recommendations for better
data management.
Broad Deployment and Consumption Models—All Based on the Same Vertica Core
Available on-premises, in the Cloud, or on Hadoop, Vertica offers proven Big Data analytics that can deliver unmatched speed and scale. Depending on the situation, if you need extra capacity and have no time to stand up
on-premises hardware, deploying Vertica in the Cloud is an attractive option. For organizations that prefer to apply a sophisticated SQL query
engine to their growing data lakes, Vertica for SQL on Apache Hadoop is another popular Vertica consumption model.

To find out more please get in touch with us vertica@essential-net.com.

Leave a Reply

Your email address will not be published. Required fields are marked *

four × four =