Actian Blog / Tag / Technical Insights

Tagged Posts: Technical Insights

Connecting To Actian X (Ingres) With PHP And NGINX
  • December 12, 2017

Connecting to Actian X (Ingres) with PHP and NGINX

Not long ago I spoke at the Actian Hybrid Data Conference in London about connecting Actian X (Ingres) to the Web. Today a very popular web server (reverse proxy, load balancing, etc...) on Linux is NGINX. The following are instructions on how to setup NGINX for the Ingres ODBC driver and a generic PHP…

Read More
Performance Testing Production Workloads For Ingres And Vector
  • September 26, 2017

Performance testing production workloads for Ingres and Vector

One of the main concerns of Ingres and Vector customers whose systems need to undergo a significant change, such as major version upgrades, OS migration, major software releases, increased volumes of usage, etc, is how to properly test the database under realistic conditions in a test environment. Some customers have heard of the Query,…

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