Lecture

File Organization & Indexing

Description

This lecture covers the concepts of file organization, including heap and sorted files, and indexing methods to efficiently access data. It explains the storage of data on disk, file structures, record formats, page formats, and issues related to variable-length records. The instructor discusses different file organizations, such as heap files and sorted files, and introduces indexing techniques like creating efficient access paths. Additionally, alternative page formats like column store and partitioning attributes across are explored, along with their benefits. The lecture concludes with a comparison between heap files and sorted files based on a cost model for various operations.

This video is available exclusively on Mediaspace for a restricted audience. Please log in to MediaSpace to access it if you have the necessary permissions.

Watch on Mediaspace
About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.