facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
Actian Blog / Tag / Data Warehouse

Tagged Posts: Data Warehouse

What Is A Data Analytics Hub?
  • February 25, 2021

What is a Data Analytics Hub?

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…

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
Connected Data Makes Compliance Easier
  • April 22, 2020

Connected Data Makes Compliance Easier

Regulatory compliance can be a headache for any company.  If you do business globally, the challenge is even more significant.  Governmental regulations vary greatly across countries and even within local regions.  If that weren’t difficult enough, add on a continuous stream of regulatory changes, and you have a real problem.  Whether you are trying…

Read More
Financial Services Companies Need All The Data Analytics They Can Get
  • April 8, 2020

Financial Services Companies Need all the Data Analytics They Can Get

There are times when financial markets trend up. There are times that markets trend down.  And then there are times that the markets go crazy and the only thing predictable is volatility. When markets encounter these volatile periods, financial services companies become highly reliant on data analytics to determine where the real market forces…

Read More