<transcript><audio_77>a new query operator to your the available operations in your system let's say for example that you didn't you only had a sort merge join and you wanted to implement a hash join all you need to do is implement the hash join operator uh that that conforms</transcript><transcript><audio_78>to this next iterator function call api and then once you have that you just plug it into your uh your query plan and it or your query execution engine and it can now be used uh just just the same as any other operator so that's kind of the the nice</transcript><transcript><audio_79>abstraction of this iterator based approach is you can think about each operator individually in in sort of these modular units and then then stitch them all together to get an arbitrarily complex</transcript><transcript><audio_80>so the the iterator version is uh or the iterator approach is the first the first uh processing model we talked about the second one uh is called the materialization model so basically what what the materialization model is going</transcript> a new query operator to your the available operations in your system let's say for example that you didn't you only had a sort merge join and you wanted to implement a hash join all you need to do is implement the hash join operator uh that that conforms to this next iterator function call api and then once you have that you just plug it into your uh your query plan and it or your query execution engine and it can now be used uh just just the same as any other operator so that's kind of the the nice abstraction of this iterator based approach is you can think about each operator individually in in sort of these modular units and then then stitch them all together to get an arbitrarily complex so the the iterator version is uh or the iterator approach is the first the first uh processing model we talked about the second one uh is called the materialization model so basically what what the materialization model is going
{"source": "grass-yt-cc-by.0K0kI1H2KTE|shard_1004_48|create_multimodal_data.extract_yt_and_generate_transcripts.60|shard_1004|create_multimodal_data.generate_captions.50|shard_1004|create_multimodal_data.generate_captions.55", "params": {"id": "0K0kI1H2KTE", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 4701, "view_count": 4624, "age_limit": 0, "chapters": [{"start_time": 0.0, "title": "Introduction", "end_time": 108.0}, {"start_time": 108.0, "title": "Recap", "end_time": 278.0}, {"start_time": 278.0, "title": "Overview", "end_time": 435.0}, {"start_time": 435.0, "title": "Iterator", "end_time": 709.0}, {"start_time": 709.0, "title": "Runthrough", "end_time": 846.0}, {"start_time": 846.0, "title": "Iterator Approach", "end_time": 1104.0}, {"start_time": 1104.0, "title": "Materialization Approach", "end_time": 1581.0}, {"start_time": 1581.0, "title": "Vectorization Approach", "end_time": 2253.0}, {"start_time": 2253.0, "title": "Vectorization Model", "end_time": 2475.0}, {"start_time": 2475.0, "title": "Query Processing Models", "end_time": 2606.0}, {"start_time": 2606.0, "title": "Access Methods", "end_time": 2701.0}, {"start_time": 2701.0, "title": "Sequential Scan", "end_time": 2796.0}, {"start_time": 2796.0, "title": "Optimizations", "end_time": 2915.0}, {"start_time": 2915.0, "title": "Zone Maps", "end_time": 3180.0}, {"start_time": 3180.0, "title": "Late Materialization", "end_time": 3302.0}, {"start_time": 3302.0, "title": "Index Scan", "end_time": 3388.0}, {"start_time": 3388.0, "title": "Index Scan Example", "end_time": 3507.0}, {"start_time": 3507.0, "title": "Multiindex Scan Example", "end_time": 4701}], "like_count": 46, "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_1004/0K0kI1H2KTE.tar.gz"}}