Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
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