<transcript><audio_25>five things we need to talk about in addition to mvcc as a mechanism that creates this version the first one was concery control they're going to start knocking these other things down like next thing we're going to look at is how is the storage for this version</transcript><transcript><audio_26>maintained right it's a singly link list that we are maintaining what are the different ways of organizing that just as we looked at what are different ways of organizing records in pages and and uh structures like that so let's get to the version</transcript><transcript><audio_27>storage now we are creating these version chains and these version chains have these begin and end time stamps that are associated with it and there are different ways in which we could create these version chains as we'll see</transcript><transcript><audio_28>for all of the remainder topics that we have for mvcc for each of those mechanisms the each of these addition things that we need to consider for mvcc we'll see there are some number of options there'll be three four five options and then each one of them will</transcript><transcript><audio_29>have their pros and cons so the first question we are going to look at with version storage is how do we store these versions guess what there are three ways to do it both of all of them have their pros and cons and some historical context the first one is a pendon</transcript><transcript><audio_30>storage where I'm going to create the chains kind of like what we've been seeing in the diagram so far where in the same table where the record is you're going to create the version uh version</transcript><transcript><audio_31>way compon of those records time travel which is used by systems that didn't have mvcc but then realize that wow with mvcc you can get a lot more concurrency especially for the readers so they slapped on a mechanism to keep versions by saying I'll just create a second copy</transcript> five things we need to talk about in addition to mvcc as a mechanism that creates this version the first one was concery control they're going to start knocking these other things down like next thing we're going to look at is how is the storage for this version maintained right it's a singly link list that we are maintaining what are the different ways of organizing that just as we looked at what are different ways of organizing records in pages and and uh structures like that so let's get to the version storage now we are creating these version chains and these version chains have these begin and end time stamps that are associated with it and there are different ways in which we could create these version chains as we'll see for all of the remainder topics that we have for mvcc for each of those mechanisms the each of these addition things that we need to consider for mvcc we'll see there are some number of options there'll be three four five options and then each one of them will have their pros and cons so the first question we are going to look at with version storage is how do we store these versions guess what there are three ways to do it both of all of them have their pros and cons and some historical context the first one is a pendon storage where I'm going to create the chains kind of like what we've been seeing in the diagram so far where in the same table where the record is you're going to create the version uh version way compon of those records time travel which is used by systems that didn't have mvcc but then realize that wow with mvcc you can get a lot more concurrency especially for the readers so they slapped on a mechanism to keep versions by saying I'll just create a second copy
{"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"}}