Actian Blog / Tag / Analytics

Tagged Posts: Analytics

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
Actian VectorH File Format Is Faster And More Efficient
  • July 12, 2016

Actian VectorH 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
Actian VectorH Enables Fuller SQL Functionality And More Current Data
  • July 6, 2016

Actian VectorH Enables Fuller SQL Functionality and More Current Data

In this second of a three-part blog series (part 1), we'll explain how SQL execution in Actian Vector in Hadoop (VectorH) is much more functional and ready to run in an operational environment, and how the ability for VectorH to handle data updates efficiently can enable your production environment to stay current with the…

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
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
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
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 Analystics Platform was clearly the performance leader to meet this customer’s real-time data needs.…

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
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
  • 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
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
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
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
  • 1
  • 2