facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
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
Actian’s March Topcoder Challenges
  • March 24, 2018

Actian’s March Topcoder Challenges

Actian is sponsoring three challenges on Topcoder this month, featuring our Vector and Zen database products and thousands of dollars in prizes. All you need to do is sign on to Topcoder (for free), read and follow the instructions for the competition, and win! It's that easy. Now, the challenges themselves are all different,…

Read More
Actian Vector – Community Edition Launches On Azure Marketplace
  • March 20, 2018

Actian Vector – Community Edition Launches on Azure Marketplace

Last November we announced that Actian Vector - Community Edition, our high-performing SQL analytics solution for the cloud, launched for free on the AWS Marketplace. Now we're happy to announce that a similar version has now been released on the Microsoft Azure Marketplace in a similar free-to-use pricing model. If you are a SQL…

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
Making Actian Zen Btrieve API Code More Efficient
  • March 9, 2018

Making Actian Zen Btrieve API Code More Efficient

The release of Service Pack 1 for Zen (PSQL) v13, Actian’s zero-dba, embedded nano-footprint database, provides a number of new features, including one we’re looking at today to make Btrieve API code more efficient -- the GetNextExtended LIKE Support. First, let's review the concept of "Extended Operations." The low-level Btrieve API (also known as the…

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
Integrating Python With Vector Or Actian X
  • January 12, 2018

Integrating Python with Vector or Actian X

Introduction Today we're going to look at how to get started with Actian Vector, our high-performance in-memory analytics database, and Python, one of the most oft-used languages by data scientists in recent times. Using the techniques below, you'll be able to get started with Python using Vector ODBC and JDBC. (You'll be able to use…

Read More
When BIG Data Doesn’t Have To Be
  • January 9, 2018

When BIG Data Doesn’t Have to Be

Using a Vector FARM to Make Big Data Analytics Fast and Easy I’ve been working in the IT industry a long time.   What goes around, comes around.  My favorite example is how centralized mainframe timesharing gave birth to decentralized client-server computing, now we are going back to timesharing, but in the cloud.   Technology does…

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