Lecture

Indexing in Database Systems

Related lectures (32)

Indexing: File Organization & Techniques

Explores file organization, indexing techniques, and metadata in databases, emphasizing the importance of choosing the right search key.

File Organization and Indexing

Explores file organization, record formats, indexing techniques, and index classifications in databases, emphasizing the importance of efficient data storage and access.

Tree-Structured Indexing: B+ Trees Explained

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

File Organization and Indexing

Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.

Data Wrangling with Hadoop

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

File Systems: Organization and Indexing Techniques

Discusses file systems, focusing on data organization, indexing techniques, and their impact on database performance.

Storage: Tree Indexing

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

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

File Organization: Storage and Cache Management

Explores file and page organization in databases, cache management, and log-structured files.

Storage of geographic information

Covers the storage of geographic information using vector and grid formats, coordinate reference systems, and image formats.

Introduction to Database Systems

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

General Introduction to Big Data

Covers data science tools, Hadoop, Spark, data lake ecosystems, CAP theorem, batch vs. stream processing, HDFS, Hive, Parquet, ORC, and MapReduce architecture.

Database Systems: Data Storage

Discusses data storage in database systems, emphasizing efficiency and access times for different storage types.

Stockage et transmission des données 1: introduction; besoin de structure

Discusses the importance of structuring data for efficient storage and retrieval.

Storage Hierarchy: Understanding Data Management Systems

Discusses the storage hierarchy and buffer management in data-intensive systems.

Clustering: Unsupervised Learning

Explores clustering in high-dimensional space, covering methods like hierarchical clustering, K-means, and DBSCAN.

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.

Big Data Best Practices and Guidelines

Covers best practices and guidelines for big data, including data lakes, architecture, challenges, and technologies like Hadoop and Hive.

Hydrology Modeling: Routing System

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

Gitlab Agent for Kubernetes (`agentk`)

Covers the setup of a Gitlab agent for Kubernetes, focusing on installation, version control, and troubleshooting.