Lecture
Indexing in Database Systems
Related lectures (88)
Quantum Chemistry
Covers eigenvalues, eigenfunctions, Hermitian operators, and the measurement of observables in quantum chemistry.
Storage: Tree Indexing
Explores storage layers, disk management, flash disks, and B+ tree indexing for efficient data retrieval.
File Systems
Covers the fundamentals of file systems, focusing on managing persistent blocks efficiently and implementing file system APIs.
Data formats and data wrangling with Hadoop
Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.
Decentralized Systems Engineering: Chord DHT
Covers the Chord DHT in decentralized systems engineering, focusing on reliability, redundancy, and structure maintenance.
Buffer Management and Page Layout
Explores magnetic disk anatomy, cache organization, file organizations, buffer management, and page layout in DBMS.
File Organization & Indexing
Explores file organization, indexing methods, and alternative page formats for efficient data access.
Disk Storage & Indexing
Explores disk storage anatomy, access times, buffer management, and tree-structured indexing techniques like B+ Trees.
File System Implementation and Journaling
Covers file system implementation, caching, journaling, and crash consistency.
Hashing & Sorting
Explores hashing techniques like static, extendible, and linear hashing, along with sorting methods such as external merge sort and B+ trees.