<transcript><audio_171>want to AP aart and we need transactions to be durable so if a transaction is declared committed even after that if the system crashes the changes are recorded in the state of the database so we'll start simple with uh motivation</transcript><transcript><audio_172>simple transaction Reading Writing stuff and now we have a buffer pool which obviously database systems have but now we're going to make it explicit in our diagrams because it's because of the buffer pool that we going to have to worry about a lot of things so we bring</transcript><transcript><audio_173>in a page the page has a lot of stuff lot of Records lot of columns in each record but the uh one of them is that value a that we are trying to write the column A and we'll go bring that in and then when we write it we will go and</transcript><transcript><audio_174>update that in the buffer pole okay that's what we do right the updates happen in the buffer pool now at the time that we get to do a comit what do we do to get</transcript><transcript><audio_175>durability we could insist on taking any change that has been made and push it out to disc and if we do that we will get durability but it'll be very slow but let's say we have other protocols that don't require us to flush everything to disk at coming time</transcript> want to AP aart and we need transactions to be durable so if a transaction is declared committed even after that if the system crashes the changes are recorded in the state of the database so we'll start simple with uh motivation simple transaction Reading Writing stuff and now we have a buffer pool which obviously database systems have but now we're going to make it explicit in our diagrams because it's because of the buffer pool that we going to have to worry about a lot of things so we bring in a page the page has a lot of stuff lot of Records lot of columns in each record but the uh one of them is that value a that we are trying to write the column A and we'll go bring that in and then when we write it we will go and update that in the buffer pole okay that's what we do right the updates happen in the buffer pool now at the time that we get to do a comit what do we do to get durability we could insist on taking any change that has been made and push it out to disc and if we do that we will get durability but it'll be very slow but let's say we have other protocols that don't require us to flush everything to disk at coming time
{"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"}}