Data Analytics

Insight to Insights

Actian Corporation

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 remember when I worked for British Telecom, our biggest worry was to complete the overnight batch updates to our mainframe CA-IDMS database, so we could start the IBM CICS transaction processing service, allowing employees to accept bill payments and check balances.

In the retail business, knowing how products are sold is critical. In the days before in-store POS systems sent daily updates to HQ, I worked at Coppernob, which owned 126 Top Shop stores. Every Saturday night, couriers collected Kimble tags containing bar codes that we scanned on Sunday to create reports showing sales across the UK. The Ingres database would index the sales tables to work out what designs were hot that week.

Today, fashion retailers such as Kiabi use Actian Vector to analyze sales data, applying predictive analytics on markdowns to improve marketing campaigns. Now they can track marketing offers to select the most productive markdowns. Kiabi uses Actian Vector to speed up the time it takes to gain insights. The chart below shows the performance difference they saw when comparing using their Oracle RDMS directly versus using Vector:

Kiabi’s performance test of Actian Vector query acceleration compared to standard Oracle

Having the ability to bypass the bulk update and indexing process gives organizations more time to gain more insights.

About Actian Corporation

Actian is helping businesses build a bridge to a data-defined future. We’re doing this by delivering scalable cloud technologies while protecting customers’ investments in existing platforms. Our patented technology has enabled us to maintain a 10-20X performance edge against competitors large and small in the mission-critical data management market. The most data-intensive enterprises in financial services, retail, telecommunications, media, healthcare and manufacturing trust Actian to solve their toughest data challenges.