Optimizing Recursive QueriesExplores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.
Cost-based Query OptimizationExplores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Relational Query OptimizationCovers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Efficient GPU Join OptimizationDiscusses efficient GPU-accelerated join optimization for complex queries, aiming to improve optimization times and heuristic plan quality.
AQP and Modern DBMSExplores challenges in modern DBMS, AQP trade-offs, and NAND flash technology evolution.
Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Efficient GPU Join OptimizationCovers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Translation of forExplains the translation of for-expressions in Scala using map, flatmap, and filter functions, with examples and a discussion on its generalization to different types.