Posts by Category

• CMU Database Systems 10
• Effective C++ 5
• Data Science 1

CMU Database Systems

[CMU Database Systems] 10. Join Algorithms

2 minute read

Joins

[CMU Database Systems] 09. Sort & Aggregation Algorithms

8 minute read

Sorting

[CMU Database Systems] 08. Concurrency Control

9 minute read

Concurrency Control

[CMU Database Systems] 07. B+Tree Index

14 minute read

Table Indexes

[CMU Database Systems] 06. Hash Tables

11 minute read

Data Structures

[CMU Database Systems] 05. Memory Management

9 minute read

Introduction

[CMU Database Systems] 04. Storage Models & Compression

9 minute read

All examples for SQL in this post will use the following database that models a simple Wikipedia.

[CMU Database Systems] 03. Database Storage

15 minute read

Storage

[CMU Database Systems] 02. Modern SQL

17 minute read

Relational Languages

[CMU Database Systems] 01. Relational Model & Relational Algebra

13 minute read

Database

Back to top ↑

Effective C++

[Effective C++] 5. Implementations

1 minute read

Item 26: Postpone variable definitions as long as possible.

[Effective C++] 4. Designs and Declarations

8 minute read

Item 18: Make interfaces easy to use correctly and hard to use incorrectly.

[Effective C++] 3. Resource Management

4 minute read

Item 13: Use objects to manage resources.

[Effective C++] 2. Constructors, Destructors, and Assignment Operators

4 minute read

Item 5: Know what functions C++ silently writes and calls.

[Effective C++] 1. Accustoming Yourself to C++

2 minute read

Item 1: View C++ as a federation of languages.

Back to top ↑

Data Science

Chebyshev’s Theorem

4 minute read

Chebyshev’s Theorem provides a way to estimate the minimum proportion of observations within a specified number of standard deviations from the mean in any d...

Back to top ↑