Actian Blog / Tag / Analytics

Tagged Posts: Analytics

The  Top 10 Benefits Of An Operational Data Warehouse For 2021
  • August 1, 2021

The Top 10 Benefits of an Operational Data Warehouse For 2021

The previous blogs in this series discussed the top 5 pitfalls of traditional operational data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution.  Below is a list of my Top 10 desirable benefits of an effective ODW: Current. Continuous data updates via “micro-batches” or streamed singleton updates throughout the day…

Read More
Eight Reasons Why Avalanche Is 8X Faster Than Snowflake
  • October 28, 2020

Eight Reasons Why Avalanche is 8X Faster Than Snowflake

This month, 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 Avalanche. There are many intriguing results included in the report, but an indisputable conclusion was reached by GigaOm: "In a…

Read More
Why The AA, A Leading UK Insurer, Selected Actian Avalanche For High-Performance Cloud Analytics
  • October 27, 2020

Why The AA, a Leading UK Insurer, Selected Actian Avalanche for High-Performance Cloud Analytics

We are very excited to share the news that The Automobile Association (AA), the UK's largest motoring organization, selected Actian Avalanche hybrid cloud warehouse 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,…

Read More
A Two-Part Approach To Track & Trace In Urban And Suburban Settings
  • September 25, 2020

A Two-Part Approach to Track & Trace in Urban and Suburban Settings

As businesses work to reopen and students return, in-person, to schools nationwide, track and trace is a critical component to mitigate potential resurgences in COVID-19 cases. The more densely populated a city, the harder track and trace will be. However, getting urban and suburban areas moving again is critical to jumpstarting the US economy.…

Read More
Actian Vector For Hadoop File Format Is Faster And More Efficient
  • June 5, 2020

Actian Vector for Hadoop File Format is Faster and More Efficient

In this third and last part of the series on Actian Vector in Hadoop (VectorH), we will cover how the VectorH file format supports the performance and efficiency of our data analytics platform to accelerate business insights, as well as some of the other enterprise features that can help businesses move their Hadoop applications…

Read More
Exploiting Analytics In The Cloud Without Moving All Your Data There
  • July 29, 2019

Exploiting Analytics in the Cloud Without Moving All Your Data There

Your company has competing data needs. You need IT systems optimized for real-time transaction processing to serve as the engine for digitally transformed business processes. You also need your data aggregated and optimized for analytics to generate both real-time insights and perform deep data-mining activities. It can be difficult to balance these competing needs…

Read More
Insights At The Speed Of Business
  • December 19, 2018

Insights at the Speed of Business

Modern businesses move fast and the speed of business is accelerating every day with no sign of slowing. To survive, companies must find ways to remove friction in their systems and business processes – leveraging real-time operational data and translating it into actionable insights that drive activities across the company. From strategic decision-making to…

Read More
What’s New In Actian DataFlow Version 6.6.1?
  • November 26, 2018

What’s new in Actian DataFlow version 6.6.1?

Actian DataFlow is a parallel workflow platform for end-to-end data access, transformation, preparation, and predictive analysis that eliminates performance bottlenecks in your data-intensive applications.  Complementary to the Actian Vector analytic database, DataFlow leverages concurrency, parallelism and pipelining to accelerate data movement between locations in your data architecture, creating faster results.  DataFlow eliminates memory constraints,…

Read More
New Improvements To Security And Performance In Actian Vector
  • June 12, 2018

New Improvements to Security and Performance in Actian Vector

We are pleased to announce the availability of Actian Vector 5.1.  This release includes enhancements across the product, but the primary focus is with security, performance, and new customer enablement. This post provides an overview of some features added to this release. Security With the advent of GDPR we’ve seen heightened focus on security.…

Read More
Vector Enterprise Edition Now Available On AWS Marketplace
  • May 8, 2018

Vector Enterprise Edition Now Available on AWS Marketplace

Last week we activated Actian Vector Enterprise Edition on the AWS Marketplace, so now it’s easier to tap into the fastest analytic engine in the cloud to extract insights from your big data. We can prove that claim based on independent benchmarks by MCG that you can view here comparing Vector performance to results…

Read More
How Actian Vector Helps You Eliminate OLAP Cubes
  • April 16, 2018

How Actian Vector Helps You Eliminate OLAP Cubes

OLAP (OnLine Analytical Processing) Cubes are used extensively today, because it is impossible for many database platforms to analyze large volumes of data quickly. This is because most database software does not fully leverage computing power and memory to deliver optimal performance. Some of the symptoms of this are: Large queries end up hogging…

Read More
See Actian At The Gartner Data & Analytics Summit In London
  • March 17, 2018

See Actian at the Gartner Data & Analytics Summit in London

Are you in London, England and attending the Gartner Data & Analytics Summit? Why not drop by and see Actian at Booth #S4 where you can discuss the latest and greatest in databases, hybrid data, analytics, Internet of Things, and software innovation at the InterContinental London - The O2 from Sunday, March 18 through…

Read More
Jolt Your Performance With Actian In Detroit And Cambridge This Week
  • March 12, 2018

Jolt Your Performance with Actian in Detroit and Cambridge This Week

Interested in jolting your data analytics and database performance? Join Actian in two separate meetings this week in both Detroit, Michigan and Cambridge Massachusetts to talk about hybrid data, performance, analytics, and dataintegration: Tuesday, March 13: Come to the JOLT YOUR PERFORMANCE BREAKFAST between 7:30–9am at the award winning Apparatus Room Restaurant conveniently located…

Read More
Get Ready For The Gartner Data & Analytics Summit 2018 In Grapevine, Texas
  • February 26, 2018

Get Ready for the Gartner Data & Analytics Summit 2018 in Grapevine, Texas

The next big data and analytics conference is right around the corner with the Gartner Data & Analytics Summit, hosted at the Gaylord Texan Resort Hotel & Convention Center in Grapevine, Texas from March 5-8, 2018 and Actian will be present, both on the show floor and in a presentation. Emma McGrattan, SVP, Engineering, will…

Read More
Automatically Synchronize Your OLTP And OLAP Tables In Actian X (Ingres 11)
  • February 9, 2018

Automatically Synchronize Your OLTP and OLAP Tables in Actian X (Ingres 11)

A key feature of the latest update to our hybrid database Actian X (Ingres 11) is the inclusion of the x100 analytics engine and support for x100 tables. Adding a world class analytics engine to Actian X’s enterprise OLTP (OnLine Transaction Processing) capability enables a new class of applications that can mix OLTP and analytic…

Read More
Fast. Faster. Fastest.
  • December 22, 2017

Fast. Faster. Fastest.

I was fortunate enough to attend the Actian Hybrid Data Conference at which Craig Strong, who is Chief Technology and Product Officer at Hubble, talked about how they provide real-time corporate performance management (CPM) though high-speed analytics dashboards. You can watch a video recording of this presentation on the conference sessions page linked here. For…

Read More
How I Analyzed 165 Million Flight Records In Seconds On My Laptop
  • December 19, 2017

How I analyzed 165 million flight records in seconds on my laptop

It was surprisingly easy to analyze 165 million flight records my laptop. It took me just an afternoon following the Actian Evaluation guide that you can download from here. Scientists with Intel over the years to being down the cost of high performance computing. They key vector processing technology feature they needed was to…

Read More
Database History In The Making:  Ingres Meets X100
  • December 19, 2017

Database History in the Making: Ingres Meets X100

Doug Inkster is an Actian Fellow with a long history in the database market, starting with IDMS in the 1970’s and moving to Ingres in the 1990’s.  We asked him to reminisce about the most exciting times in his long career.  Here are some of his thoughts: In my 40+ years of working with…

Read More
Insight To Insights
  • November 28, 2017

Insight to Insights

A fellow recent hire at Actian, Walter Maguire, told me that many organizations get frustrated with having to wait into the late morning for decision support databases to be loaded and indexed or OLAP cubes to be populated with transactional data before sales analysis can be performed. This is not a new problem. I…

Read More
Delivering Real-Time Reporting At Speed And Scale
  • September 21, 2017

Delivering Real-Time Reporting at Speed and Scale

When a major UK logistics company wanted to improve reporting for its large accounts, they turned to Actian to design, implement and support the underlying database system (“LARS”) using Ingres, HVR and Vector products for its architecture. The Brief The customer had around 100 Customer Accounts Representatives dedicated to large accounts, with each Rep…

Read More
Vector In Hadoop 5.0 – New Features You Should Care About
  • September 19, 2017

Vector in Hadoop 5.0 – New Features You Should Care About

Today we announce the introduction of the next release of Actian Vector in Hadoop, extending our support of Apache Spark to include direct access to native Hadoop file formats and tighter integration with Spark SQL and Spark R applications. In this release, we also incorporate performance improvements, integration with Hadoop security frameworks, and administrative…

Read More
Predictions For The Hybrid Data Landscape
  • May 30, 2017

Predictions for the hybrid data landscape

The Age of Data has arrived, with new data sources, targets and processing models proliferating madly across enterprises of all sizes. While data has never been more valuable to a business — it now informs the who, what, where, when and how of decision making — this new hybrid data landscape introduces new challenges.…

Read More
Hadoop Short Circuit Reads And Database Performance
  • August 2, 2016

Hadoop Short Circuit Reads and Database Performance

If you've been working with Hadoop then you've likely come across the concept of Short Circuit Reads (SCRs) and how they can aid performance. These days they are mostly enabled by default (although not in "vanilla" Apache or close derivatives like Amazon EMR). Actian VectorH brings high performance SQL, ACID compliance, and enterprise security…

Read More
Performance Troubleshooting Tips For Actian Vector In Hadoop
  • June 20, 2016

Performance Troubleshooting Tips for Actian Vector in Hadoop

Actian Vector and Vector in Hadoop are powerful tools for running queries efficiently. However, most users of data analytics platforms seek to find ways to optimize performance to gain incremental query improvements. The Actian Service and Support team works with our customers to identify common areas that should be investigated when trying to improve…

Read More
Fashion Retailer Maximizes Profits Through Data Driven Insights
  • May 26, 2016

Fashion Retailer Maximizes Profits Through Data Driven Insights

Kiabi, a global retailer of ready-to-wear fashion at affordable prices based in France needed to replace a legacy data management platform that was unable to support real-time analytics in a high-volume global retail environment. A proof of concept test demonstrated that the Actian Analytics Platform was clearly the performance leader to meet this customer’s real-time data…

Read More
Accelerating Spark With Actian Vector In Hadoop
  • May 9, 2016

Accelerating Spark with Actian Vector in Hadoop

One of the hottest projects in the Apache Hadoop community is Spark, and we at Actian are pleased to announce a Spark-Vector connector for the Actian Vector in Hadoop platform (VectorH) that links the two together. VectorH provides the fastest and most complete SQL in Hadoop solution, and connecting to Spark opens up interfaces…

Read More
  • May 3, 2016

Amazon EMR as an Easy-to-set-up Hadoop Platform

Recently I helped a customer perform an evaluation of Actian Vector in Hadoop (VectorH) to see if it could maintain “a few seconds” performance as the data sizes grew from one to tens of billions of rows (which it did, but that’s not the subject of this entry). The customer in question was only…

Read More
Taking Advantage Of Ordered Data
  • May 2, 2016

Taking Advantage of Ordered Data

Actian Vector and Vector in Hadoop (VectorH) have a lightweight, but very potent, feature that can give a significant performance boost when querying data that possesses some kind of ordering. This entry takes a look at this feature and describes how to use it. The feature utilises what are referred to as MinMax structures.…

Read More
  • April 28, 2016

Actian Developer Tools available on Github

The Actian technology teams have recently posted a number of technical tools and snippets to the Actian account on Github that will be of interest to customers, partners and prospects. We encourage all of you to take a look and make contributions of your own – either to enhance these tools, or else to…

Read More
Hadoop At 10
  • April 27, 2016

Hadoop at 10

Wow – 10 years of Hadoop, what a ride. Actian has been working in the Hadoop ecosystem almost since the beginning, starting in 2007. Actian started working with Hortonworks the moment they launched in 2011. As a pioneer in this space, we have witnessed the whole “boom”. And while Hadoop is continuing to show…

Read More
Analytics Cube And Beyond
  • April 14, 2016

Analytics Cube and Beyond

Big Data engineering has invented a seemingly endless supply of workaround solutions.  These are for both scalability and performance problems.  Ultimately, our approach to solving these problems dictates how sustainable they will be.  This post compares some modern best practices with pre-processing cube environments.  3 Ways A Hadoop Database Competes With Cube Analytics Software…

Read More
The Evolution Of Data Integration With The Internet Of Things
  • August 4, 2014

The Evolution of Data Integration with the Internet of Things

Loraine Lawson, always does a wonderful job covering the world of integration, and this article that covers the integration challenges and opportunities of the Internet of Things (IoT) is no exception. Besides big data, I see the IoT as one of the most interesting data integration challenges coming down the road. Perhaps it’s time…

Read More
Embedded Integration: Put The Analytics Compute Where The Data Lies.
  • January 28, 2020

Embedded Integration: Put the Analytics Compute Where the Data Lies.

Selecting the best location for your analytics compute poses an interesting dilemma leading to thoughtful debate in some companies while others don't even consider the topic. If you're dealing with distributed systems, embedded sensors in machinery, mobile apps, or IoT devices, this topic is for you! Where you locate compute resources for analytics has…

Read More
Does It Make Sense To Push All Your IoT Data To The Cloud?
  • August 19, 2019

Does It Make Sense to Push All Your IoT Data to the Cloud?

IoT devices create plenty of data – much more that you might think. When you multiply this amount of data by the number of devices installed in your company’s IT ecosystem, it is apparent IoT is a truly big data challenge. Two common questions IT staff and data management professionals have been asking during…

Read More
See Actian At TDWI Las Vegas, February 12-14, 2018
  • February 12, 2018

See Actian at TDWI Las Vegas, February 12-14, 2018

Starting off the new year in style by hitting Las Vegas and attending the annual TDWI Conference focused on big data and analytics? Come see Actian at on the exhibit hall floor, Booth #205, Forum Ballroom of Caesar's Palace, at these times: Tuesday, February 13: 11:15am - 2:15pm and 5:00pm-7:00pm (Leadership Summit reception in…

Read More
High-Performance Realtime-Analytics On Hadoop Data
  • December 27, 2017

High-Performance Realtime-Analytics on Hadoop Data

The Challenge I have spent many years working with Actian's customers on database solutions and thought it'd be useful to discuss a recent customer experience at a large media company (I will call it "XYZCo"). This experience is similar to what I continue to see with other customers and the lessons learned apply to…

Read More
The Big Show: Visit Actian At AWS Re:Invent 2017 In Las Vegas
  • November 27, 2017

The Big Show: Visit Actian at AWS re:Invent 2017 in Las Vegas

The largest cloud computing conference of 2017 is now here in AWS re:Invent and it’s taking over Las Vegas in a big way. An estimated 40,000 engineers, product leads, marketers, technical architects, and expert users from around the world will be descending on The Strip, attending keynotes, bootcamps, demos, hackathons, and in-depth hands-on training…

Read More
Efficient ETL In An Analytical Database?
  • June 27, 2016

Efficient ETL in an Analytical Database?

Recently I worked on a POC that required some non-standard thinking. The challenge was that the customer's use case did not only need high performance SQL analytics but also a healthy amount of ETL (Extract, Transform, and Load). More specifically, the requirement was for ELT (or even ETLT if we want to absolutely precise).…

Read More
Actian Vector Extends Dominance As Certifiably Fastest!
  • June 13, 2016

Actian Vector Extends Dominance as Certifiably Fastest!

Actian announced a new record TPC-H result with Hewlett Packard Enterprise and Intel to demonstrate the big data analytics performance of the new Intel Xeon processor E7-8890 v4.  With over 2.14M QphH and $0.38/QphH, Actian Vector sets new records for performance and price/performance on non-clustered systems for the 3000GB scale factor.  These numbers beat…

Read More
Pssst .. Have You Heard About VectorH?
  • May 4, 2016

Pssst .. Have you heard about VectorH?

Hello World! We’ve been busy building some innovative features into the Actian Vector in Hadoop (VectorH) product and we would love to tell you all about them. So, the list of the features and innovations that we have done recently for VectorH… wait .. do you even know what VectorH is about? Yes, it’s…

Read More
An Analytical Mind: A Smart Interview With Peter Boncz On Vector Processing
  • September 5, 2014

An Analytical Mind: A Smart Interview with Peter Boncz on Vector Processing

Known as the Father of Vector Database Processing, Peter Boncz is the Senior Research Scientist at Centrum Wiskunde & Informatica (CWI), Professor at VU University Amsterdam, and Chief Technical Advisor to Actian Corporation, the first company to assemble an end-to-end big data analytics platform that runs natively on Hadoop. He architected two breakthrough database…

Read More
Emergence Of The Chief Data Officer Caffeinates Data Integration
  • July 14, 2014

Emergence of the Chief Data Officer Caffeinates Data Integration

We often watch new positions sprout up around emerging technology.  These days, we see new titles such as the chief cloud officer, and other titles that seem just as trendy.  However, the strategic use of data within many enterprises led those in charge to assign data management responsibility to one person; the chief data…

Read More
facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo