20 - Database Logging Schemes (CMU Databases Systems / Fall 2019)

  Рет қаралды 13,491

CMU Database Group

CMU Database Group

Күн бұрын

Пікірлер: 14
@春华秋实-f8o
@春华秋实-f8o 5 жыл бұрын
congratulations and welcome back
@mazenezzeddine2188
@mazenezzeddine2188 4 жыл бұрын
Congratulations! Like Father Like Son. Long live for you all.
@xiaohutang5666
@xiaohutang5666 3 жыл бұрын
WAL starts from: 41:34
@abdelrhmanahmed1378
@abdelrhmanahmed1378 2 жыл бұрын
when the changes we made and recorded inside the wal get reflected to the actual pages of the table ?
@llersch
@llersch 4 жыл бұрын
Great lecture :) I missed why the combination of No-Steal+No-Force and Steal+Force is not discussed. The paper "Principles of Transaction-Oriented Database Recovery" briefly elaborates on them. Is it the case that modern systems don't fall in those categories anymore?
@AshishNegi1618
@AshishNegi1618 4 жыл бұрын
In steal + force => multiple concurrent transactions will modify but on commit for each tx, we need to flush. Since we are also flushing uncommitted changes of other txs, to keep track of them, we also note them down (like in WAL).. but then it is double write penalty or amplification. :( In no steal + no force => only 1 tx can change a page at a time and on commit we don't flush it => we use WAL for durability => so it is like non concurrent version of steal + no force (WAL) :( seems like both are non-optimal versions.
@anarionzuo1425
@anarionzuo1425 3 жыл бұрын
So is the baby yours?
@pb25193
@pb25193 4 жыл бұрын
Today I realized that DJ DROP TABLE has to be written on all caps, the way you will write it in SQL while deleting tables. Am I right Andy?
@andypavlo
@andypavlo 4 жыл бұрын
Yes
@tanzilurrahman1999
@tanzilurrahman1999 4 жыл бұрын
@@andypavlo I'd always found it a peculiar DJ name. Makes so much more sense now
@kechenghuang845
@kechenghuang845 4 жыл бұрын
are there any possible no-steal+no-force solutions?
@cydiater
@cydiater 3 жыл бұрын
the start is so funny🤣
@AndersonSilva-dg4mg
@AndersonSilva-dg4mg 5 жыл бұрын
thank you Andy
@papagunit
@papagunit 5 жыл бұрын
Starts at 3:05
21 - ARIES Database Recovery (CMU Databases Systems / Fall 2019)
1:18:07
CMU Database Group
Рет қаралды 12 М.
22 - Introduction to Distributed Databases (CMU Databases Systems / Fall 2019)
1:13:52
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
I Just Unlocked MacOS GOD MODE With Hammerspoon
9:50
DevOps Toolbox
Рет қаралды 7 М.
24 - Distributed OLAP Databases (CMU Databases Systems / Fall 2019)
1:25:15
CMU Database Group
Рет қаралды 11 М.
Event-Driven Architecture (EDA) vs Request/Response (RR)
12:00
Confluent
Рет қаралды 177 М.
16 - Concurrency Control Theory (CMU Databases Systems / Fall 2019)
1:23:08
CMU Database Group
Рет қаралды 23 М.
23 - Distributed OLTP Databases (CMU Databases Systems / Fall 2019)
1:22:24
CMU Database Group
Рет қаралды 11 М.
Database Sharding and Partitioning
23:53
Arpit Bhayani
Рет қаралды 103 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 219 М.
Database Indexing for Dumb Developers
15:59
Laith Academy
Рет қаралды 79 М.
Microservices with Databases can be challenging...
20:52
Software Developer Diaries
Рет қаралды 111 М.
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН