Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.
Introduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.
Covers MLIR, a compiler infrastructure for domain-specific computation, emphasizing the importance of multiple abstraction levels and higher-level semantics.
Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Explores challenges in modern DBMS, AQP trade-offs, and NAND flash technology evolution.
Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Covers Spark Data Frames, distributed collections of data organized into named columns, and the benefits of using them over RDDs.
