Actian Blog / Tag / Data Warehouse

Tagged Posts: Data Warehouse

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
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
What Is A Data Analytics Hub?
  • February 25, 2021

What is a Data Analytics Hub?

And why is it better than a Data Lake or an Analytics Hub? 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…

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
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
What To Do When Your Data Warehouse Chokes On Big Data
  • August 26, 2020

What to do when your Data Warehouse Chokes on Big Data

This may seem like an academic question, but it is increasingly becoming a reality for modern businesses. What do you do when you have millions of records with infinite width and depth, and your data warehouse chokes?  Do you trim your data?  Do you add more infrastructure capacity?  Or do you need to look…

Read More
The Impact Of Updates On Data Warehouse Performance
  • August 20, 2020

The Impact of Updates on Data Warehouse Performance

When companies project data warehouse growth, they often look at a curve that mimic’s the growth of data in source systems.  This approach works if all you are concerned with is storage growth.  What is commonly overlooked is the compute growth curve for processing updates to your data.  As IT systems become more interconnected,…

Read More
Operationalizing Your Hadoop Data Lake
  • July 15, 2020

Operationalizing your Hadoop Data Lake

Have you ever tried to join your fact and dimension tables together to generate operational analytics? If you want to perform large scale data analysis on things like customer churn, you’re probably going to need to do this.  The problem is, these tables are very large, and when you bring them together, the resulting…

Read More
Connected Data In The Cloud Increases AI System Performance
  • June 29, 2020

Connected Data in the Cloud Increases AI System Performance

Artificial Intelligence (AI) is the core of the next wave of IT systems, and it is time to get ready. The past year has seen tremendous growth in the adoption of artificial intelligence systems to help companies improve operational insights and provide enhanced customer service experiences.  If you aren’t leveraging AI to support your…

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
Developing A 360-Degree View Of Your Customer With Connected Data
  • April 29, 2020

Developing a 360-Degree View of Your Customer With Connected Data

How well do you know your customers?  Do you know what they buy?  Do you know when and why they make purchases?  Do you know who influences their buying behavior?  Do you know how price sensitive they are and what types of promotions they respond to?  You should know these things.  Connected data can…

Read More
Are You Afraid To “Lift The Lid” On Cloud Technology?
  • April 23, 2020

Are you afraid to “Lift the Lid” On Cloud Technology?

The Opening of the Box As was the case with Pandora's box, once the lid is opened on cloud technology and you realize that perhaps the shiny new object interior didn't provide what you expected from your investment in the technology, it may be too late to change directions. So is the case with…

Read More
facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo