<transcript><audio_269>concern is that a page that was stolen and flush to disk may have changes that were made by an uncommitted transaction now we need to undo that so we're going to need logging to allow us to undo that so log loing is going to be used logging</transcript><transcript><audio_270>must have enough information to allow us to redo and undo and the recovery protocol that we'll talk about in the next class we decide whether when it needs a log record whether it has to redo or undo but along with that there's another</transcript><transcript><audio_271>fundamental protocol that we need and that is called WR ahead logging the two very foundational pieces that you need in databases one is this notion of two-phase locking because from that you got the dependence graph of which everything is based for you to</transcript><transcript><audio_272>understand how to get isolation the other piece is right ahead logging which is the protocol that says what at what point can I declare a transaction status to be committed or aborted uh there's a</transcript> concern is that a page that was stolen and flush to disk may have changes that were made by an uncommitted transaction now we need to undo that so we're going to need logging to allow us to undo that so log loing is going to be used logging must have enough information to allow us to redo and undo and the recovery protocol that we'll talk about in the next class we decide whether when it needs a log record whether it has to redo or undo but along with that there's another fundamental protocol that we need and that is called WR ahead logging the two very foundational pieces that you need in databases one is this notion of two-phase locking because from that you got the dependence graph of which everything is based for you to understand how to get isolation the other piece is right ahead logging which is the protocol that says what at what point can I declare a transaction status to be committed or aborted uh there's a
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1/-mY8ALcJVTk.tar.gz"}}