Lecture

Tree-Structured Indexing: B+ Tree

Related lectures (32)

Tree-Structured Indexing: B+ Trees Explained

Covers B+ Trees, a key data structure for efficient indexing in databases.

Hydrology Modeling: Routing System

Covers the modeling of hydrological systems, focusing on the retention of floods and the example of the Routing System.

Untitled

Storage: Tree Indexing

Explores storage layers, disk management, flash disks, and B+ tree indexing for efficient data retrieval.

Digital Archives and Virtual Museums

Delves into the transition from traditional to virtual museums, exploring digital archives and historical practices.

Data Wrangling with Hadoop

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

Relational Databases: Fundamentals

Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.

Disk Storage & Indexing

Explores disk storage anatomy, access times, buffer management, and tree-structured indexing techniques like B+ Trees.

Final Assignment Logistics

Discusses the logistics of the final assignment, focusing on forming groups and choosing topics.

Querying a database: the SQL language

Covers the basic principles of the SQL language and selection requests.

Methods of Applied Topology: Complexity of Data

Explores the complexity of data in databases and methods for extracting information.

Database History: Almost Complete

Covers experiments on seed sizes and colors in the history of databases.

Qualitative X-ray diffraction analysis

Explores the qualitative analysis of X-ray diffraction patterns for cementitious materials, focusing on identifying crystalline phases based on characteristic peak patterns.

Hashing and Sorting Techniques in Database Systems

Provides an overview of hashing and sorting techniques in database management systems, focusing on their implementation and performance optimization.

Indexing in Database Systems

Explores indexing in database systems, covering storage, files, and efficient data retrieval techniques using various types of indexes.

Swiss Solar Boat: Rear Assembly

Discusses the design and modeling of the Swiss Solar Boat's rear assembly.

Modeling Hydrological Systems: Routing and Flood Retention

Discusses modeling hydrological systems, focusing on routing and flood retention using a new database.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

The Forgotten Operator: Delete Tradeoffs in Data Stores

Explores the tradeoffs of delete operations in data stores, focusing on logical deletes and introducing the Lethe storage engine.

Blockchain Fundamentals: Structure and Transactions

Introduces blockchain fundamentals, covering structure, transactions, Proof-of-Work, security assumptions, Bitcoin transactions, Ethereum smart contracts, and limitations.