Tag: database query

The ClustrixDB Query Evaluation Model

Query Evaluation Model Recently we’ve started to dig into the internals of ClustrixDB, specifically How ClustrixDB Accomplishes Horizontal Scaling of Both Writes & Reads Without Sharding. Next, we dug into the details of the multi-patented ClustrixDB Rebalancer. This time we will discuss the ClustrixDB Query Evaluation Model. ClustrixDB is a […]

ClustrixDB: Bringing the Query to the Data—Not the Other Way Around

Some arguments can’t be settled on a fact. Case in point: Which came first, the chicken or the egg? In the world of databases, a similar conundrum pops up when it comes to query resolution: Should the query be moved to the data or should the data be moved to the […]

Tech-Forum Friday: Index Usage with Functions

Index Usage with Functions Note: We’re starting this “technical forum” in order to share hot topics and noteworthy discussions from the ClustrixDB support forum with our larger audience. I just ran into this issue with a developer and thought it was blog-worthy. Our UI was doing the following query:   […]

The Clustrix Database Query Optimizer: An Intro to Sierra

Meet Sierra, the Clustrix Database Query Optimizer SQL query optimization is well known to be a difficult problem. At Clustrix, when we began to architect a new type of distributed database, we knew the query optimizer would be critical to system performance. The distributed nature of Clustrix allows us to […]