Data Platform

Why Actian Data Platform is 8X Faster Than Snowflake

Emma McGrattan

October 28, 2020

Actian Avalanche is 8x faster than Snowflake

GigaOm published a comprehensive evaluation of leading cloud data warehouse services based on performance and cost. Offerings analyzed included Snowflake, Amazon Redshift, Microsoft Azure Synapse, Google BigQuery, and our very own Actian Data Platform.

There are many intriguing results included in the report, but an indisputable conclusion was reached by GigaOm: “In a representative set of corporate-complex queries from TPC-H standard, Actian Data Platform consistently outperformed the competition.”

To put “outperformed” in more concrete terms, Actian Data Platform was 8.5X faster than Snowflake in a test of 5 concurrent users. In terms of price performance, the advantage over Snowflake was 6.4X.

gigaom chart price performance

Actian Data Platform Was Built for Performance Out-of-the-Box

So what’s the secret behind Actian Data Platform’s superior performance? There is a simple, fundamental explanation. Actian Data Platform was built from the ground up to deliver unrivaled performance on commodity infrastructure. Its original design goal was to makes the most of every CPU clock cycle, every byte of memory, and every I/O operation. And ensuring high performance continues to be a priority for us. Our efficient design is the reason why, even with the limitless resources of the cloud, you won’t see your costs ballooning as you increase concurrent users or data volume.

How specifically does Actian Data Platform deliver best-in-class analytics performance without the need for tuning? It is a combination of the following eight factors. Vendors such as Snowflake may offer a few of the capabilities listed such as Vector processing, but the unique combination creates a powerful compounding effect:

  1. Optimizing the Use of Microprocessor Cores to run multiple data operations in parallel during a single CPU cycle. This is known as Vector processing. Traditional scalar architectures typically consume myriad more CPU cycles to compute the same calculations, which impacts overall throughput.
  2. Taking Full Advantage of Multi-Core CPUs – Actian Data Platform can perform Vector processing across all available cores, which maximizes concurrency, parallelism, and system resource utilization.
  3. Processing Data Using the CPU’s On-Chip Cache is faster and closer to where operations are performed and therefore optimizes performance. Our competitors tend to use DRAM for query execution cache, which is far slower.
  4. Using Advanced Compression – Typically With a 5:1 Compression Ratio – Actian Data Platform’s compression algorithms are designed for maximum efficiency, particularly in decompression, yet still deliver about a 5:1 compression ratio. Compression is handled automatically, so no tuning is required.
  5. Optimizing I/O – Actian Data Platform is a pure columnar implementation. The data lives its life in columnar format, which results in I/O efficiency.
  6. Using Patented Technology to Maintain Indexes Automatically so that an indexing strategy is not necessary.
  7. MPP Architecture parallelizes query execution within and across nodes to power through business workloads regardless of size and complexity.
  8. Real-Time Updates that enable operational insights with zero performance penalty enabled by Actian Data Platform’s patented positional delta trees.

All this adds up to blazing-fast analytics performance that results in faster iterations on data models, quicker root cause analysis, and ultimately enabling a data-driven organization.

When Cost is More Important Than Performance

If you’re satisfied with the current performance of your data warehouse, Actian Data Platform can deliver that same level of performance while enabling you to dial back your spend on compute resources—which can immediately translate into considerable cost savings. Conversely, if you can benefit from increased performance, Actian Data Platform can give you much more at a much lower cost. In other words, you have two levers to play with – price and performance – and Actian Data Platform enables you to achieve the lowest cost of ownership for the level of performance your business demands.

emma mcgrattan blog

About Emma McGrattan

Emma McGrattan is CTO at Actian, leading global R&D in high-performance analytics, data management, and integration. With over two decades at Actian, Emma holds multiple patents in data technologies and has been instrumental in driving innovation for mission-critical applications. She is a recognized authority, frequently speaking at industry conferences like Strata Data, and she's published technical papers on modern analytics. In her Actian blog posts, Emma tackles performance optimization, hybrid cloud architectures, and advanced analytics strategies. Explore her top articles to unlock data-driven success.
Data Intelligence

What is Data Literacy? Tips on Becoming Data Literate.

Actian Corporation

October 28, 2020

data-literacy-definition

Data literacy has been a trending topic for a few years, and it is known that it is a vital skill for enterprises seeking to fully transform their organizations and become data-driven.

As technology can be a point of failure if not handled properly, it is often not the most important roadblock to progress. In fact, in Gartner’s annual Chief Data Officer survey, the top roadblocks for success were cultural factors – human, skills, and data literacy. 

However, many of these enterprises still struggle to understand what data literacy truly is, or know how to reshape their cultural organization into a data literate one.

In its 2020 survey, New Vantage Partners observed that:

“Companies continue to focus on the supply side for data and technology, instead of increasing demand for them by business executives and employees. It’s a technology push rather than a pull from humans who want to make more data-based decisions, develop more intelligent business processes, or embed data and analytics into more products and services.”

In this article, we’d like to shed light on what data literacy is, why it is important for your enterprise, and tips on how to become a data-literate organization.  

The Definition of Data Literacy

Just as literacy means to have “the ability to read for knowledge, write coherently and think critically about printed material,” data literacy is the ability to consume for knowledge, produce coherently, and think critically about data.

In 2019, Gartner defined data literacy as: “the ability to read, write, and communicate data in context, including an understanding of data sources and constructs, analytical methods and techniques applied, and the ability to describe the use case, application, and resulting value.”

So, based on these definitions, we can conclude that data literate people can, among other things:

  • Make analyses using data.
  • Use data to communicate ideas for new services, products, workflows or even strategies.
  • Understand dashboards (visualizations for example).
  • Make data-based decisions rather than based on intuition.

In summary, being data literate signifies having the set of skills to be able to effectively use data individually and collaboratively. 

Why is Data Literacy Important?

Gartner expects that, by 2020, 80% of organizations will initiate deliberate competency development in the field of data literacy to overcome extreme deficiencies. By 2020, 50% of organizations will lack sufficient AI and data literacy skills to achieve business value.

The increasing volume and variety of data that businesses are flooded with on a daily basis require employees to employ higher order skills such as critical thinking, problem-solving, computational, and analytical thinking using data. And as organizations become more data-driven, poor data literacy will become an inhibitor to growth. In fact, in their survey “The Human Impact of Data Literacy”, Accenture found that:

  • 75% of employees are uncomfortable when working with data.
  • 1/3 of employees have taken a sick day from work due to headaches working with data.
  • A lack of data literacy costs employers 5 days of productivity translating to billions of dollars in lost productivity per employee each year.

Furthermore, a Deloitte survey conducted in 2019 found that 67% of executives are not comfortable accessing or using data resources.

Data uplifts the success of organizations in creating both physical and digital business opportunities—improving accuracy, increasing efficiency and augmenting the ability of the workforce to deliver greater value. It is therefore important and essential to be able to interpret, analyze and communicate findings on data to be able to uncover the secrets to successful business and competitive advantage. 

How to Become Data Literate

In order to build a successful data literacy program, here are some tips to help your organization on your data fluency journey:

Develop a Data Literacy Vision and Associated Goals

Any organization investing in data and AI capabilities should have already undertaken the creation of a data vision and  roadmap. In the process of doing so, data and IT leaders will have identified and prioritized the areas of business where data can produce value.

These steps are critical to creating a data-literate organization and reducing the friction around understanding and using data.

Management and HR need to communicate across the entire enterprise that data is a strategic asset that creates value. Using the data vision and roadmap as context, they should be able to explain to all employees why data matters, how it creates value, and how it impacts the business.

The absence of a clear vision for data and a plan to create value out of it, will create frustration and, as a consequence, employees will lack understanding of why they are being asked to make efforts and therefore, not have the motivation to do so.

In addition, a data literacy vision should detail desirable skills, abilities, and the level of literacy required for different business units and roles.

Business, IT, and HR leaders need to create a framework to achieve literacy goals, measure progress, and create a way to maintain data literacy.  This includes deciding what skills are required, how to measure & track skills development, and to what degree different parts of the organization should use data in achieving their strategic objectives.

Assess Workforce Skills

Data literacy skills should ideally be assessed during the recruitment process for new hires.  In this way, HR will already know what kind of data literacy learning should be offered to the new hire over time.

However, for already existing employees, HR can map current employee data skills based on the roles and responsibilities provided in the above steps, and determine where there are gaps.

Create Data Literacy Modules

According to Qlik, only 34% of firms provide data literacy training.

In most cases, the HR department is responsible for helping business managers identify and track areas of improvement and development opportunities for employees. They are also in charge of organizing the procedures for learning specific organizational skills as well as the time it takes. It’s no different when it comes to becoming data literate.

Once HR and managers have a general idea of an employee’s or a business unit’s strengths and weaknesses in data skills, HR can begin to construct personalized and efficient learning programs that allow employees to upskill in data and analytics responsibilities.

Track, Measure, and Repeat

A successful data literacy program takes time to put in place. Business leaders must allow their employees to invest the time required to become data literate and improve their skills.  Over time, data thinking will become part of the corporate culture.

Finally, it’s important to communicate data literacy progress across the enterprise and on an individual basis. Tracking and communicating on the progress is key to continuing the evaluation of your organization’s data roadmap, vision and literacy.

This type of long-term planning and investment in educating the entire organization about how to access, understand and analyze data on the job will accelerate the efforts and investment that data science, machine learning and AI teams are making.

The results of data literacy efforts will allow organizations to finally be able to embrace and leverage data across the enterprise and for maximum value.

actian avatar logo

About Actian Corporation

Actian empowers enterprises to confidently manage and govern data at scale. Actian data intelligence solutions help streamline complex data environments and accelerate the delivery of AI-ready data. Designed to be flexible, Actian solutions integrate seamlessly and perform reliably across on-premises, cloud, and hybrid environments. Learn more about Actian, the data division of HCLSoftware, at actian.com.
Data Platform

Why The AA, a Leading UK Insurer, Selected Actian

Actian Corporation

October 27, 2020

car showing how uk insurer selected actian for analytics

We are very excited to share the news that The Automobile Association (AA), the UK’s largest motoring organization, selected the Actian Data Platform for its insurance business to execute its cloud migration strategy.

The AA is a leading UK automobile insurer and breakdown service provider that provides vehicle insurance, driving lessons, breakdown coverage, loans, and other services to its thousands of customers every day.

When the AA first sought a cloud data warehouse service to power its analytics, high on its list of priorities were fast performance, scalability, and pay-as-you-go subscription pricing. We were confident that Actian would be a great fit for the AA’s needs because of Actian’s long heritage in analyzing operational data in real-time. This capability would be vital to enabling the AA to provide customized service to its members.

Known for technological innovation, the AA also realized that insurance is a dynamic business that must welcome the flexibility to meet its customers’ needs today and in the future. Actian’s hybrid architecture and multi-cloud support will give the AA a choice in how and where they deploy. With Actian, the AA gains application portability between cloud and on-premises data warehouses.

Actian provides:

  • High-performance analytic database technology on-prem and in the cloud.
  • Cloud economics with pay-as-you-go pricing.
  • Multi-cloud platform support and enterprise-grade security.
  • The ability to scale compute on demand.

The AA’s selection comes on the heels of an authoritative report from GigaOm research, a respected independent industry analyst firm, that identified Actian as the clear industry leader on price and performance in an evaluation of leading cloud data warehouse services such as Snowflake and Amazon Redshift.

The AA will be able to process its data science workloads at lightning speed, giving it a definite competitive advantage. Actian is in the business of helping organizations attain industry leadership by using data to their advantage—and we are excited to add the AA to the list.

actian avatar logo

About Actian Corporation

Actian empowers enterprises to confidently manage and govern data at scale. Actian data intelligence solutions help streamline complex data environments and accelerate the delivery of AI-ready data. Designed to be flexible, Actian solutions integrate seamlessly and perform reliably across on-premises, cloud, and hybrid environments. Learn more about Actian, the data division of HCLSoftware, at actian.com.