Lectures related to JIT Compilation: The Hyper Approach

Data Wrangling with Hive: Managing Big Data Efficiently

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

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

Introduction to Database Systems

Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.

Introduction to Database Systems

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

Hydrology Modeling: Routing System

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

Data Wrangling with Hadoop: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.

Real-time Intelligence: Data Challenges and Hardware Evolution

Explores data challenges and hardware evolution for real-time intelligence in the era of big data.

Data, big data, clouds and IoT

Explores data representation, databases, cloud computing, and challenges in the cloud environment.

Materialization Problems in Database Systems

Discusses materialization challenges in databases, query execution strategies, and performance implications.

Query Operators: Part 1

Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.

Modeling Hydrological Systems: Routing and Flood Retention

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

Views: SQL Queries Simplification

Explores how views simplify query writing and are key in data warehouses.

Query Operators: Joins and Query Processing Techniques

Discusses advanced query operators, focusing on join techniques and their processing methods in relational databases.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

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.

Relational Databases: Fundamentals and ACID Properties

Covers relational databases, transactions, and data consistency in the context of historical database typologies.

Block-oriented Execution: Query Processing in Database Systems

Explores block-oriented query processing in databases, emphasizing materialization challenges and optimized execution for data-intensive applications.

Vectorization: Optimizing Query Processing in Database Systems

Explores the vectorization model in query processing for database systems, optimizing performance for OLAP queries.

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Concurrency Control & Recovery in Databases

Delves into transaction management, concurrency control, and recovery in databases to ensure data integrity and system resilience.