Actian Vector Data Ingestion
  • July 11, 2018

Actian Vector Data Ingestion

The usefulness of an analytic database is closely tied to its ability to ingest, store, and process vast quantities of data. Data is typically ingested from multiple sources such as operational databases, CSV files, and continuous data streams. In most cases, daily data loads are measured in tens or hundreds of millions of rows,…

Read More
Deploying Actian OpenROAD Applications With Loadnrun
  • May 1, 2018

Deploying Actian OpenROAD Applications with Loadnrun

One of the main challenges for an application developer is the deployment of applications. There are many ways this is handled, from using traditional installers to web-based deployments. The initial web deployment option for OpenROAD, Actian's rapid application development and flexible deployment solution, was the eClient where the application itself was hosted on a web…

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
Ingres (Actian X) Disaster Recovery
  • March 29, 2018

Ingres (Actian X) Disaster Recovery

Most production Ingres (now called Actian X) installations have a need for some degree of disaster recovery (DR).  Options range from shipping nightly database checkpoints to off-site storage locations to near real-time replication to a dedicated off-site DR site.    Ingres, Actian's enterprise hybrid database, ships with built in checkpoint and journal shipping features which…

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
Python And Btrieve 2 On Windows: Accessing Actian Zen Data With No SQL
  • February 2, 2018

Python and Btrieve 2 on Windows: Accessing Actian Zen Data With No SQL

In my previous blog ("Programming the Easy Way: Accessing a PSQL Zen Database with Python and ODBC"), I showed how to easily access an Actian Zen database with Python and ODBC.  My next project was to use the new Btrieve 2 feature with Python to directly interface with the data files without using any…

Read More
Simplifying Development With OpenROAD JSON-RPC
  • January 17, 2018

Simplifying Development with OpenROAD JSON-RPC

With the release of the new patches at the end of December for version 6.2, Actian OpenROAD (our rapid application development and flexible deployment solution) is providing a new functionality in the form of JSON support and JSON-RPC support for OpenROAD Server. Those familiar with OpenROAD would know that an application server was available from version…

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
Reusable Templates And Macros For Actian’s Hybrid Integration Manager
  • November 3, 2017

Reusable templates and macros for Actian’s Hybrid Integration Manager

It's a pretty exciting time to be a User Experience Designer here at Actian! We are working on some great new features for Hybrid Integration Manager and I wanted to share with you two features that really promote reusability. Reusability is a reoccurring theme that we have heard from you, our customers, that we…

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
  • 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
facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo