Skip to main content
Online analytical processing

Online analytical processing

Search complete. 16 mentions across 9 episodes found for "Online analytical processing".

Nov 18, 2026

Unknown podcast

Workday Buys a Compiler

Nov 18 · 1 Mention

speaker_1HOST
7:54
Sure.
speaker_1HOST
7:55
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.
speaker_0HOST
8:07
Okay, so it ensures backward compatibility with the old stuff.
speaker_1HOST
8:10
Exactly.

Unknown podcast

Define Once, Compile Everywhere. Compiled, Not Guessed.

Nov 18 · 1 Mention

speaker_0HOST
6:53
For the finance teams out there, that XML endpoint is wild.
speaker_0HOST
6:57
What it means is that Honeydew exposes each of its curated domains as an OLAP queue.
speaker_0HOST
7:02
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.
speaker_1HOST
7:10
That's a big deal for adoption.
Arun NandiGUEST
14:59
So telemetry data of products where we have over five terabytes of data that we collect each day.
Arun NandiGUEST
15:06
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.
Arun NandiGUEST
15:31
from the previous generation archetype of potentially running those through batch jobs to more be a continuous cycle of how you develop these.
Arun NandiGUEST
15:39
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.
Deepti SrivastavaGUEST
29:38
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.
Ben LoricaHOST
29:50
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.
Ben LoricaHOST
30:10
So let's set that aside.
Ben LoricaHOST
30:12
It works well, but you have to be in the Databricks world,
Lars RönnbäckGUEST
57:05
And when we were looking at this, the technology wasn't really there.
Lars RönnbäckGUEST
57:10
But right now, there's, you know, OLAP and OLTP, that distinction.
Lars RönnbäckGUEST
57:16
Now there's actually something called HTAP, hybrid transactional analytical processing databases.
Lars RönnbäckGUEST
57:23
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.
Rajkumar SenGUEST
10:52
Now, the use case could be...
Rajkumar SenGUEST
10:56
OLTP system to an OLAP system.
Rajkumar SenGUEST
10:58
Now, if you think of 2018, 2019, there was not a single OLAP system which was consuming events.
Rajkumar SenGUEST
11:05
All of them were very happy.
Rajkumar SenGUEST
11:06
Hey, give me a CSV file or a Parquet file.
Adam StacoviakHOST
15:35
world,
Craig KerstiensGUEST
15:37
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.
Craig KerstiensGUEST
15:49
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
Craig KerstiensGUEST
15:56
Whereas analytical systems are typically column-based.
Craig KerstiensGUEST
16:58
It's so fast,
Adam StacoviakHOST
16:59
yeah.
Craig KerstiensGUEST
17:00
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
Craig KerstiensGUEST
17:08
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.
Adam StacoviakHOST
15:35
world,
Craig KerstiensGUEST
15:37
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.
Craig KerstiensGUEST
15:49
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
Craig KerstiensGUEST
15:56
Whereas analytical systems are typically column-based.
Craig KerstiensGUEST
16:58
It's so fast,
Adam StacoviakHOST
16:59
yeah.
Craig KerstiensGUEST
17:00
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
Craig KerstiensGUEST
17:08
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.
Adam StacoviakHOST
15:35
world,
Craig KerstiensGUEST
15:37
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.
Craig KerstiensGUEST
15:49
The reality is like, you know, OLTP, operational databases, are row-based stores, right? They store a whole row together.
Craig KerstiensGUEST
15:56
Whereas analytical systems are typically column-based.
Craig KerstiensGUEST
16:58
It's so fast,
Adam StacoviakHOST
16:59
yeah.
Craig KerstiensGUEST
17:00
Completely different from the OLAP world, right? Which is, I don't mean anything in one millisecond.
Craig KerstiensGUEST
17:08
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.

We value your privacy

We use cookies to understand how you use our platform and to improve your experience. Click “Accept All” to consent, or “Decline non-essential” to opt out of non-essential cookies. Read our Privacy Policy.