Concept

PostgreSQL

Related lectures (20)

Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.

Transactions and Concurrency Control

Delves into lock-based concurrency control, deadlock handling, transaction models, and their limitations.

DDL, DML, Views

Covers SQL data definition, manipulation, and views in databases.

SQL: Data Manipulation and Views

Covers SQL data manipulation language, including DDL and DML commands.

Streaming Aggregation: JIT-compiled System

Explores challenges in scaling up window aggregation in JIT-compiled engines and presents a new system for streaming aggregation.

Vector-Vector Interactions

Covers interactions between vector layers in GIS using QGIS tools.

Querying a database: the SQL language

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Distributed Transactions: 2PC Principles and Replication Strategies

Explores 2PC principles, failure scenarios, and replication strategies in distributed transactions and discusses the transition from ACID to BASE properties in NoSQL systems.

Conditional queries: An Introduction to GIS

Covers conditional queries and joins in GIS, explaining operators and attribute selection based on conditions.

Quantum Optics I: Stern-Gerlach Experiment

Explores the Stern-Gerlach experiment, strong measurements, cavity quantum electrodynamics, and quantum optomechanics.

Vector-Vector Data Layer Interactions

Covers interactions between vector layers in GIS, including geometric properties, spatial arrangement, autocorrelation, altitude models, and SQL equivalents.

SQL Client-Server Architecture + IDE

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Query Optimization: Heuristics and Cost-based Strategies

Explores heuristic-based query optimization, join ordering, and cost estimation strategies in database systems.

Alfresco Formation: Document Management

Covers the basics of Alfresco document management, including creating sites, managing users and groups, and applying tags.

Data Wrangling with Hive: Managing Big Data Efficiently

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

Alfresco Formation Overview

Covers setting up Zoom meetings, managing instances on AWS, creating blog posts, managing users and groups, and utilizing advanced search features.

Aggregation Query and Result Sorting

Covers aggregation logic, sorting results, and writing SQL queries based on specific attributes.

Merging queries, embedded queries

Covers merging and embedded queries in SQL for Geographic Information Systems.

Moodle Environment

Explores the support services and environment of Moodle at EPFL, including group modes, admin tools, course management, and user interactions.

Parallel Databases

Explores parallel and distributed databases, covering architectures, query optimization, data storage, and distributed transactions.