
Online analytical processing
16
MENTIONS
9
EPISODES
8
PODCASTS
Search complete. 16 mentions across 9 episodes found for "Online analytical processing".
Nov 18, 2026
P
Unknown podcast
Workday Buys a Compiler
Nov 18 · 1 Mention
S
7:54speaker_1HOST
Sure.
S
7:55speaker_1HOST
XMLA, or XML for Analysis, is a crucial protocol that allows legacy BI tools like a standard Excel pivot table or Power BI to talk to the semantic layer as if it were a traditional OLAP cube.
S
8:07speaker_0HOST
Okay, so it ensures backward compatibility with the old stuff.
S
8:10speaker_1HOST
Exactly.
P
Unknown podcast
Define Once, Compile Everywhere. Compiled, Not Guessed.
Nov 18 · 1 Mention
S
6:53speaker_0HOST
For the finance teams out there, that XML endpoint is wild.
S
6:57speaker_0HOST
What it means is that Honeydew exposes each of its curated domains as an OLAP queue.
S
7:02speaker_0HOST
You can literally connect a standard Excel pivot table to it, pull down live enterprise metrics, and you don't even need a Power BI license to do it.
S
7:10speaker_1HOST
That's a big deal for adoption.
How Carrier Rewrote Its Playbook to Make AI Drive Growth
A
14:59Arun NandiGUEST
So telemetry data of products where we have over five terabytes of data that we collect each day.
A
15:06Arun NandiGUEST
And that requires just a re-imagination of the architectural approach of how you think through the differences and the utility of OLAP databases versus OLTP databases, how you think through essentially the ability to connect real-time systems of agents into systems of record and systems of data.
A
15:31Arun NandiGUEST
from the previous generation archetype of potentially running those through batch jobs to more be a continuous cycle of how you develop these.
A
15:39Arun NandiGUEST
So it has really both challenged the architecture because architectures and the decisions around architecture that we're taking are getting challenged every three months, every six months or so, and we've had to reimagine those.
Why AI Agents Need a New Data Stack
D
29:38Deepti SrivastavaGUEST
Yes, I truly believe that without having federation in some format, people will not be able to use autonomous agents for critical workflows, right? Because you really do need to have access to the right systems for the agents to really be autonomous.
B
29:50Ben LoricaHOST
So since you've made federation respectable, I have to point out that Databricks, who I'm an advisor to, has also made another thing respectable, which is What is it called? The hybrid transactional analytic systems, right? So unifying OLAP and OLTP.
B
30:10Ben LoricaHOST
So let's set that aside.
B
30:12Ben LoricaHOST
It works well, but you have to be in the Databricks world,
An Introduction to Anchor Modeling with Lars Rönnbäck & Christian Kaul
L
57:05Lars RönnbäckGUEST
And when we were looking at this, the technology wasn't really there.
L
57:10Lars RönnbäckGUEST
But right now, there's, you know, OLAP and OLTP, that distinction.
L
57:16Lars RönnbäckGUEST
Now there's actually something called HTAP, hybrid transactional analytical processing databases.
L
57:23Lars RönnbäckGUEST
Snowflake is one, for example, and they haven't really pushed this Much from a marketing perspective, but it can actually do this now it can act both as an operational database and as data warehouse analytical and can do both types of workloads simultaneously.
What Does Ali Ghodsi Know And How Databricks is Winning The AI Game | Rajkumar Sen, Arcion Labs
R
10:52Rajkumar SenGUEST
Now, the use case could be...
R
10:56Rajkumar SenGUEST
OLTP system to an OLAP system.
R
10:58Rajkumar SenGUEST
Now, if you think of 2018, 2019, there was not a single OLAP system which was consuming events.
R
11:05Rajkumar SenGUEST
All of them were very happy.
R
11:06Rajkumar SenGUEST
Hey, give me a CSV file or a Parquet file.
The future is Postgres (Interview)
A
15:35Adam StacoviakHOST
world,
C
15:37Craig KerstiensGUEST
like this 30-year-old divide of like OLTP versus OLAP, right? And that's like database academic stuff, like online transactional processing, online analytical processing.
C
15:49Craig KerstiensGUEST
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
C
15:56Craig KerstiensGUEST
Whereas analytical systems are typically column-based.
C
16:58Craig KerstiensGUEST
It's so fast,
A
16:59Adam StacoviakHOST
yeah.
C
17:00Craig KerstiensGUEST
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
C
17:08Craig KerstiensGUEST
I want to know this report from Amazon.com, how many orders were placed yesterday, right? Like, I'm okay with taking that a few minutes.
The future is Postgres
A
15:35Adam StacoviakHOST
world,
C
15:37Craig KerstiensGUEST
like this 30-year-old divide of like OLTP versus OLAP, right? And that's like database academic stuff, like online transactional processing, online analytical processing.
C
15:49Craig KerstiensGUEST
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
C
15:56Craig KerstiensGUEST
Whereas analytical systems are typically column-based.
C
16:58Craig KerstiensGUEST
It's so fast,
A
16:59Adam StacoviakHOST
yeah.
C
17:00Craig KerstiensGUEST
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
C
17:08Craig KerstiensGUEST
I want to know this report from Amazon.com, how many orders were placed yesterday, right? Like, I'm okay with taking that a few minutes.
The future is Postgres (Changelog Interviews #688)
A
15:35Adam StacoviakHOST
world,
C
15:37Craig KerstiensGUEST
like this 30-year-old divide of like OLTP versus OLAP, right? And that's like database academic stuff, like online transactional processing, online analytical processing.
C
15:49Craig KerstiensGUEST
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
C
15:56Craig KerstiensGUEST
Whereas analytical systems are typically column-based.
C
16:58Craig KerstiensGUEST
It's so fast,
A
16:59Adam StacoviakHOST
yeah.
C
17:00Craig KerstiensGUEST
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
C
17:08Craig KerstiensGUEST
I want to know this report from Amazon.com, how many orders were placed yesterday, right? Like, I'm okay with taking that a few minutes.