article thumbnail

Themes and Conferences per Pacoid, Episode 11

Domino Data Lab

SQL optimization provides helpful analogies, given how SQL queries get translated into query graphs internally , then the real smarts of a SQL engine work over that graph. The query graph provides metadata that gets leveraged for optimizations at multiple layers of the relational database stack. SQL and Spark. That’s good stuff.

Metadata 105
article thumbnail

Accelerating revenue growth with real-time analytics: Poshmark’s journey

AWS Big Data

The Design Lab is one half to two day engagement with customer team offering prescriptive guidance to arrive at the optimal solution architecture design before you embark on building the platform. This frequently accessed information cached in a centralized cache will optimize fetch time.

article thumbnail

Unleashing the power of Presto: The Uber case study

IBM Big Data Hub

With a few taps on a mobile device, riders request a ride; then, Uber’s algorithms work to match them with the nearest available driver and calculate the optimal price. This allowed them to focus on SQL-based query optimization to the nth degree. But the simplicity ends there. Every transaction, every cent matters.

OLAP 92