facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
Does FHIR Fully Address Healthcare Data Interoperability Silo Challenges?
  • December 9, 2021

Does FHIR Fully Address Healthcare Data Interoperability Silo Challenges?

Let's face it, information withholding is common in many industries, but it’s been especially rampant in the healthcare space.  Payers and Providers have avoided scrutiny for the cost of care delivered and the reimbursements they were collecting.  Consequently, information blocking has become one of the key impediments in shifting from a fee-for-service (FFS) model…

Read More
Developing Your Data DNA
  • November 29, 2021

Developing your Data DNA

In a world where everything is changing too quickly, the evolution towards agile, interoperable data services is a welcome change. Data is now able to be delivered as a service, without the need for costly investments in data centers and the resources needed to manage them. As more companies embrace the cloud, data integration…

Read More
Bloor Spotlight Highlights How Actian’s Ingres NeXt Strategy Avoids Common Modernization Pitfalls
  • November 22, 2021

Bloor Spotlight Highlights How Actian’s Ingres NeXt Strategy Avoids Common Modernization Pitfalls

Digital transformation requires use of the latest technologies. However, as you probably already know, modernizing a mission-critical database and the applications that interact with it can be risky and expensive, often turning into a long disruptive journey. But I have good news! According to a recent Bloor Spotlight report, Actian’s Ingres NeXt strategy for modernizing Ingres and OpenROAD applications either…

Read More
Affinity Analytics Using Actian Avalanche Cloud Data Warehouse
  • October 29, 2021

Affinity Analytics using Actian Avalanche Cloud Data Warehouse

Affinity analytics is the practice of finding relationships and patterns in data.   Businesses can use the results from affinity analytics for many positive impacts.   Here are just two examples from real customer use cases.  First, in retail, management wants to know what products typically sell well together for product placement and advertising purposes. This…

Read More
What Is An Enterprise Data Hub?
  • October 25, 2021

What is an Enterprise Data Hub?

When managing big data, organizations will find that there will be many consumers of the vast amounts of data, ranging from applications and data repositories to humans via various analytics and reporting tools. After all, the data is an expression of the enterprise, and with digital transformation, that enterprise is increasingly expressed in the…

Read More
DataOps: How To Turn Data Into Actionable Insights
  • September 30, 2021

DataOps: How to Turn Data into Actionable Insights

Enterprises‌ ‌have‌ ‌struggled‌ ‌to‌ ‌collaborate‌ ‌well ‌around‌ ‌their‌ ‌data, which can impact everything from digital transformation to advanced concepts like AI and ML.‌ ‌DataOps is not without challenges; building, managing, and scaling data pipelines requires careful thought around reusability, portability across infrastructure and applications, and long term maintenance and governance. And these are just…

Read More
Customer Analytics: How To Measure A Customer’s Journey
  • September 25, 2021

Customer Analytics: How to Measure a Customer’s Journey

Customer Analytics Overview: A true 360-degree view of a customer can’t be sourced exclusively from internal data let alone from a single system or department. Organizations trying to correlate customer interactions, transaction history, and behaviors to improve customer acquisition ROI and retention struggle to aggregate and analyze data and signals across operational, social engagement, customer…

Read More
What’s New In Zen V15: Easily Tracking Data Changes
  • September 22, 2021

What’s New in Zen V15: Easily Tracking Data Changes

Data maintenance is an ongoing requirement in every database environment. Archiving historic data, synchronizing data after off-line access, or auditing changed data are all issues that typically require customized programming.  Most of these solutions often need database design changes or time-consuming processes to complete these tasks.  With the release of Zen v15, there is…

Read More
Hybrid Data Conference Recap And Highlights
  • June 17, 2021

Hybrid Data Conference Recap and Highlights

That's a Wrap! Wow! What a wonderful time we had at the 2021 Hybrid Data Conference! Over the course of two days, we showcased amazing demos, customer stories and technology advancements across the Actian portfolio. For those in attendance, we hope you enjoyed the event and opportunity to see a few of the ways…

Read More
Getting To Know Actian CEO Lewis Black
  • April 7, 2021

Getting to Know Actian CEO Lewis Black

Lewis Black joined Actian in November 2018 as CFO, moving into the CEO position this past fall. He's worked in tech for more than three decades for an assortment of leading telecommunications and software companies, including AT&T, Lucent, Avaya, Citrix, Nexmo, and Vonage. As Lewis closes in on his six-month anniversary as CEO, we…

Read More
What Is The Difference Between A Data Analytics Hub And A Lakehouse?
  • March 25, 2021

What is the Difference Between a Data Analytics Hub and a Lakehouse?

In the opening installment of this blog series—Data Lakes, Data Warehouses and Data Hubs: Do we need another choice? I explore why simply migrating these on-prem data integration, management, and analytics platforms to the Cloud does not fully address modern data analytics needs. In comparing these three platforms, it becomes clear that all of…

Read More
Are Real-Time Analytics In Supply Chain Management Important?
  • February 22, 2021

Are Real-Time Analytics in Supply Chain Management Important?

Processing data in real-time Every organization processes data in many ways. For example, batch data process still exists for heavy data-process workloads, such as payroll. Many of these data processing requirements are executed by batch scheduling software; however, there is a growing need for data processing to be more automated and processed in real-time.…

Read More
Data Lakes, Data Warehouses And Data Hubs – Do We Need Another Choice?
  • February 17, 2021

Data Lakes, Data Warehouses and Data Hubs – Do we need another choice?

Data Lakes, Data Warehouses, and Data Hubs - Do we need another choice? There’s a long-standing debate, dating back to the early days of Hadoop, about what kind of data repository is best for a given data analytics use case. A Data Lake? A Data Hub? A Data Warehouse? Despite Hadoop’s fall from grace,…

Read More
Building A Cohesive Data Management Strategy For Supply Chain Visibility
  • February 10, 2021

Building a Cohesive Data Management Strategy for Supply Chain Visibility

Business strategy A business strategy consists of setting goals, objectives, and priorities for the business vision and mission. The strategy owners use their portfolios of assets, services, and products to achieve the business's goals. A business will often have multiple strategies, such as having a digital strategy that supports their service or product strategy.…

Read More
The Best Cloud Data Strategy For Value
  • January 29, 2021

The Best Cloud Data Strategy for Value

Which cloud makes sense? Nothing is perfect, but we want to approach perfection with continuous improvement and the management of risk in our business environments. IT capabilities and resources underpin our business environments. On-premise capabilities and cloud capabilities have to deliver a return on investment (ROI) for our efforts and, at the same time,…

Read More
From Data Management To Decision Making For Empowerment
  • January 28, 2021

From Data Management to Decision Making for Empowerment

Everyone in an organization makes decisions every day. They go through the process of identifying that a decision needs to be made, then gather data and relevant information from various sources to identify the choices that they can make. By Analyzing the data and other considerations based on their experience, they can make a…

Read More
Data Analytics Is A Core Element Creating Business Value
  • January 22, 2021

Data Analytics is a Core Element Creating Business Value

Valued assets Organizational assets are defined as capabilities and resources. To be valued strategic assets, they have to contribute to the success of the organization. There is no business value contributed to an asset that does not have an understood return on investment (ROI) for the organization. Capabilities can be defined as the ability,…

Read More
Leveraging IoT And Industry Data For Managing Experiences And Decisions
  • January 12, 2021

Leveraging IoT and Industry Data for Managing Experiences and Decisions

Leveraging data Data is everywhere. Data comes from social interactions, personal devices, cloud service interactions, the environment, and many other places and things. There is a wide variety of data and a significant volume of data being collected every second. The velocity and quality of data are increasing every minute. Big data can be…

Read More
Embracing Customer Profiling And Data Management
  • December 11, 2020

Embracing Customer Profiling and Data Management

Defining good service All organizations want to provide good service to their customers. There are many definitions of what good service is from a giving and receiving perspective. Good and excellent service can mean the same thing in many cases. Then there is exceptional service; this is the type of service many organizations try…

Read More
Speedier Interactions With Actian Zen From Node.js
  • October 15, 2020

Speedier Interactions with Actian Zen from Node.js

Make faster calls using the high-speed Btrieve 2 API Developers building real-time, data-intensive Edge applications are increasingly turning to Node.js. It’s not in itself a programming language but an open-source, multi-platform, run-time environment that leverages JavaScript and its ecosystem — and turns out to be quite well suited for today’s data streaming and JSON…

Read More
What Is A Modern Data Platform?
  • October 9, 2020

What is a modern data platform?

What is a modern data platform?  When we ask this question, we get two different groups of answers.  The first group is around the technology needed for data processing in today's business environment.  In this group, the answers mention things like cloud services, containers, and on-prem.  The second set of answers involves sources of…

Read More
A Two-Part Approach To Track & Trace In Urban And Suburban Settings
  • September 25, 2020

A Two-Part Approach to Track & Trace in Urban and Suburban Settings

As businesses work to reopen and students return, in-person, to schools nationwide, track and trace is a critical component to mitigate potential resurgences in COVID-19 cases. The more densely populated a city, the harder track and trace will be. However, getting urban and suburban areas moving again is critical to jumpstarting the US economy.…

Read More
SQLite: Not Faster, Not Better, But Cheaper?
  • July 2, 2020

SQLite: Not Faster, Not Better, But Cheaper?

Understanding SQLite’s Total Cost of Ownership (TCO) Over the past three months this blog series has explored why developers gravitated toward SQLite for embedded data management. Some developers chose SQLite because members of the extended team knew SQL and wanted to leverage that knowledge to support data management or the extraction of data for…

Read More
SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well
  • June 17, 2020

SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well

Part Three: SQLite, the “Flat File” of Databases Over the past few articles, our SQLite Blog series has been looking at SQLite Serverless Architecture and how it is unsuitable for IoT Environments. Those of you who have been following can jump ahead to the next section, but if you’re new to this discussion, you…

Read More
SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two
  • June 11, 2020

SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two

Part Two: Rethinking What Client-Server Means for Edge Data Management Over the past few weeks our SQLite Blog series has considered the performance deficiencies of SQLite when handling local persistent data and looked at the performance complications created by the need for ETL when sharing SQLite data with back-end databases. In our last installment—Mobile…

Read More
SQLite Equals ETL Heavy
  • May 18, 2020

SQLite Equals ETL Heavy

Two weeks ago, I likened the performance of SQLite to that of a Banana Slug. Now, some may consider that a bit of hyperbole (and some UC Santa Cruz alumni may feel that I impugned the good name of their mascot, which was not my intent) but the numbers don’t lie. The measurable difference…

Read More
SQLite – The Banana Slug Of Embedded Databases
  • April 29, 2020

SQLite – the Banana Slug of Embedded Databases

Earlier this month, I kicked off a series of blogs about SQLite. The first looked at the advantages that SQLite offers over both flat files and the heavier lift of an enterprise-grade SQL databases – and it does offer distinct advantages over both. To a point. And that point was five years ago. Here's…

Read More
Robotic Process Automation Is Hot – Integration Is Not!
  • February 24, 2020

Robotic Process Automation is Hot – Integration is Not!

Robotic process automation (or RPA for short) is the term used to describe the next generation of technology-enabled workflow management capabilities.  RPA solutions come in various sizes and shapes from a myriad of different vendors. RPA is the current buzzword and has enormous growth opportunity but integration is complex and requires expensive skills and…

Read More
An Embedded Software Developers Flat File Migration Check List
  • January 24, 2020

An Embedded Software Developers Flat File Migration Check List

This is the final installment on the series of blogs I wrote on the continued use of flat files and why they are no longer viable for use in the future. The first installment focused on flat files and why embedded software application developers readily adopted them.  Then in the second installment, I discussed why embedded…

Read More
Actian Partner Showcase – Goldstar Software
  • January 2, 2020

Actian Partner Showcase – Goldstar Software

Each month, we are featuring a different partner in our Actian Partner Showcase series. In January, the spotlight shines at Goldstar Software Inc., our long term US Actian Zen distributor. Goldstar Software were awarded 2018 Best Data Management Partner, U.S. and Worldwide. Tell us about Goldstar Software? Goldstar Software Inc. specializes in everything related…

Read More
The California Consumer Privacy Act Is Upon Us. Who Is Ready?
  • December 31, 2019

The California Consumer Privacy Act is upon us. Who is ready?

Officially passed by the Governor of California, Jerry Brown, and the California State Legislature on June 28, 2018, the California Consumer Privacy Act aims to enhance privacy rights and consumer protection for California residents. Finally arriving, the bill will become effective on Jan. 1, 2020. With the CCPA on the immediate horizon, technology companies…

Read More
It’s Back To The Future For Flat Files … Part Three
  • November 25, 2019

It’s Back to the Future for Flat Files … Part Three

Why embedded software application developers should dump flat files before they have to run dump on them I wrote an initial blog a few weeks ago on flat files and why embedded software application developers readily adopted them.  Then in the next blog, I covered why embedded developers are reluctant to use databases.  In…

Read More
It’s Back To The Future For Flat Files … Part Two
  • November 11, 2019

It’s Back to the Future for Flat Files … Part Two

Why Embedded Software Application Developers Loath Databases Last week I wrote an initial blog on flat files and why embedded software application developers readily adopted them.  Simply put, they’re always there – if you’ve got an Operating System that’s more than a bare-bones executive kernel it’s there and it’s free.  Also, flat files are…

Read More
It’s Back To The Future For Flat Files … Part One
  • November 6, 2019

It’s Back to the Future for Flat Files … Part One

Why embedded software application developers adopted flat files Recently, my colleague here in Actian Product Marketing, Pradeep Bhanot, wrote a great blog on Data Historians in which he called for their retirement in favor of more modern databases to support time-series data processing and analytics.  But, in some ways, historians are not as historic…

Read More
Your Dreams Are Our Dreams
  • October 3, 2019

Your Dreams Are Our Dreams

I recently had the privilege of presenting at Insight Technology’s db tech showcase in Tokyo. The night before my presentation my colleagues and I had been invited to a meal with one of our partners. At the end of the meal, one of my colleagues was thanking our hosts for a wonderful meal and…

Read More
Actian Datacast: The Future Is Hybrid
  • September 30, 2019

Actian Datacast: The future is hybrid

This is the fourth and final installment of an in-depth blog series examining the findings of the recent Actian Datacast 2019: Hybrid Data Trends Snapshot. The survey (which polled 303 IT professionals with influence or decision-making ability at companies of 250+ employees) identified four key trends which were illustrated in the Datacast Infographic. Our…

Read More
IT And Cyber Security In A Data Driven Enterprise
  • September 9, 2019

IT and Cyber Security in a Data Driven Enterprise

A significant number of employers make the mistake of thinking that only the IT department personnel or security officers are in charge of information security. Any one person from any one department can open the door of opportunity for hackers to gain control of sensitive data or personal information. This is why it is…

Read More
Learn How To Get Started With Actian
  • September 4, 2019

Learn How to Get Started with Actian

Are you new to Actian or currently testing out Actian Products? If so, check out our new Getting Started learning channel at https://communities.actian.com/s/getting-started-quick-tutorials. These bite-sized tutorials will get you started quickly with some of our core products: Actian Avalanche Actian Zen Actian DataConnect Actian DataFlow And we'll be adding more!

Read More
Start Learning Zen V14
  • August 29, 2019

Start Learning Zen v14

Are you new to Actian Zen and want to learn how to get started with it? Check out our newly built YouTube channel! Topics include: Authorize an Actian Zen license for Windows Install the Actian Zen Backup Agent for Windows Configure the Actian Zen Backup Agent for Windows Instal Actian Zen into Linux Install…

Read More
If ETL Is Integration Hell, How Do I Avoid It And Go To Heaven?
  • August 22, 2019

If ETL Is Integration Hell, How Do I Avoid It and Go to Heaven?

Extract, Transform, and Load (ETL) is the process that has been used to share data between applications, transactional systems, and data warehouses for decades.  It essentially works like this; you define an integration, pull the data out of the source system, use some mapping and aggregation rules to transform the data into the format…

Read More
Does It Make Sense To Push All Your IoT Data To The Cloud?
  • August 19, 2019

Does It Make Sense to Push All Your IoT Data to the Cloud?

IoT devices create plenty of data – much more that you might think. When you multiply this amount of data by the number of devices installed in your company’s IT ecosystem, it is apparent IoT is a truly big data challenge. Two common questions IT staff and data management professionals have been asking during…

Read More
Should You Have Separate Document, Time-Series, NoSQL And SQL Databases Or Can A Single Database Support All Of These Data Types And Requirements?
  • July 31, 2019

Should You Have Separate Document, Time-Series, NoSQL and SQL Databases or Can a Single Database Support All of These Data Types and Requirements?

Managing and analyzing heterogeneous data is a challenge for most companies, which the oncoming wave of Edge Computing-generated datasets has only exacerbated. This challenge stems from a rather large “data-type mismatch” as well as how and where data has been incorporated into applications and business process. How did we arrive here? At one time,…

Read More
Managing Data Across Distributed Data Warehouses
  • July 17, 2019

Managing Data Across Distributed Data Warehouses

Data integration, like the digital-transformation initiatives it supports, is a journey and not a destination. Every company is somewhere on a path from the past to a desired state of future integration they’d like to achieve. If your company has existed for a number of years, then you likely have multiple databases, data marts…

Read More
How To Address Integration Challenges With The Proliferation Of IoT Devices
  • July 16, 2019

How to Address Integration Challenges with the Proliferation of IoT Devices

During the past few years, IoT devices have evolved from being a consumer novelty to a core part of next-generation IT ecosystems for businesses of all sizes. IoT devices (such as smart watches, fitbits, home sensors, RFID point of sale scanners, heartbeat monitors, etc) have become attractive and useful because of their inexpensive price…

Read More
Will Data Management In Operational Technology Finally Be Standardized?
  • July 11, 2019

Will Data Management in Operational Technology Finally Be Standardized?

The proliferation of Operational Technology (OT) within companies is increasing, which has led many to ask whether this will lead to standardization of how operational technology generated data is managed? The answer is “it’s complicated.” There is unlikely to be standardization of the data individual operational technology devices generate, but there will be new…

Read More
Are You Collecting The Right Data Sources?
  • July 8, 2019

Are You Collecting the Right Data Sources?

Quantity as well as quality are so important to your data, but there is a third dimension to your data puzzle that is even more important – content. As your company evaluates new data sources and improvements to your existing data, ask yourself, “Are we collecting the right data?” Here are three tips to…

Read More
Connecting To An Actian X (Ingres) Database From PHP Via JDBC
  • March 8, 2019

Connecting to an Actian X (Ingres) Database from PHP via JDBC

We have documented the best way to connect from PHP to an Ingres database via ODBC in an Actian Knowledge Base article called Ingres ODBC with PHP and in a previous post, Connecting to Actian X (Ingres) with PHP and NGINX. Sometimes, however, due to limitations, users may need to use JDBC instead of ODBC…

Read More
Worried About SQLite Security Vulnerabilities?  Keep Calm And Stay Safe.
  • December 19, 2018

Worried about SQLite security vulnerabilities? Keep calm and stay safe.

Face the inevitable: Local persistent data at the Edge will happen It’s indisputable that Edge Intelligence will grow, whether that’s mobile applications running on Smartphones, IoT applications running in Smart Cars (or the underlying sensors), in the entertainment center, navigation systems, etc.  There will be countless mobile and IoT – taken as a whole,…

Read More
  • October 18, 2018

Airplane Mode aka The Cloud Digital Divide

I recently took a last-minute trip from San Francisco to India.  The best fare in economy I could find was on a sixteen-hour Air India flight, direct to New Delhi.  I figured I’d get a lot of work done on the flight and, if not, at least I could catch-up on movie watching.  Turns…

Read More
A Moment Of Zen For Your Resting IoT Data On Its Journey To Data Nirvana
  • May 4, 2018

A moment of Zen for your resting IoT data on its journey to data nirvana

Early in my career I studied Systems Engineering at night which is where I first came across the term IPO which is an acronym for Input-Processing-Output. My lecturer taught us every software function has three basic sequential steps, reading input data, processing that data and eventually outputting it.  In a more complex system, such…

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
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
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
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), Actian's combination of industry-leading transactional and high-speed analytic databases, to the Web. Here we present how to use a very popular web server (reverse proxy, load balancing, etc...) on Linux, NGINX, to do just that. Here's how…

Read More
Introducing Actian X – The New Ingres
  • April 27, 2017

Introducing Actian X – the new Ingres

Last week, Actian introduced the the new Ingres - Actian X Hybrid Database, combining the industry-leading Ingres RBMS with the record breaking analytic database Vector. With column-based storage, vector processing, multi-core parallelism (and more), Actian X puts amazing performance in the hands of Ingres developers. We've also bundled two other really big features: 1)…

Read More