Search Bar & Notes Feed

dbt Fundamentals Link to the course Below are my notes for the class dbt Fundamentals. dbt is a platform for data transformation using Jinja syntax and SQL. Models Models are .sql files in the models folder dbt run materializes a model as a table or vie...

Design of Practical System for Fault-Tolerant VMs Paper Link This is my review/summary of this famous paper on fault-tolerance using the state-machine approach. Shipping all changes to primary machine to backup consumes enormous bandwidth Instead, mode...

Scalable Computation of High-Order Optimization Queries Paper link Overview with simple words The paper proposes a solution for finding a set of tuples that collectively satisfy certain group constraints. The set of tuples could be filtered initially using...

Query Cost Estimation Example Consider the following tables Sailors sid sname rating age INT TEXT INT(0-9) FLOAT Sailor relation has 500 pages, each with 80 tuples. The ra...

Hello, I am Pengyu. Welcome to my blog, which hosts some of my writings. This is the blog that facilitates sharing of my writings on various subjects. I use this website with Obsidian as my knowledgebase.