<transcript><audio_111>okay so the last one we're going to talk about is called the vectorization model and it's it's similar to the iterator model so each operator is going to implement a next function but instead of</transcript><transcript><audio_112>just returning a single tuple at a time for each call to the next function the operators are going to emit a batch of tuples um instead of just once we're going to have multiple tuples let's say you know it could be maybe we want to return 100 tuples at a time a thousand whatever we just want to</transcript><transcript><audio_113>return some number greater than one where we kind of batch them all together um and and return that to our the the parent that called our next function so uh basically the the the internal loop for</transcript><transcript><audio_114>each operator that's doing this this that's implementing the next call is going to uh batch up all of the the results do whatever operation we need to do on it and then return it as the the output of next</transcript><transcript><audio_115>and the the size the exact size is going to vary based on you know your hardware or your query properties or things like that so um again there are different considerations if you're in memory uh for example you might want your batch</transcript> okay so the last one we're going to talk about is called the vectorization model and it's it's similar to the iterator model so each operator is going to implement a next function but instead of just returning a single tuple at a time for each call to the next function the operators are going to emit a batch of tuples um instead of just once we're going to have multiple tuples let's say you know it could be maybe we want to return 100 tuples at a time a thousand whatever we just want to return some number greater than one where we kind of batch them all together um and and return that to our the the parent that called our next function so uh basically the the the internal loop for each operator that's doing this this that's implementing the next call is going to uh batch up all of the the results do whatever operation we need to do on it and then return it as the the output of next and the the size the exact size is going to vary based on you know your hardware or your query properties or things like that so um again there are different considerations if you're in memory uh for example you might want your batch
{"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"}}