Skip to main content

5 posts tagged with "SQL"

View All Tags

Analyst

Introduction

In today’s Apparel and Footwear markets, customers desire personalized experiences, trends shift overnight, and supply chains need constant optimization. In addition, traditional analytics infrastructure can no longer provide the necessary decision support as it did in the past. Integration of near real-time data synchronization, correct and timely analysis, and reduced inventory costs have become indispensable. Efficient data-driven decisions require efficient processing of data.

Mihai Budiu

Introduction

In previous blog posts we have:

In this blog post we explain how an incremental query engine like Feldera actually operates as seen by a user. We start by motivating the need for incremental computation in databases. Future blog posts will describe the internal operations in detail.

Mihai Budiu

Introduction

In three previous blog posts we have:

In this blog post we describe two additional SQL operations for Z-sets: GROUP BY and JOIN.

Mihai Budiu

Introduction

In a couple of blog posts we have introduced Z-sets as a mathematical representation for database tables and changes to database tables, and we have given a simple Java implementation of the basic Z-set operations. In this blog post we build a few additional methods for Z-sets which enable us to perform traditional database computations.

Recall that a Z-set is just a table where each row has an attached integer weight, which can be either positive or negative. We can then define operations of addition and negation for Z-sets, where the sum of two Z-sets contains all rows in either Z-set; the weight of a row in the result is the sum of the row's weights in both sets.

Mihai Budiu

This article is about the Apache Calcite compiler framework. We describe the core data structures used by Calcite to represent programs.

About Apache Calcite

The SQL compiler that is part of the Feldera repository is built on top of the Apache Calcite infrastructure. Using Calcite enabled us to create a SQL compiler covering the core SQL language in a record time (we're still working on it, though).