EN

Connect an AIAI Sign in or sign upSign in

ITMO | dbs 7

Presentations of the project 4

ITMO DB Lesson 1
ITMO DB Lesson 2
ITMO DB Lesson 3
ITMO DB Lesson 4

ITMO DB Lesson 4

No jumps between slides yet: add a click action "Slide" to a block. Links to the previous or the next slide are not shown.

Column-Oriented DBMS: ClickHouse1
Lesson Plan2
Glossary: Storage3
Glossary: changes and queries4
Two Workloads: OLTP and OLAP5
Rows and Columns on a Disk6
Table Engines: Which One to Use and When7
Section: What INSERT Does8
Partitions: groups of sections9
merge: from small parts to large ones10
Sparse index: entry per granule11
MergeTree Event Schedule12
Lab index: 1 granule or 21813
Inserting in bundles: how many pieces14
ReplacingMergeTree: Duplicates and Corrections15
Modifications and deletions: expensive and not immediate16
Materialized view: DAU without raw events17
Insert retry and double counting18
How Data Gets into ClickHouse19
Game Metrics: ClickHouse Functions20
PostgreSQL or ClickHouse21
ClickHouse or Not: Decision Table22
ClickHouse in Gaming and Beyond23
Common Mistakes in Projects24
Key takeaways25
Review Questions26
P1. How much does each column weigh?>_27
P2. Which granules did the index discard?>_28
P3. Table segments and partitions>_29
P4. Another recap: FINAL vs. raw strings>_30
P5. Reading the MV Unit>_31
P6. Deduplication compares blocks>_32
P7. Deleted rows are still on the disk>_33
P8. Retention: retention()>_34

No matching slides.

Presentation

ITMO DB Lesson 4

Choose a slide in the navigator or start the presentation.

Present