Cost-based query optimizations in multithreaded environments

Query optimizations are a vast topic which contains plenty of subtopics varying from projection, selectivity, and join optimizations. Not so many database books out there mentions or explains query optimization phenomena. So, in here we are going to both talk about query optimizations and one concrete multi threaded deterministic solution…

A field guide for reading relational algebra in database papers

If you are into databases, you will see many interesting algebraic expressions, signs, and descriptions that make content hard to understand for a newcomer. These things are mostly coming out while looking at the pipeline figures, algorithm definitions, and so on. This post is not a complete coverage of all…