facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
What Is The Future Of Data Quality Management (DQM)?
  • September 22, 2022

What is the Future of Data Quality Management (DQM)?

Today’s digital-first world has placed a tremendous emphasis on using enterprise data intelligently to drive important business decisions and manage risk. High-quality datasets function as the fuel for enterprises looking to map customers, track where they are in the lifecycle, and inform next steps on how to better engage them. However, simply having access…

Read More
Technical Trifecta: The Future Of Data Professionals
  • June 3, 2022

Technical Trifecta: The Future of Data Professionals

Data-driven roles are in demand. According to research firm Deloitte, the number of postings for positions in data science, data engineering, machine learning (ML), and visualization now surpasses those for more familiar skill sets such as customer service, marketing, and public relations (PR). For database administrators (DBAs), business technologists, and data engineers, this increasing…

Read More
The Customer Journey And The Role Of Data
  • May 23, 2022

The Customer Journey and the Role of Data

A typical buyer’s journey moves through distinct phases starting with Awareness, continuing on to Consideration, Purchase, and Onboarding/Post-Purchase, and hopefully ending in Advocacy. Much of the journey is carried out digitally – up to 67%, according to some estimates. Data breadcrumbs are left behind along a digital path, as people search online, sign up…

Read More
Zen Edge Database And Ado.net On Raspberry Pi
  • March 31, 2022

Zen Edge Database and Ado.net on Raspberry Pi

Do you have a data-centric Windows application you want to run at the Edge? If so, this article demonstrates an easy and affordable way to accomplish this by using the Zen Enterprise Database through Ado.net on a Raspberry Pi.  Raspberry Pi features a 64-bit ARM processor, can accommodate several operating systems, and cost around…

Read More
5 Uses Cases For Hybrid Cloud Data Management
  • February 25, 2022

5 Uses Cases for Hybrid Cloud Data Management

With the rise of cloud computing, many organizations are opting to use a hybrid approach to their data management. Even though many companies still rely on on-premises storage, the benefits of having cloud storage as a backup or disaster recovery plan can be significant. This post will give you five of the most popular…

Read More
Data Democratization: Promise Vs Reality
  • February 10, 2022

Data Democratization: Promise vs Reality

Enabling universal access to data can create opportunities to generate new revenue and drive operational efficiencies throughout an organization. Even more importantly, data democratization, as it’s known, is crucial to business transformation. For that reason, vendors have made a lot of promises about enabling data democratization—and not all have panned out. For instance, various…

Read More
What’s An Edge Data Fabric?
  • January 31, 2022

What’s an Edge Data Fabric?

What’s a Data Fabric? A data fabric is a data architecture, management practices, and policies to deliver a set of data services that span all these domains and endpoints.  Data fabrics provide that framework. They essentially serve as both the translator and the plumbing for data in all its forms, wherever it sits and…

Read More
Engineered Decision Intelligence: The Best Way Forward Part 1
  • January 28, 2022

Engineered Decision Intelligence: The Best Way Forward Part 1

Part 1: You Need a Data Fabric Among Gartner’s top 10 data and analytics trends for 2021 is engineered decision intelligence.[1] That raises two compelling questions: What is this? and Why should you care? Engineered business intelligence is, when you think about it, just what it says: a deliberate process to deriving business intelligence…

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
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
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
It’s Time For Data Historians To Become … History
  • July 17, 2021

It’s Time for Data Historians to Become … History

Database Historians...History? Why a modern time-series capable database can simplify yet enhance time-series data analysis. Despite the professorial image the term suggests, a data historian is not an instructor or researcher, but a purpose-build software solution. And evolutions in how operational data is used and managed have eclipsed the need for data historian software…

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
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
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 – 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
Visualizing Social Relationships Using Object Databases
  • January 23, 2020

Visualizing Social Relationships Using Object Databases

Social relationships hold a wealth of information about your customers, employees, and suppliers that (if you have the tools to harness them) can provide you valuable insights about the factors that influence behaviors that ultimately impact your bottom line.  The challenge with analyzing and visualizing social relationships is that the underlying data doesn't match…

Read More
Layman’s Guide To Machine Learning And Customer Data Privacy
  • January 16, 2020

Layman’s Guide to Machine Learning and Customer Data Privacy

It feels like only yesterday that “Machine Learning” and “Artificial Intelligence” were equated with science fiction by most regular folks outside of tech. As a movie-going culture, we have a long history of associating these concepts with self-aware robots or rogue computer programs that could escape the laboratories where they were created and threaten all humanity. But in 2020, ML and AI have been considerably demystified. And yet, even if it seems less…

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
Chat With Us!
  • November 13, 2019

Chat with us!

Learn about the new way to engage Support Services at Actian We are delighted to introduce the “Live Chat” feature, which was embedded in “Actian Communities” on November 11, 2019. It is a complete chat solution that enables instant chat support with Actian subject matter experts. Each chat request will be directed to the…

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
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
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
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
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
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
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
Is Big Data Useful To Anyone? Does It Have Intrinsic Value?
  • July 1, 2022

Is Big Data Useful to Anyone? Does it Have Intrinsic Value?

Embarking on a big data project can be daunting. If you believe that you need insight into your business activity, that you have to collect a large “big data” stash, and that you need to analyze it all to generate worthwhile insight, you will likely feel swamped by the task ahead to get any…

Read More
Cloud Economics – The Advantage Of Moving Your Data To The Cloud (TCO)
  • June 21, 2022

Cloud Economics – The Advantage of Moving Your Data to the Cloud (TCO)

Cloud economics is a relatively new term, but it is growing in importance as businesses increasingly move their data to the cloud. As more organizations look for new ways to model their business in support of scalability and agility, it has become imperative that they better understand the short and long-term costs of cloud…

Read More
Data Profiling And Data Quality: What You Need To Know
  • April 15, 2022

Data Profiling and Data Quality: What You Need to Know

Data is the lifeblood of business: it drives decision making, allows for analysis and prediction, and can help drive revenue. But data can also be its own worst enemy: it can lead to analysis paralysis, lead to inaccurate predictions, and even make processes more bureaucratic. That’s where data profiling and data quality come in.…

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