<transcript><audio_66>can generalize that stuff to only keeping track of the change that you've made so uh I noticed that whether you use data storage or time travel you always keep a copy of the most of value</transcript><transcript><audio_67>in the in the other uh do you add it when you update the main table or do you add it you add it like after you update the main yeah yeah yeah so you're asking uh when do I make a change in the main</transcript><transcript><audio_68>table versus the Delta storage table so again there's going to be a bunch of details but most of the time what you going to do is you take the copy put it over there then update the value in there you'll move the old one stuff out to the whereas your backup storage or whether the chain storage before you</transcript><transcript><audio_69>make that because you have to remember that and you have to make that copy before because what happens if there's a crash between you making those changes if both the values are the same they'll have the same Tim stamp you can go clean some of that stuff if you need it to but</transcript><transcript><audio_70>if A2 in the main table doesn't get updated to A3 then theoretically there wouldn't be yeah yeah yeah and so you're getting into a little bit of this recovery protocols and the fact that sometimes you may want to undo some change because something</transcript><transcript><audio_71>Abed absolutely you all of that will happen with versioning to and we'll get to what we'll do like literally what we'll do is before we go and along with the changes that we make we'll also write what we are going to talk about next which is log records to maintain</transcript> can generalize that stuff to only keeping track of the change that you've made so uh I noticed that whether you use data storage or time travel you always keep a copy of the most of value in the in the other uh do you add it when you update the main table or do you add it you add it like after you update the main yeah yeah yeah so you're asking uh when do I make a change in the main table versus the Delta storage table so again there's going to be a bunch of details but most of the time what you going to do is you take the copy put it over there then update the value in there you'll move the old one stuff out to the whereas your backup storage or whether the chain storage before you make that because you have to remember that and you have to make that copy before because what happens if there's a crash between you making those changes if both the values are the same they'll have the same Tim stamp you can go clean some of that stuff if you need it to but if A2 in the main table doesn't get updated to A3 then theoretically there wouldn't be yeah yeah yeah and so you're getting into a little bit of this recovery protocols and the fact that sometimes you may want to undo some change because something Abed absolutely you all of that will happen with versioning to and we'll get to what we'll do like literally what we'll do is before we go and along with the changes that we make we'll also write what we are going to talk about next which is log records to maintain
{"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"}}