Тёмный

External Sorting 

Prof. Dr. Jens Dittrich, Big Data Analytics
Подписаться 17 тыс.
Просмотров 14 тыс.
50% 1

external merge-sorting and replacement selection

Опубликовано:

 

15 дек 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@howard_yin
@howard_yin Год назад
thank you so much. I finally understood the replacement sort.
@frosty12k86
@frosty12k86 2 года назад
This is a great video. Thank You
@quanghieuvu1012
@quanghieuvu1012 Год назад
So what is the difference between external sort and block sort?
@bilcarebilkent3374
@bilcarebilkent3374 Год назад
Thank you, for the video, it is highly informative. I wonder that, what would happen if the initial number of pages were 9 or 10 which is not a power of 2. Because in this case, when merge pass happens, there is a buffer left with less number of pages.
@prachipatel6039
@prachipatel6039 3 года назад
Hello Dr. Jens Dittrich, Thank you for such a detailed explanation of external sorting. The only doubt I have is on Replacement Selection section. The slide which heading says "two main memory pages for run generation with quicksort" so here this is different technique of sorting using quick sort (I mean is it distribution sort?)? and then are doing replacement selection? I couldn't connected quicksort part with replacement selection. Would you please explain me?
@jensdit
@jensdit 3 года назад
No, it is still merge sort, the only change is how we generate the initial runs in Phase 0: Quicksort or Replacement Selection. For all passes >0 we then merge the streams iteratively
@vijaynagalla3989
@vijaynagalla3989 2 года назад
how can you put all the data into main memory, if the main memory is insufficient? and also clarify that on what basis the data is divided into x number of pages?
@jensdit
@jensdit 2 года назад
I don't. In pass 0 you only load two pages at a time into main memory, (marked with the green rectangle), sort them and then write them back to disk. In phases >=1 we need at least three pages: one for each of the input runs and one for the output run. I could have used three pages for phase 0, but it would not have created this nicely balanced merge tree.
Далее
14.478 Replacement Selection
15:00
Просмотров 16 тыс.
Recycled Car Tyres Get a Second Life! ♻️
00:58
Просмотров 3,5 млн
External Sorting - 2-way Sorting and Multi-way Sorting
26:40
Neural Network Learns to Play Snake
7:14
Просмотров 4,5 млн
UHCL 35a Graduate Database Course - Extendible Hashing
9:54
How the MD5 hash function works (from scratch)
14:00
Просмотров 1,1 тыс.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 175 тыс.
14.416 Sort-Merge Join, Co-Grouping
18:31
Просмотров 38 тыс.
Recycled Car Tyres Get a Second Life! ♻️
00:58
Просмотров 3,5 млн