<transcript><audio_51>in the main table and then I've got a time travel table and in that time travel table I'll put the old values and the old values keep will keep getting accumulated in that second table so now if I need if I'm a reader and I'm only</transcript><transcript><audio_52>allowed to read A2 I will start from the main table go down to a second table which is a different file so obviously that's more expensive that way you won't ever get locality uh to chase down that you're Crossing table boundaries but it doesn't disrupt the main table which</transcript><transcript><audio_53>just has a single copy the most recent copy and uh as you can see over here okay and that most recent copy may not be the one that eventually gets committed we'll start talking about the recovery protocols a little bit but it's the most recent copy in the chain at</transcript><transcript><audio_54>exists at that point in time if you use time travel storage you have to uh if you do time travel storage it implicitly gives you newest to all this yes that's observation that's correct and basically</transcript><transcript><audio_55>it's done as you can imagine if you had a 30-year-old database system and all of a sudden mbcc is the way you get more concery especially for the readers this is the least disruptive change you would make to your system okay because your indices can keep pointing to the lasater copy in the</transcript><transcript><audio_56>main table all right and the record ID hasn't changed it still is in the same slot in the same page Why is it implicitly newest like I gu head sort of table the newest is there yeah</transcript><transcript><audio_57>so yeah and so here in this diagram as you can see it's a little weird A2 is the oldest which is pointing to A1 which is uh which is not necessarily the uh old the newest but and you can flip it around and switch it around in a</transcript> in the main table and then I've got a time travel table and in that time travel table I'll put the old values and the old values keep will keep getting accumulated in that second table so now if I need if I'm a reader and I'm only allowed to read A2 I will start from the main table go down to a second table which is a different file so obviously that's more expensive that way you won't ever get locality uh to chase down that you're Crossing table boundaries but it doesn't disrupt the main table which just has a single copy the most recent copy and uh as you can see over here okay and that most recent copy may not be the one that eventually gets committed we'll start talking about the recovery protocols a little bit but it's the most recent copy in the chain at exists at that point in time if you use time travel storage you have to uh if you do time travel storage it implicitly gives you newest to all this yes that's observation that's correct and basically it's done as you can imagine if you had a 30-year-old database system and all of a sudden mbcc is the way you get more concery especially for the readers this is the least disruptive change you would make to your system okay because your indices can keep pointing to the lasater copy in the main table all right and the record ID hasn't changed it still is in the same slot in the same page Why is it implicitly newest like I gu head sort of table the newest is there yeah so yeah and so here in this diagram as you can see it's a little weird A2 is the oldest which is pointing to A1 which is uh which is not necessarily the uh old the newest but and you can flip it around and switch it around in 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"}}