Embed analytics in applications to transform your technology business

At AWS re:Invent in Las Vegas, I’ve had several conversations with developers who’ve stopped by the booth. One of the questions I’ve asked them all is, “Are you embedding analytics into your application?”
Vertica Data Analytics and Business Trends

Survey says businesses are implementing predictive analytics, but not without challenges

  To discover today’s cloud and data analytics trends across North-Western Europe, Vertica has surveyed 120 data experts from industry-leading organizations. This infographic provides insights into how businesses leverage data analytics and what challenges they face when implementing predictive analytics, artificial intelligence, and machine learning capabilities. What are the top analytics projects organizations have been...
Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

Do you love Vertica and want to let us know, or want to provide some constructive criticism? Well, now you can easily do that. Starting in Vertica 10.1.x, Management Console added a new Feedback Button which lets you submit a star rating and free-text comments to Vertica. The button displays vertically at the bottom-right of...
Helpful Tips in blue text with magnifying glass

Quick Tip: Determining Database “Cell” Count

The Vertica system tables LICENSE_AUDITS and USER_AUDITS include a mysterious column called CELL_COUNT. What exactly is the Cell Count? It's simply a calculation that looks like this: DATABASE CELL_COUNT = (Table_1 Column Count * Table_1 Row Count) + (Table_2 Column Count * Table_2 Row Count) + … + (Table_n Column Count * Table_n Row Count)...

The Climate Corporation awarded for outstanding AI/ML: We’re all winners with sustainable agriculture

The Climate Corporation, a subsidiary of Bayer, aims to help all the world’s farmers sustainably increase their productivity with digital tools. The Climate FieldView™ platform provides farmers with a comprehensive, connected suite of digital tools aimed at mitigating risk and optimizing farm productivity. As Vertica’s customer references manager, I gather stories around what our users...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Taking the pulse of cloud adoption trends: The Flexera “State of the Cloud” report

Before I joined Vertica, I worked in the cloud services world, first for a reseller and then for a Cloud Services Provider (CSP). During my time in this space I followed cloud adoption trends closely by necessity, and one of my favorite sources of data on the subject was RightScale’s (now Flexera’s)  “State of the...

Partners Showcase Solutions at Vertica Unify ’21

Registrations for Vertica Unify ’21 are rapidly climbing as we anticipate thousands of data experts to convene for the analytics event of the year. Vertica customers have long adopted a "best tool for the job" approach – and that goes beyond choosing Vertica to accelerate analytics and machine learning at scale. Success often requires our...

Vertica-as-a-Service: Advanced analytics just got a little easier

Anytime business software can provide greater ease-of-use, it leads to better business outcomes at a faster pace. What could be better than that? How about analytics-as-a-service, built on a cloud-native architecture running in your AWS account, and leveraging your own negotiated pricing and committed spend? Add the full suite of advanced analytics, in-database machine learning,...

Explore Popular Topics

SQL

Quick Tip: WITH Clause Recursion

Starting with version 10.1.x, Vertica supports recursive queries. These are incredibly useful in modeling and working with self-referential hierarchical data. Let's take a look at a natural instance of this form of data: the manager-subordinate relationship. The following table contains employees (EMP_NAME), their IDs (EMP_ID), and the IDs of their managers (EMP_MGR_ID). For example, the...
Vintage businessman concept wearing futuristic helmet at office

Quick Tip: Combine SQL and vsql Meta-commands on the vsql Command Line

When using vsql, the -c (--command) flag lets you pass a single statement to vsql as a string and then exits. Examples: While you can't combine a SQL statement with a vsql meta-command... ...You can use echo to combine and pipe SQL statements and vsql meta-functions to vsql! Have Fun!

EMA Awards Vertica as Top Vendor for Hyperperformance with Multi-Structured Data in Radar Report on Unified Analytics Warehouses

If you could describe in just one word what Vertica provides better than any other unified analytics platform on the market, what would that word be? Read any of our case studies, watch any of our Data Disruptor Webcasts, or attend Vertica Unify ’21, and, chances are, you’ll agree that that one word is performance....

Kubernetes StatefulSets Makes Containerization of Vertica a Piece of Cake

Containerization is an idea that seems tasty and wonderful at first. Automated deployment on any platform is a particularly enticing advantage, especially for Vertica, a database with infrastructure freedom as a core principle. Fast deployment without human intervention makes containers incredibly useful, especially in environments that require dynamic scaling. And containers are small, quick to...

New Forrester Total Economic Impact Study: Vertica customers achieve big results

Predictive analytics is becoming an imperative for nearly every organization that hopes to increase market share. Modern data analytics techniques provide insights into where a business is heading, based partly on where it has been, and on the clear trend lines that point to where the business is going. So, if you’re an entrepreneur, or...
Business card that says Expert Tips,

Quick Tip: Create User-Defined Inverse Hyperbolic Functions

Vertica includes a ton of built-in mathematical functions to help you on your analytic journey, and creating new ones is quick and easy. Let's create the inverse hyperbolic functions: ACOSH - To compute the inverse (arc) hyperbolic cosine of its argument. ASINH - To compute the inverse (arc) hyperbolic sine of its argument. ATANH -...